Solved

How do I pass a Query String variable from one page to another?

Posted on 2009-04-09
10
707 Views
Last Modified: 2013-12-17
I have written a web site in C# .Net using Visual Studio 2008. I am using the asp.net 3.5 listview control bound to a linqdatasource on my page. I simply want to know how to pass a variable from my listview onto another page containing a listview. I thought the attached would work in my second listviews linqdatasource but I keep getting the error: "Object expected"? The variable I am trying to pass is TrustID. I am using the below link from within my first listviews itemtemplate to open a popup page and pass my variable into the second listview...

<a href="#" id="accountsLink" onclick="wopen('trustAccounts.aspx?trustid=<%#Eval "TrustID")%>', 'popup', 400, 250); return false;" >Pass Variable to ListView 2</a>
<asp:LinqDataSource 
                                            ID="LinqDataSourceAccounts" 
                                            runat="server" 
                                            ContextTypeName="TrustSystemMARTINSPALDINGDataContext"
                                            EnableDelete="True" 
                                            EnableInsert="True" 
                                            EnableUpdate="True"
                                            TableName="TrustAccounts" 
                                            onselecting="LinqDataSourceAccounts_Selecting" 
                                            Where="TrustID = @trustID">
                                            <WhereParameters>
                                                <asp:QueryStringParameter 
                                                    Type="Int32" 
                                                    DefaultValue="706" 
                                                    Name="TrustID" 
                                                    QueryStringField="TrustID" />
                                            </WhereParameters>
                                        </asp:LinqDataSource>

Open in new window

0
Comment
Question by:Shepwedd
  • 5
  • 2
  • 2
  • +1
10 Comments
 
LVL 5

Expert Comment

by:burningmace
ID: 24106295
Use a session. When you create a session, the variables stored for that session (server side) are kept between pages. A few tutorials and infomation pages are below:

http://asp.net-tutorials.com/state/sessions/
http://www.beansoftware.com/ASP.NET-Tutorials/Managing-Sessions.aspx
http://msdn.microsoft.com/en-us/library/ms972429.aspx
http://quickstart.developerfusion.co.uk/QuickStart/webservices/doc/Intrinsics.aspx

You can also try googling for "ASP.NET Sessions" or "ASP.NET Session Tutorial".

Cheers,
Burningmace
0
 
LVL 10

Expert Comment

by:GeoffSutton
ID: 24106319
What happens if you check the TrustID value in the Page_Load (Request["TrustID"] or Request("TrustID") in VB).  Also, have you tried Where='<%=Request["TrustID"] %>' and get away from the Query Parameters?
Geoff
0
 
LVL 28

Expert Comment

by:sybe
ID: 24106549
Session is a bad idea. Sessions are meant for (as the name says) "sessions". Using a session will go wrong for example when a user has two windows open on your application.

<%=Request.Querystring("TrustID")%> should work
0
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 

Author Comment

by:Shepwedd
ID: 24106809
sybe,

Where exactly would I place your code? Obviously inside the .aspx page but where? Instead of the <%#Eval "TrustID")%>?

Thanks.
0
 
LVL 28

Expert Comment

by:sybe
ID: 24106822
> Instead of the <%#Eval "TrustID")%>?

If that is where you need it, then yes, put it there.
0
 

Author Comment

by:Shepwedd
ID: 24106881
I've now changed LinqDataSource code of the listview receiving the variable to the attached but I still get the same error?
<asp:LinqDataSource 
                                            ID="LinqDataSourceAccounts" 
                                            runat="server" 
                                            ContextTypeName="TrustSystemMARTINSPALDINGDataContext"
                                            EnableDelete="True" 
                                            EnableInsert="True" 
                                            EnableUpdate="True"
                                            TableName="TrustAccounts" 
                                            onselecting="LinqDataSourceAccounts_Selecting" 
                                            Where='<%=Request.Querystring("TrustID")%>'>
                                        </asp:LinqDataSource>

Open in new window

0
 

Author Comment

by:Shepwedd
ID: 24106904
GeoffSutton,

How do I check the TrustID value in the Page_Load?

I've tried your code: Request["TrustID"] in my code behind page_load event but it errors?
0
 
LVL 10

Expert Comment

by:GeoffSutton
ID: 24107320
Sorry... Are you using C# or VB.NET?  With C# you would put a line something like "String tmp=Request.Querystring["TrustID"]" and in VB.NET use 'Dim tmp as String = Request.Querystring("TrustID")'.
Then put a break on that line then run the application.  Once the application breaks on that line you can mouse over the variables and find out their values.  This will ensure that the correct data is being passed and read.  Note:  You will have to hit F11 once for tmp to acquire the value.  If you are getting a value, then in your LINQDatasource, put the same thing (Where='<%=Request.Querystring("TrustID")%>' in VB.NET, Where='<%=Request.Querystring["TrustID"]%>' in C#).  If you are still getting the same error, then the TrustID is not the source of your problems.
Let me know how this works for you.
Geoff


0
 

Author Comment

by:Shepwedd
ID: 24136450
GeoffSutton,

I'm using C#. After using your code my tmp variable is returning null? From my first listview (lvTrustAccounts) I have a button within my itemTemplate which has an onclick event equal to:

Response.Redirect("trustAccounts.aspx?trustid=" + lvTrustAccounts.SelectedValue);

The select statement within this listviews linqdatasource returns the TrustID among other values so I'm not too sure why my page_load is returning null?


0
 

Accepted Solution

by:
Shepwedd earned 0 total points
ID: 24136766
This solution is as simple as:

<asp:HyperLink runat="server" id="hlNavigate" NavigateUrl='<%#  "~/trustAccounts.aspx?Id=" + Eval("TrustID") %>' Text="Accounts" />
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question