i have a function which returns a value from a query string parameter, i use it in more than 10 places in the webapp thus i have to rewrite the code every time, again and again.so to make it short, is there any way i can embed the code somewhere and keep referring to it through out my app?
View 10 RepliesI'm tring to create a vb.net 3.5 function that can return either a string or nothing.
Public
Shared
Function MakeLookupField(ByVal pasString
As
String)
[Code]....
What can I set the return variable to return either a string or null value
how to pass through a query string parameter of an assignment id and then checking and validating this as a number and displaying the information returned on screen. At present I have code which displays the information on screen but this is by entering in the assignment id and by triggering the button click event, I've shown the code for this below:
.aspx
<div>
<b>Current Assignment</b>
<br />
<asp:TextBox runat="server" ID="txtAssignmentID"></asp:TextBox>
<asp:Button runat="server" Text="Get Assignment" />
<br />
<b>Date Started:</b> <asp:Label runat="server" ID="lblAssignmentStart"></asp:Label>
<br />
<b>Status:</b> <asp:Label runat="server"></asp:Label>
<br />
<b>Current Achievement Level:</b> <asp:Label runat="server" ID="lblAssignmentLevel"></asp:Label>
<br />
<b>Date Last Calculated:</b> <asp:Label runat="server" ID="lblAssignmentCalcDate"></asp:Label>
<br />
</div>
.cs
protected void cmdGetAssignment_Click(object sender, EventArgs e)
{
//Check the assignmentID is an integer
int AssignmentID = 0;
try
{
AssignmentID = TypeConv.CInt(txtAssignmentID.Text);
}
catch
{
}
if (AssignmenttID > 0)
{
//Create new TCAAssignment object by passing the ID
TCA Assignment Current Assignment = abc.TCA Assignment (AssignmentID);
lblAssignmentStart.Text = Current Assignment.dDateCreated.ToString();
lblAssignmentStatus.Text = CurrentAssignment.rTCAAssignmentStatus.dDescription;
if (!CurrentAssignment.dTCAAchievementLevel.IsNull)
{
lblAssignmentLevel.Text = CurrentAssignment.rTCAAchievementLevel.dDescription;
}
lblAssignmentCalcDate.Text = CurrentAssignment.dAchievementDate.ToString();
}
}
Code example passing through a query string parameter of an assignment id would be great.
how can we hide the query string parameters in the URL in asp.net . but i am not interested to use url rewriting.
View 3 RepliesI have developed a web application 3 months ago to show facebook users by searching username. To access facebook, I have downloaded facebook dll and got application key, and secret key from facebook. My web application was working fine and displaying records from facebook. yesterday onwards, my application is not working fine. I could not get response when I search by name. I have tested the fql in the facebook testAPI tool online. That time i can get response. but the same fql i used in my appliation but it could not get response from facebook when I search by name. If i search by uid i can get response from facebook. here is my code.
facebook.Components.FacebookService fb = new FacebookService();
fb.ApplicationKey = "bfeefa69afdfe81975f0d6136ace3009";
fb.Secret = "9b672d682e1d8befd06382953fc2615b";
fb.IsDesktopApplication = false;
//the below fql gives response as xml.
//select name, profile_url from user where uid = '1730923544' -I can get response for this fql.
//the below fql does not give response as xml. But it gives empty string.
//the below fql does gives us response as xml when i try in facebook testAPI.
//select name, profile_url from user where name = 'Suresh Rajan' -I couldn't get response for this fql.
string s = fb.fql.query("select name, pic_square, profile_url from user where name = 'Suresh Rajan'");
if (String.IsNullOrEmpty(str1))
Response.Write("Empty Response");
else
Response.Write(str1 + " ");
how to search by name in facebook fql.
Need to hide query string values from web URL, So that no one should be able to recognize what values are passing from one page to another.
View 1 RepliesI 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]....
We are using a asp.net page to submit data to server. what we do is we will pass as parameter in url Query string) and in page load we take that values and submitting to database I have these following doubt
1, What is the default event happening while we call a ASP.NET page is it a POST or GET? We tried to call this url from a mobile application, it is not happening , we are not getting any error also in the mobile application.
2, IF we are calling the url to submit data from mobile applications which one we have to use (GET or POST)
3, IF we are calling this url from an application running in PC to submit which one we have to use ?
I'm having troubles passing a parameter to a handler in it's query string. I have a gridview with an image column, this column is defined as a TemplateField, as:
<asp:TemplateField
HeaderText="Image">
<ItemTemplate>
<asp:Image
ID="Image1"
runat="server" ImageUrl='~/ImageHandler.ashx?ID=<%# Eval("EmployeeID")%>'
/>
</ItemTemplate>
</asp:TemplateField>
As you can see, the ImageUrl is a call to a handler that receives the EmployeeID in the QueryString, under the name ID. When I run it, the ImageHandler method receives the following query string "ID=<%" instead of "ID=<the result of Eval("EmployeeID")>", and of course, it throws a FormatException when using it as an int to get the EmployeeID. (If I type ImageUrl="~/ImageHandler.ashx?ID=<%# Eval("EmployeeID")%>" (using " instead of ') the compiler returns the error incorrect server tag) The complete markup is:
<asp:SqlDataSource
ID="SqlDataSource1"
runat="server"
ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
SelectCommand="SELECT [EmployeeID], [LastName], [FirstName], [Photo] FROM [Employees]">
</asp:SqlDataSource>
<asp:GridView
ID="GridView1"
runat="server" DataSourceID="SqlDataSource1"
AutoGenerateColumns="False">
<Columns>
<asp:BoundField
DataField="EmployeeID"
HeaderText="ID" SortExpression="EmployeeID"
/>
<asp:BoundField
DataField="FirstName"
HeaderText="FirstName"
SortExpression="FirstName"
/>
<asp:BoundField
DataField="LastName"
HeaderText="LastName" SortExpression="LastName"
/>
<asp:TemplateField
HeaderText="Image">
<ItemTemplate>
<asp:Image
ID="Image1"
runat="server" ImageUrl='~/ImageHandler.ashx?ID=<%# Eval("EmployeeID")%>'
/>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
Could anybody tell me what am I missing here?
Rafael
I've a page in ASP.NET, whose appearance can change based upon a given parameter(say query string),
How can I achieve this in ASP.NET, Master pages concept won't work here, as even the contents of the page and positioning of the controls on the page can change based upon the parameter.
One solution I can think of is using XSLT, but is there any other solution I can use to solve this problem? Is there any concept of templates I can use here?
I tried to pass a string value into a JavaScript function like below: <%= "'" + prop.property_description + "'") %>) But it does not seems to be the best option, is there a better way to do the above without concatenate the string values with "'"?
View 2 RepliesI have a dropdown list that won't populate data values from database using sql datasource. When i use the code behind, i was able to populate the data to the dropdown list. I dont know how to pass the Query String Parameter using code behind since i am new in asp.net. This is the code behind:
Imports System.Data.SqlClient
Partial Class PhotoAlbum
Inherits System.Web.UI.Page
Dim oConn As New SqlConnection("Data Source=.SQLEXPRESS;" & _
"AttachDbFilename=|DataDirectory|ASPNETDB.MDF;" & _
"Integrated Security=True;User Instance=True")
Dim oCmd As New SqlCommand()
Dim oDR As SqlDataReader
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
oConn.Open()
oCmd.CommandText = "SELECT [CategoryID], [Name] FROM Categories ORDER BY [Name]"
oCmd.Connection = oConn
oDR = oCmd.ExecuteReader()
Me.categories.DataSource = oDR
Me.categories.DataTextField = "Name"
Me.categories.DataValueField = "CategoryID"
Me.categories.DataBind()
oDR.Close()
oConn.Close()
End Sub
End Class
I will like to include the following information from sqlDatasource to the codebehind:
SelectCommand="SELECT [CategoryID], [Name] FROM [Categories] WHERE ([UserId] = @UserId) ORDER BY [Name]">
<SelectParameters>
<asp:QueryStringParameter Name="UserId" QueryStringField="ID"/>
As you can see from the code behind, i was able to add :
"SELECT [CategoryID], [Name] FROM Categories ORDER BY [Name]".
But i will like to add all of this:
SelectCommand="SELECT [CategoryID], [Name] FROM [Categories] WHERE ([UserId] = @UserId) ORDER BY [Name]">
<SelectParameters>
I have a stored procedure that is close to working. It takes the values of a details view puts them into the respective table 'entity' then should also put the @@identity into 'entloan' and should put the LoanID which is in the query string of the page the detials view is loaded on, into the LoanID field of entLoan as well. Everything works except for getting the querystring value to pass to a insert variable on my stored procedure.
Stored Procedure
[Code]....
I do not have a LoanID Insert parameter set as it is not in entity table:
[Code]....
I have been playing around with different code in the backend but always get errors:
[Code]....
I have a datagrid and I set up the paging based on how many rows there are like this
With dgBookings
.AllowPaging = True
.PagerStyle.Mode = PagerMode.NumericPages
.PagerStyle.PageButtonCount = 5
.PageSize = 5
End With
Is there a way to set the horizontal-align in the code too I tried adding this
.PagerStyle.HorizontalAlign = Right
and I get this errorArgument not specified for parameter 'Length' of 'Public Function Right(str As String, Length As Integer) As String'.
how do i add a new parameter to an existing query string?
[URL]
now i need to add a new parameter say, showsearch.
I want to send selected page value on querystring while navigating through paging. URL that is generating on paging are like this
[Code]....
I have a standard Login form
<asp:Login ID="lgnExcel" DestinationPageUrl="login/data.aspx" OnAuthenticate="Login1_Authenticate" runat="server">
Is it possible to attach the Username as a query string with the DestinationPageUrl or reference the value in the code behind. I've tried lgnExcel.UserName.ToString()
Append Query String Parameter Values in Current URL.
I have added Hyperlink in data list.which is Bind with their Respective data.When I Click that Hyperlink it Will Pass Url like this.
Area_id,Cuisine_Id and Veg_Id Bind in Datalist
[URL]
I want to Built a Filter Page Which Includes Area_id, Cuisine_Id and Veg_Idso when i Click to Hyperlink of Area then url like this. [URL] And then After i click to hyperlink of Cuisine then URL Like this.
[URL]
Similar Way
[URL]
So Basically I want Filter Data With Clickable query Strings Parameter Values
Problem : How can i Make Url Like this and it is Dynamic
[URL]
I want to Do Something like this SitePage Filter
[URL]
In the original site, master page has code-behind to check a query string parameter value. Depending on this value, code-behind dynamically modify some CSS property to hide / display master page elements.
As MVC2 has no code-behind because we are supposed to perform everything in the controllers, how should I proceed in this case ?
I see this : [URL]
It partially answers my needs but the query string processing is common to all pages. How can I move this processing in a common code section ?
In my Application_BeginRequest I have code that gets query string value ?c=FR or ?c=US and store it in cookies.Based on query string value I have either US or FR,locale is selected from locale table.If ?c=FR then locale will be fr-FR and if it is US then locale will be en-US.My code is below.
void Application_BeginRequest(object sender, EventArgs e)
{
LocalizationInfo loc = GetLocalizationInfo();
if (Request.Cookies["Localization"] == null)
Response.Cookies.Add(new HttpCookie("Localization"));
Response.Cookies["Localization"]["Country"] = loc.Country;
CultureInfo objCI = new CultureInfo(loc.Locale);
Thread.CurrentThread.CurrentCulture = objCI;
Thread.CurrentThread.CurrentUICulture = objCI;
}
public static LocalizationInfo GetLocalizationInfo()
{
string countryCode = "";
string sLocale = "";
if (HttpContext.Current.Response.Cookies["Localization"]["Country"] != null)
countryCode = HttpContext.Current.Response.Cookies["Localization"]["Country"];
if (!string.IsNullOrEmpty(HttpContext.Current.Request.QueryString["c"]))
countryCode = HttpContext.Current.Request.QueryString["c"];
if (countryCode == "")
countryCode = "US";
sLocale = HertzRent2Buy.DataProvider.ListData.GetLocale(countryCode);
LocalizationInfo ret = new LocalizationInfo();
ret.Country = countryCode;
ret.Locale = sLocale;
return ret;
}
public struct LocalizationInfo
{
public string Country;
public string Locale;
}
Now when I run the project and in query string I set [URL] then for the very first page(home page itself) it shows me French translation,but on subsequent page,that query string parameter ?c=FR is lost and hence it shows be English translation not French translation since it does not pickup French resx file.If I manually append ?c=FR in subsequent page then it shows the French translation.Is there is way how I can make that query stringparameter available in all pages.Structure is there to hold Country and locale variables. In all pages I am calling GetLocalizationInfo() method as follow
LocalizationInfo info = some.DataProvider.Globalization.GetLocalizationInfo();
And I create instance info to pass locale and country as parameter. GetProductDetails(id,info.Country,info.locale). why my query string parameters get lost on subsequent pages.
How can I SELECT second if first SELECT returns nothing?
View 8 RepliesI've a MDX Query that has where clause as shown below.I'm designing report using SSRS 2008. How can i pass date as parameter? I tried to setup @from and @to as parameter but not working?
WHERE ( {[Date Central].[Calendar Date].[2010-04-01 00:00:00]:[Date Central].[Calendar Date].[2010-08-30 00:00:00]} )
need it to work as
WHERE ( {[Date Central].[Calendar Date].[@From]:[Date Central].[Calendar Date].[@To]} )
I have two sub routines that I've created to pull in my Membership user roles and assign the value/name of that role to the value of a cookie.
My first subroutine looks like this
[Code]....
At this point, role ID is a 1-dimentional array which is not acceptable for a cookie's value (it must be a string), but in Debug mode, I can see that the array does contain the correct roleID value. In my 2nd subroutine I change the value from array to string for no other reason than that it gives me an opportunity to see that the value of CookieValue() before it is converted does have the correct roleID.
[Code]....
Even though it still shows that string as having the correct value, it returns the object "System.String[]"
I have a gridview that has the header row modified in order to add new records; the gridview is bound to a sqldatasource control. In my code behind, i handle the insert in the following manner:
[Code]....
I know the insert is occuring because the new record shows up in the grid after the databind, but the output parameter is not picking up the scope_identity() value...what am i doing wrong with the output parameter?
I am having a problem with my sql query in c#, basically it's inline query with parameters, but when I run it it tells me that parameter 1 or parameter 2 is not there here is my query declared on top of the page as public:
public const string InsertStmtUsersTable = "insert into Users (username, password, email, userTypeID, memberID, CM7Register) " +
"Values(@username, @password, @email, @userTypeID, @memberID,@CM7Register ); select @@identity";
this is my code for assigning the parameters, I know I am having problem so I am assigning the params twice:
Username =(cmd.Parameters["@username"].Value = row["username"].ToString()) as string;
cmd.Parameters["@username"].Value = row["username"].ToString();
In 1 methopd it calls this query and tries to insert to table, here is the code:
Result = Convert.ToInt32(SqlHelper.ExecuteScalar(con, CommandType.Text,InsertStmtUsersTable));
Exact error message is: Must declare the variable '@username'. Could this code be a problem, because all the previous coding is declared with in this using statement, except declaration of query, here the using statement: using (SqlCommand cmd = new SqlCommand(InsertStmtUsersTable, con))