I haven't had the need to do this before but I want to send a list of IDs in for a query string value in ASP.NET:
?ListOfIDs=1234;3224;&SecondParam=somevalue&ThirdParam=....
I don't think you can add ; or commas right? I couldn't really find a good reference talking about what you can or can't pass in a url.
How can I return a comma delimited list of codes for each client, to a temp field in the results of a select statement in a stored procedure?
Is it posible to get a comma delimited list into a temp field of a temp table?
I have a table tblCodes that has the following fields ClientID, CodeID
I have a table tblCodeLookup that has the following fields CodeID, CodeDecription
I need to get a temp table with two fields ClientID and a field that holds a comma delimited list of CodeDescriptions for each clientID. Maybe the tmp fiel would be named ClientsCodes Select clientID, ClientsCodes
I have a Database and In This Database I have store Comma Separated Images in gridview
eg ID Name Images
1 War image1.jpg,images2.jpg,image3.jpg
I know How to Display image in gridview but how this....
How can I combine multiple rows into a comma-delimited list in sql server in build function?? in HCL
examples :
X
---
12
15
18
20
Output : 12, 15, 18, 20
with in build function of sql server.
I stucked at a condition , where i need to share values between the pages. I want to share value from Codebehind via little or no javascript. I already have a question here on SO , but using JS. Still did'nt got any result so another approach i am asking.
So I want to know can i pass any .net object in query string. SO that i can unbox it on other end conveniently.
Update
Or is there any JavaScript approach, by passing it to windows modal dialog. or something like that.
What I am doing
What i was doing is that on my parent page load. I am extracting the properties from my class that has values fetched from db. and put it in a Session["mySession"]. Some thing like this.
Session["mySession"] = myClass.myStatus which is List<int>;
Now on one my event that checkbox click event from client side, i am opening a popup. and on its page load, extracting the list and filling the checkbox list on the child page.
Now from here user can modify its selection and close this page. Close is done via a button called save , on which i am iterating through the checked items and again sending it in Session["mySession"].
But the problem is here , when ever i again click on radio button to view the updated values , it displays the previous one. That is , If my total count of list is 3 from the db, and after modification it is 1. After reopening it still displays 3 instead of 1.
I need to pass '+' via the QueryString.
some special character can be passed by using 'Encode' .. but '+'
I know the one solution, If I replace '+' with other character.
But it's not the perfect solution.
[edited]
well I used escape() javascript function to encode.
escape function can't encode + . is the another function to encode on javascript?
I have one hyperlink I want to pass more than one parameter in hyperlink
but cant pass perfect data in query string
using database.
same data pass in another page using this code.
<asp:HyperLinkField DataNavigateUrlFields="Product_Id" Target="_blank" DataNavigateUrlFormatString="AddprodPhoto.aspx?Product_Id={0}&Catalog_Id={0}" Text="Upload">
o/p
[URL] ....
product_id pass right Catalog_Id=2 is wrong
i am new to ASP.net website programming i have a page with dropdown list connected with batabase file. I put Image button that automatically retreive image from default project location but it does not accessing image from folder that i made for images. Secondaly i want to send the information to another page that when user click the image button of any record it move to another page showing the same image and its details. i made the second page with detailsview control and it also showing large image and information but how to pass argument (querystring)to second form whith record id and second form show it. detail about what to write behind the button_click trigger and other changes.
View 4 RepliesNow that i learned how to pass values to an SWF object via flashvars, how can i pass values from a querystring to javascript?
What do i mean? In the following example i hard-code the xml file to load in the SWF object.
<script type="text/javascript">
var so = new SWFObject("preview.swf", "", "100%", "100%", "9", "#ffffff");
so.addParam("allowFullScreen", "true");
so.addParam("scale", "noscale");
so.addParam("menu", "false");
so.addVariable("xmlPath", "xml/exampleData.xml");
so.write("flashcontent");
</script>
Since the Xml file is created dynamic, the xml should be loaded from the value of a query-string. (I guess).
Supposing my url is http://www.example.com/load.aspx?XmlFile=SomeData
How can i pass it to the javascript side? Like..
so.addVariable("xmlPath", "xml/<% SomeData %>.xml");
or whatever it needs to make it work.
UPDATE: Besides the above example, is there any way of creating the JavaScript, in server-side?
i need to bind the menu dynamically,i put the menu in the UserControl and i pass to it QueryString["menuid"]or example if i put in hyperlink [URL]bind all the submenus based on the menuid=1 i got the error when i did this HierarchicalDataBoundControl only accepts data sources that implement IHierarchicalDataSource or IHierarchicalEnumerable.Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidOperationException: HierarchicalDataBoundControl only accepts data sources that implement IHierarchicalDataSource or IHierarchicalEnumerable.Source Error:
[Code]....
Source File: c:EcommerceFrontEnd.master.cs Line: 19 Stack Trace:
I want to rewrite url by removing query string question mark and put a slash instead
Used this to remove .aspx
So my urllooks like this http://localhost:10089/Coding
<rewrite>
<rules>
<rule name="Hide .aspx ext">
<match url="^(.*)$" ignoreCase="true" />
<conditions>
<add input="{REQUEST_FILENAME}" matchType="IsFile" negate="true" />
[Code] ....
I want to remove http://localhost:10089/Read?ID=1
i want to remove query string and make url like
http://localhost:10089/Read/ID/1
I tried this
<rule name="Rewrite for Read" stopProcessing="true">
<match url="^Read/([^/+])?$" />
<action type="Rewrite" url="Read.aspx?ID={R:1}" />
</rule>
But not working how do i achieve this....
I have a screen and in the code behide i have private class created inside the page
In this class i have a Hashtable
i will like to pass this hashtable from one screen to another by Querystring
It works when i pass the querystring on the browser as this: http://localhost:51765/foo/foo.aspx?ID=c516f4f4-36a9-40a7-baad-d2419ea631b9 want it to work when the page load not when i pass the querystring on the browser.
<asp:SqlDataSource ID="categoriesDataSource" runat="server"
connectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT [CategoryID], [Name] FROM [Categories] WHERE ([UserId] = @UserId) ORDER BY [Name]">
[code]...
<asp:MenuItem
Text="Airport Authorities"
Value="New Item"
NavigateUrl="sub_cat_list.aspx?cat_id=<%=Encryption("1")%>"
separatorImageUrl="border.gif"
>
Literal content ('<asp:MenuItem Text="Airport Authorities" Value="New Item" NavigateUrl="sub_cat_list.aspx?cat_id=') is not allowed within a 'System.Web.UI.WebControls.MenuItemCollection'.
how to pass querystring in menuitem contorl?
I defined a report with a parameter (ID_Aluno) in Crystal Reports to show it in an .aspx page. The page is called by another page passing it a query string with the value I need as a parameter in the report. In the code behind file I tryed three different approches without success. What happen is that the report is showed without data, but when I open the parameter panel I see that the parameter is there (If I don't set the parameter value actually it complains that the parameter is missing, giving an arror).
Here is the code I used to set the parameter:
[Code]....
The First try (code not commented) is the one I would like to use because it is the shorter and simpler one.
Here is the mark up for the report source and report viewer:
[Code]....
Have I to declare or define something special in Crystal Reports for the parameter to be received and applied?
query string value not passsing operator sign
eg
i have a dropdown box under o+ but o only passing to another page
I am developing a web application and I am using a crystal report for my project, how can I pass the query string to the crystal report using the database.
View 1 RepliesI did it and it worked but when i wrote these code in addressbar i see this address
http://localhost:1420/behtop%20website/Store.aspx
I want this
E.g.:
When user type behcode =1111 in TEXTBOX when click on button it go to store.aspx but i want in addressbar see this address
http://localhost:1420/behtop%20website/1111
instead of store.aspx write 1111
How I can do it?
I'm using GridView with a hyperlink column, and I want to do the following:
DataNavigateUrlFormatString="~/student/group/document/Body.aspx?DID={0}&GN={QueryString("GN")}" HeaderText="View Document" Text="view" />
How I can retrieve the value of GN from the QueryString parameter and add it to the hyperlink column ?
Is it possible to click on the day within the calendar control and pass a query string. The calendar is database driven.
View 1 Replies.cs code is
[Code]....
and .aspx code is
[Code]....
now i want to pass value in Reply.aspx?C={0} to stored procedure
I am looking to pass a value into a query string. I am rendering a page right now called UserDetails.aspx?id=23 and in ASPX page I have a Gridview like this:
<asp:GridView ID="dgDetails" runat="server" AutoGenerateColumns="false">
<Columns>
<asp:BoundField DataField="txtName" SortExpression="txtName" HeaderText="User Name" />
<asp:TemplateField HeaderText="Permissions">
<ItemTemplate>
<a href="javascript:void(0);" onclick="javascript:pop('Perms.aspx?id=<%# DataBinder.Eval(Container.DataItem, "intUserAccount") %>&hu=<%# DataBinder.Eval(Container.DataItem, "intUserAccountWorkspace") %>', 600, 300);
return false;">Details</a>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
I want to take the "id=23" query string from the current page and pass it onto this link (in bold).
This is my last thread [URL] ....
I want to use Query string instead of session how i can do it?
I have a requirement in my application that, while saving the application, need to get all the value from drop down list and pass it to the view model. But application should not allow the user to select more than one item from drop down list manually, ie, only one value at a time. My view model is like ...
public class ListManagement
{
public IEnumerable<selectListItem> InactiveProduct { get; set; }
public string[] InactiveProductSelected { get; set; }
public IEnumerable<selectListItem> ActiveProduct { get; set; }
}
[code]...
I have a question related to <asp:SqlDataSource's SelectCommand. How to pass a querystring like <%# Eval("PhotoID") %> in the selectCommand. The whole frontend code is attached. I put
<%# Eval("PhotoID") %> and the photoid gets printed in the page.
<%# Eval("PhotoID") %> is the current displayed picture's PhotoID.
I want to pass this PhotoID or I want to pass <%# Eval("PhotoID") %> to the select command dynamically. I have tried the following approaches:
1) <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:aspnetdb %>" SelectCommand="SELECT UserName, commentDesc, uID FROM photo_comment_view Where pID = @pID"> <SelectParameters><asp:Parameter Name="pID" DefaultValue="7" /></SelectParameters> </asp:SqlDataSource> The above works but it gives only information about PhotoID 7, but there are other photos; How to set pID's value to <%# Eval("PhotoID") %> in ASP .NET's frontend page? then I also tried,
2) <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:aspnetdb %>" SelectCommand="SELECT UserName, commentDesc, uID FROM photo_comment_view Where pID = <%#'Eval("PhotoID') %>"></asp:SqlDataSource> Gives Parser error: Parser Error Message: The server tag is not well formed.
What I should do so that I can pass current PhotoID to SelectCommand? The frontend code:
<%@ Page Language="VB" MasterPageFile="~/Default.master" Title="Your Name Here | Picture Details"
CodeFile="Details.aspx.vb" Inherits="Details_aspx" %>
<asp:content id="Content1" contentplaceholderid="Main" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<div class="shim solid"></div>
<div class="page" id="details">
<%--Update Panel Here--%>
<asp:UpdatePanel runat="server" ID="updatepanel">
<ContentTemplate>
<asp:formview id="FormView1" runat="server" datasourceid="ObjectDataSource1" cssclass="view"
borderstyle="none" borderwidth="0" CellPadding="0" cellspacing="0" EnableViewState="false" AllowPaging="true">
<itemtemplate>
<div class="buttonbar buttonbar-top">
<a href="Albums.aspx"><asp:image ID="Image1" runat="Server" skinid="gallery" /></a>
<asp:ImageButton ID="ImageButton9" Runat="server" CommandName="Page" CommandArgument="First" skinid="first"/>
<asp:ImageButton ID="ImageButton10" Runat="server" CommandName="Page" CommandArgument="Prev" skinid="prev"/>
<asp:ImageButton ID="ImageButton11" Runat="server" CommandName="Page" CommandArgument="Next" skinid="next"/>.................