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 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 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.
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:
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]...
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?
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.
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:
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; } }
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: