How would I send a known variable to an asp.net app on the web?Like in dos, you would send <programname>.exe <parameter>How would you do that in asp.net?something like http://www.site.com/aspapp.aspx?parameter ??And then how do you read that data into the asp.net app being called??
View 2 RepliesWe generate xaml in .net4 framework module with the help of an xmlwriter. We want to be sure that the xaml is working properly in the silverlight application we use it in. To test the generated batch of xaml file we want to have a commandline tool that validates these files. How can we use the xamlreader to validate this, or are there any other ideas how to do this? In the current solution we use the XamlReader but if gives to following exception:
'Cannot create unknown type '{clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls}TreeView'.'
I've done some SSIS package work in the past, but am by no means an expert.
I want to use an SSIS package to do the following:
1. Get the file name of the newest file in a windows folder (using a filename template like his: filename_ *.txt where the * part is always a date in the format of yyyy-mm-dd.
2. Use that file name in later portions of the SSIS package by reading the file and transferring data from it to a SQL table using a Data Flow task.
and use the result (which should be the name of the newest file) to open that file and pull data out of it and into a 2nd SQL table. I admit, I'm not sure how to use the dynamic result of this SELECT query as the file name in a flat file connection manager.
I create a variable in code behind to save today's date.
[Code]....
And I want to save it as a parameter for an accessDataSource but I'm not finding anywhere that tells me how to do this properly. My attempts thus far have been
[Code]....
I need to use a global variable as a parameter for the SqlDataSource element. I capture the user Name when he/she logs in:
Public UserName As String
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
UserName = Page.User.Identity.Name
End Sub
Then, I need to use the UserName to search the SQL DB and show only logged user personal information.
SelectCommand="SELECT * FROM [Member] where [UserID]= UserName"
What is the sintaxe to use a global variable into the SQL Select Command?
i have a website that needs to send some querystring parameters when the user clicks a button.
example, when the users click a button, technically, it should call a [Code]....
but it should not go to that url, but instead go to other url.
I have two pages: Default.aspx and Edit.aspx.In Default.aspx, there is a tabcontainer control and there are 5 tabs in it. In each of these tabs, there is a gridview. And in each grid view there is a hyperlinkfield field called "Edit". I want that when a user clicks the "edit ", the page will redirect to Edit.aspx page with the current activetabindex of the 5. How do I write the DataNavigateUrlFormatString
View 7 RepliesI would to know how to pass variables. I have a variable in javascript but I dont know how to pass it to a textbox. I have read it is so easy using ajax, but I dont know how to use it. I believed this was just for not to have reload. Well, then how do I do it? I read I must use get and post, but I dont know how to use it.. for example I have the code:
function guardar() {
var completo = "hola mundo";
}
How do I get the variable completo to pass it in a textbox?
I have an image map in asp page that by clicking special part it should goes to another page also I need to send a variable.
<
area
shape="rect"
id="myrect"
coords="473,12,583,30"
href="Account/MyAccount.aspx?"
/>
I don't know how to assign a variable. I have variable in my code behind as follows,
string
ship = currentShipment.ShipmentKey.ToString();
Response.Redirect(ProcessFlow.
Config.URL
+ "Account/MyAccount.aspx?ShipmentKey="
+ ship);
I have new web form and I'm trying to send a value of label into the body area of an email when the form is submitted. my aspx and aspx.vb code is below -
The form only works when mail.body = "msg in quotes" but not when mail.body = TextBox1.text
.ASPX CODE:
<%@ Page Language="VB" Inherits="unclaimedTest" Src="unclaimedTest.aspx.vb" %>
<%@ import Namespace="System.IO" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-
[code]....
I am having the following piece of code that is not working:
<a href="#" onclick="Edit(@Interest);">edit</a>
where I have
@{string Interest=""}
This may be elementary user control stuff, but I can't get it to work.
How can I pass the Membership.GetUser.UserName variable (or any variable) through a user control parameter at load time?
[Code]....
The only thing that I was able to do was to create the User Control object in the code behind and then add it to the page. Although that works, it doesn't seem like the correct way to program.
My stored procedure expects a uniqueidentifier as a parameter. However, this unique identifier is stored in a table variable, which looks like this:
DECLARE @GiftGuid uniqueidentifie
I have a array of ArrayList as shown below:ArrayList[] m;My web service method takes this type as parameter.How can I send it to web service?When I do so the Web Service changes my array of ArrayList to Object[][]!
View 1 RepliesI have a stored proc. that returns the USL & LSL values for each of the 8 different Metrics. say, Defect Density (Upper Specification Limit) USL = 0.30 & Defect Density (Lower Specification Limit_ LSL = 0.05). Simillarly for 8 different Metrics. Why I need these Spec. Limits ?...Because I want o compare my project's Metrics Value displayed in the Grid View with the corresponding USL & LSL value of the same Metrics. IF Metrics Value is outside of USL & LSL Then I want to Mark the Metrics in Red Color.
1. STORED PROC "Get_Spec_Limits" Does Not Return Anything
2. Error : Object Reference Not set to an Instance of an Object, in the following "OnRowDataBound' Event
OnRowDataBound="GridView1_RowDataBound"
Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs) Handles GridView1.RowDataBound
Dim strConnection As String = "Data Source=******;Initial Catalog=Metrics;Integrated Security=True"
Dim objConnection As New SqlConnection(strConnection)
Dim da As New SqlDataAdapter("Get_Spec_Limits", objConnection)
da.SelectCommand.CommandType = CommandType.StoredProcedure
Dim Productivity_USL As New SqlParameter("@Productivity_LSL", SqlDbType.Float)
Dim Productivity_LSL As New SqlParameter("@Productivity_LSL", SqlDbType.Float)
Dim IDD_LSL As New SqlParameter("@IDD_LSL", SqlDbType.Float)
Dim IDD_USL As New SqlParameter("@IDD_USL", SqlDbType.Float)
Dim EDD_LSL As New SqlParameter("@EDD_LSL", SqlDbType.Float)
Dim EDD_USL As New SqlParameter("@EDD_USL", SqlDbType.Float)
Dim DRE_FS_LSL As New SqlParameter("@DRE_FS_LSL", SqlDbType.Float)
Dim DRE_FS_USL As New SqlParameter("@DRE_FS_USL", SqlDbType.Float)
Dim DRE_TS_LSL As New SqlParameter("@DRE_TS_LSL", SqlDbType.Float)
Dim DRE_TS_USL As New SqlParameter("@DRE_TS_USL", SqlDbType.Float)
Dim DRE_Code_USL As New SqlParameter("@DRE_Code_USL", SqlDbType.Float)
Dim DRE_Code_LSL As New SqlParameter("@DRE_Code_LSL", SqlDbType.Float)
Dim COQ_USL As New SqlParameter("@COQ_USL", SqlDbType.Float)
Dim COQ_LSL As New SqlParameter("@COQ_LSL", SqlDbType.Float)
Dim COPQ_USL As New SqlParameter("@COPQ_USL", SqlDbType.Float)
Dim COPQ_LSL As New SqlParameter("@COPQ_LSL", SqlDbType.Float)......................
I have a Stored Proc which uses a field in the database. that ends up being the user.identity.name. So, when the page loads, it grabs that name and uses it in the stored proc, which I'm which I'm wanting to designate in the sql datasource. But it only gives me choices of querystring, cookie, session, control, etc. My question is how to reference that variable as the parameter in the datasource?
View 3 RepliesI have a few applications/websites running with LINQ to SQL and the other day I decided to go ahead and optimize some of the queries, etc and I found that the size for variable length data types is derived from the parameter value instead of the column actual size? for example a column is defined as nvarchar(30). when I use linq to query that column with a value that's 5 characters long the parameter in sp_executesql will be defined as nvarchar(5)...this causes a major procedure cache bloat even for a small utility site that has a lot of queries is there a way to optimize this?
View 1 RepliesI want to send selected page value on querystring while navigating through paging. URL that is generating on paging are like this
[Code]....
I need to send a table with value as a parameter in a stored procedure. It is possible any how?
View 3 RepliesThe statement is correct:
<asp:HyperLink
ID="HyperLink2"
runat="server"
Text="Telefone(s)"
NavigateUrl='<%#
"~/Autenticados/DadosClienteTelefone.aspx?codSegurado=" + DataBinder.Eval(FormView1.DataItem, "INT_CODSEGURADO") %>'
/>
The HyperLink does not work, I click and does nothing
i have an accordion panel that is loading its values from a datasource, which is working fine. let's say it loads the 50 states from the states table. now inside each accordion panel, when expanded, i want to load a gridview with details of that specific state. also, i want to pull all the cities into another gridview from the cities table with stateID=@stateID.
i know this should be simple, but how do i pass the value of the stateID to the datasource of cities gridview? what is the syntax?
the abbreviated code i have so far is:
<cc1:Accordion ID="Accordion1" runat="server" DataSourceID="StatesDataSource" >
<HeaderTemplate >
<asp:Literal ID="ltrHeader" runat="server" Text='<%# Eval("name") %>'></asp:Literal>
</HeaderTemplate>
[Code]....
I want to send an image to a stored procedure variable that is varbinary(max) field, It works correctly when an image selected by fileupload and my image property has image file, and it can send to stored procedure. but when fileupload is empty I want to send NULL to stored procedure variable that is varbinary(max). I use DbNull.Value in C# code. But error occurs. What should I do for send Null to stored procedure?
View 3 RepliesStored procedure ALTER proc [dbo].[spSearchCombo](@searchBy nvarchar(50),@searchKey nvarchar(50)) as select * from CD_DETAILS where @searchBy like '%' +@searchKey+ '%' I'm using ASP.net2.0 with c# to extract rows basedon search key from a text box and searchBy for the column to be searched. When i use column name instead of @searchBy which comes from value selected from a ddropdownlist i get the desired result . There seems to be a problem with format of @searchBy and i get a blank page.
protected void btnSearch_Click(object sender, EventArgs e)
{
string constring = ConfigurationManager.AppSettings.Get("con").ToString();
SqlConnection conn = new SqlConnection(constring);
conn.Open();
SqlCommand cmdSP = new SqlCommand("spSearchCombo", conn);
cmdSP.CommandType=CommandType.StoredProcedure;
cmdSP.Parameters.Add(new SqlParameter("@searchBy",SqlDbType.NVarChar,50));
cmdSP.Parameters["@searchBy"].Value=ddlSearchBy.SelectedValue.ToString();
cmdSP.Parameters.Add(new SqlParameter("@searchKey", SqlDbType.NVarChar, 50));
cmdSP.Parameters["@searchKey"].Value=txtSearch.Text.Trim();
SqlDataAdapter da=new SqlDataAdapter(cmdSP);
DataSet ds=new DataSet();
da.Fill(ds);
this.dgv1.DataSource=ds.Tables[0].DefaultView;
dgv1.DataBind();
}
I have a label "lbl1" that I am trying to locate in a content page from the Master page. I want to do it dynamically so I am trying to pass the name of the control (which in this case is lbl1) through as a parameter. I don't get an error, it just doesn't work. If I do an alert to see what the string "temp" looks like, it is correct, but iit seems as if Javascript ignores it. I believe it has something to do with the '<%= not being interpreted correctly by the browser I'm sure it is a simple solution, but I can't figure it out!
</textarea></p>
<input type='hidden' name='ID[4]' value='104170' />
<input type='hidden' name='URL[4]' value='http://forums.asp.net/t/1540102.aspx' />
<input type='hidden' name='CAT[4]' value='DataSource Controls' />
<input type='hidden' name='BOARD[4]' value='microsoft' />
<input type='hidden' name='P_DATE[4]' value='Mar 25, 2010 04:38 AM' />
<input type='hidden' name='RANDOM[4]' value='MKH9Tb4zY' />
<input type='hidden' name='REPLIES[4]' value='3' />
<input type='hidden' name='USER[4]' value='aziz' />
<p><input class=subject type='text' size='90' name='SUBJECT[4]' value='DataSource Controls :: passing control parameter to sql datasource in code behind' /><select name='INDEXED[4]'><option value='1' selected>UPDATE</option><option value='2'>DELETE</option></select>Mar 25, 2010 04:38 AM - Replies: 3 CAT: DataSource Controls<a target=_blank href="http://forums.asp.net/t/1540102.aspx">View</a></p>
<p> <textarea rows=10 cols=100 name='POST[4]' onfocus='setSelRange(this, 0, 0)'/>
I need to pass the control parameter to Sql Datasource in code behind,
<asp:ControlParameter ControlID="DDL_RType" Name="rtype" PropertyName="SelectedValue"</textarea></p>
<input type='hidden' name='ID[5]' value='119283' />
<input type='hidden' name='URL[5]' value='http://forums.asp.net/t/1574009.aspx' />
<input type='hidden' name='CAT[5]' value='Forms Data Controls' />
<input type='hidden' name='BOARD[5]' value='microsoft' />
<input type='hidden' name='P_DATE[5]' value='Jun 30, 2010 11:12 AM' />
<input type='hidden' name='RANDOM[5]' value='vaWaIeNdo' />
<input type='hidden' name='REPLIES[5]' value='4' />
<input type='hidden' name='USER[5]' value='aziz' />
<p><input class=subject type='text' size='90' name='SUBJECT[5]' value='Forms Data Controls :: Pass parameter to object datasource in user control.' /><select name='INDEXED[5]'><option value='1' selected>UPDATE</option><option value='2'>DELETE</option></select>Jun 30, 2010 11:12 AM - Replies: 4 CAT: Forms Data Controls<a target=_blank href="http://forums.asp.net/t/1574009.aspx">View</a></p>
<p> <textarea rows=10 cols=100 name='POST[5]' onfocus='setSelRange(this, 0, 0)'/>
I have a gridview inside a user control bind to an object datasource. Now I want to bind the object datasource with a parameter from parent page. For this purpose I defined a public property in user control but how do I pass it with object datasource? I am calling from parent page like myusercontrol.parameter=querystring["id"]; How to bind object datasource with my parameter?
</textarea></p>
<input type='hidden' name='ID[6]' value='184482' />
<input type='hidden' name='URL[6]' value='http://stackoverflow.com/questions/3627231/datasource-with-parameter-in-aspx-page-to-move-in-user-control' />
<input type='hidden' name='CAT[6]' value='ASP.NET' />
<input type='hidden' name='BOARD[6]' value='stackoverflow' />
<input type='hidden' name='P_DATE[6]' value='Sep 2 10 at 12:49' />
<input type='hidden' name='RANDOM[6]' value='bYX0jeAEp' />
<input type='hidden' name='REPLIES[6]' value='2' />
<input type='hidden' name='USER[6]' value='aziz' />
<p><input class=subject type='text' size='90' name='SUBJECT[6]' value='asp.net - Datasource with parameter in ASPX page to move in user control' /><select name='INDEXED[6]'><option value='1' selected>UPDATE</option><option value='2'>DELETE</option></select>Sep 2 10 at 12:49 - Replies: 2 CAT: ASP.NET<a target=_blank href="http://stackoverflow.com/questions/3627231/datasource-with-parameter-in-aspx-page-to-move-in-user-control">View</a></p>
<p> <textarea rows=10 cols=100 name='POST[6]' onfocus='setSelRange(this, 0, 0)'/>
I have a page with some datasources in it. I am doing reenginering of the page itself and would like to split some parts of the page in several user controls. In my code I have an ObjectDataSource object with the following params
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
TypeName="DataSetTableAdapters.PhotosTableAdapter"
SelectMethod="GetPhotosForAlbum">
<SelectParameters>
<asp:ControlParameter Name="albumID" ControlID="txtAlbumID" Type="Int32"/>
</SelectParameters>
</asp:ObjectDataSource>
This piece of code automatically bind the hidden field "txtAlbumId" to the datasource. In my revision this datasource should be moved to a user control. What is the best way to handle a scenario like this?
</textarea></p>
<input type='hidden' name='ID[7]' value='34389' />
<input type='hidden' name='URL[7]' value='http://forums.asp.net/t/1627446.aspx' />
<input type='hidden' name='CAT[7]' value='Web Forms' />
<input type='hidden' name='BOARD[7]' value='microsoft' />
<input type='hidden' name='P_DATE[7]' value='Nov 26, 2010 08:25 PM' />
<input type='hidden' name='RANDOM[7]' value='UEVLcNi9r' />
<input type='hidden' name='REPLIES[7]' value='4' />
<input type='hidden' name='USER[7]' value='aziz' />
<p><input class=subject type='text' size='90' name='SUBJECT[7]' value='Web Forms :: How to parse a string variable for diplay in control' /><select name='INDEXED[7]'><option value='1' selected>UPDATE</option><option value='2'>DELETE</option></select>Nov 26, 2010 08:25 PM - Replies: 4 CAT: Web Forms<a target=_blank href="http://forums.asp.net/t/1627446.aspx">View</a></p>
<p> <textarea rows=10 cols=100 name='POST[7]' onfocus='setSelRange(this, 0, 0)'/> How can i display the string variable data "234,345,567,678" into a listbox?
i wish to parse the delimited string as seperate items.
the string can vary in length. </textarea></p>
<input type='hidden' name='ID[8]' value='175584' />
<input type='hidden' name='URL[8]' value='http://stackoverflow.com/questions/2866868/datasource-select-parameter-from-get-value' />
<input type='hidden' name='CAT[8]' value='ASP.NET' />
<input type='hidden' name='BOARD[8]' value='stackoverflow' />
<input type='hidden' name='P_DATE[8]' value='May 19 10 at 15:21' />
<input type='hidden' name='RANDOM[8]' value='XYAWdt1ps' />
<input type='hidden' name='REPLIES[8]' value='1' />
<input type='hidden' name='USER[8]' value='aziz' />
<p><input class=subject type='text' size='90' name='SUBJECT[8]' value='c# - DataSource Select Parameter from GET value' /><select name='INDEXED[8]'><option value='1' selected>UPDATE</option><option value='2'>DELETE</option></select>May 19 10 at 15:21 - Replies: 1 CAT: ASP.NET<a target=_blank href="http://stackoverflow.com/questions/2866868/datasource-select-parameter-from-get-value">View</a></p>
<p> <textarea rows=10 cols=100 name='POST[8]' onfocus='setSelRange(this, 0, 0)'/>How can I use the value of a GET form value as a SelectParameter?
Note: Both C# and VB.NET answers are fine.
</textarea></p>
<input type='hidden' name='ID[9]' value='46929' />
<input type='hidden' name='URL[9]' value='http://forums.asp.net/t/1542116.aspx' />
<input type='hidden' name='CAT[9]' value='Web Forms' />
<input type='hidden' name='BOARD[9]' value='microsoft' />
<input type='hidden' name='P_DATE[9]' value='Mar 31, 2010 01:51 AM' />
<input type='hidden' name='RANDOM[9]' value='iX9IkD8rq' />
<input type='hidden' name='REPLIES[9]' value='1' />
<input type='hidden' name='USER[9]' value='aziz' />
<p><input class=subject type='text' size='90' name='SUBJECT[9]' value='Web Forms :: How to pass parameter in DropdownList Datasource' /><select name='INDEXED[9]'><option value='1' selected>UPDATE</option><option value='2'>DELETE</option></select>Mar 31, 2010 01:51 AM - Replies: 1 CAT: Web Forms<a target=_blank href="http://forums.asp.net/t/1542116.aspx">View</a></p>
<p> <textarea rows=10 cols=100 name='POST[9]' onfocus='setSelRange(this, 0, 0)'/>
I just like to know how to pass a parameter to the datasource of my dllItemCodeFooter and dllItemCodeEdit Drowndownlist which calls my getItemCodeList(decimal categoryID) method in the code behind. The value of the parameter will be seletectedValue of the first dropdownlist ddlCategoryFooter or ddlCategoryEdit).I know it could be done in code behind, but i prefer to bind my datasource in asp page. I want to achieve something like this DataSource='<%# getItemCodeList(ddlCategoryEdit.Seletected)%>'
[Code]....
how can i set the parameter source of an SqlDataSource to a variable from visual studio?
View 2 Replies