Solved

Pass values from gridview to another page

Posted on 2008-10-20
9
556 Views
Last Modified: 2013-11-07
I have a gridview on a membership page that has a "select" button. However, I don't want this to be the normal select that the gridview has. I want it to do a response.redirect to another page and fill another gridview there.  In short, my question is how do I perform a querystring based on what row is selected in the gridview?
0
Comment
Question by:smitty68521
  • 5
  • 3
9 Comments
 
LVL 26

Expert Comment

by:Anurag Thakur
ID: 22764369
what needs to be done is that when you select the grid view row you handle the select on the same page (page having the grid view) in a suitable event (RowCommand event). In the row command event you can get the values from the grid view selected row and then create the query string and the redirect your page to the new page where you can retrieve the values from the query string and take actions accordingly
0
 
LVL 2

Accepted Solution

by:
spiderexpa earned 500 total points
ID: 22764658
Just add a hyperlink at the last column of the gridview as follows:->

<asp:HyperLinkField Text="Select" DataNavigateUrlFields="FIELDNAME1,FIELDNAME2" DataNavigateUrlFormatString="~/PAGENAME.aspx?QUERYSTRING1={0}&QUERYSTRING2={1}"/>

Here

1. FIELDNAME1, FIELDNAME2,... are the Field names from the database OR Alias used.
2. PAGENAME.aspx is the page where you want to re-direct.
3. QUERYSTRING1, QUERYSTRING2,.... are the corresponding Querystring names.


0
 
LVL 1

Author Comment

by:smitty68521
ID: 22764682
Would it start out like this:

GridView1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridView1.SelectedIndexChanged?

I would add my code here for the server.transfer?
0
Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

 
LVL 1

Author Comment

by:smitty68521
ID: 22764747
This is what I have tried so far:

1st page with the datagrid

Protected Sub GridView1_SelectedIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewSelectEventArgs) Handles GridView1.SelectedIndexChanging
        Context.Items.Add("ID", SqlDataSource2.ID)
        Server.Transfer("editproperty.aspx")

    End Sub

second page:

Label1.Text = Context.Items("ID")

When I run this, I click on the "select" button and get a windows authentication that comes up asking for a username/password.  Like it is wanting it to access the database.  I suppose I should have added this sooner.
0
 
LVL 2

Expert Comment

by:spiderexpa
ID: 22764780
No need to add/update GridView1_SelectedindexChanging  anything else in code behind for this issue. No need to use Server.Tranfer/ Response.Redirect.



Just add a hyperLinkFiled at the last column of the gridview as follows:->

<asp:HyperLinkField Text="Select" DataNavigateUrlFields="FIELDNAME1,FIELDNAME2" DataNavigateUrlFormatString="~/PAGENAME.aspx?QUERYSTRING1={0}&QUERYSTRING2={1}"/>

Here

1. FIELDNAME1, FIELDNAME2,... are the Field names from the database OR Alias used.
2. PAGENAME.aspx is the page where you want to re-direct.
3. QUERYSTRING1, QUERYSTRING2,.... are the corresponding Querystring names.
0
 
LVL 1

Author Comment

by:smitty68521
ID: 22765024
I done as you told me:

Hyperlink
DatanavigateUrlfield= "ID"
DatanavigateUrlFormatString = "editproperty.aspx?value = {ID}

On the next page I have in the gridview datasource I have the control Label1.text set to the querystring {ID}

When I run the application I get the following error:

Input string was not in a correct format
0
 
LVL 2

Expert Comment

by:spiderexpa
ID: 22765053
Replace value = {ID} with value = {0}
0
 
LVL 1

Author Comment

by:smitty68521
ID: 22765059
Thanks. Right after I sent that, I realized what I was doing.
0
 
LVL 1

Author Closing Comment

by:smitty68521
ID: 31508135
Awesome expert
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

789 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