In this example i am describing how to Pass Transfer Or Send GridView Row Data Values To Other asp.net page using hyperlink.
You would also like to read
LinkButton in GridView and QueryString in ASP.NET to pass data
We need to set DataNavigateUrlFields and DataNavigateUrlFormatString properties of hyperlink in gridview to pass the row data
HTML markup of the page
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1"> <Columns> <asp:HyperLinkField DataNavigateUrlFields="ID,Name,Location" DataNavigateUrlFormatString= "Default2.aspx?id={0}&name={1}&loc={2}" Text="Transfer values to other page" /> <asp:BoundField DataField="ID" HeaderText="ID" SortExpression="ID" /> <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" /> <asp:BoundField DataField="Location" HeaderText="Location" SortExpression="Location" /> </Columns> </asp:GridView> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT [ID], [Name], [Location] FROM [Details]"> </asp:SqlDataSource>
Now write code mentioned below to retrieve values on Default2.aspx page
C# code behind
protected void Page_Load(object sender, EventArgs e) { string strID = Request.QueryString["id"]; string strName = Request.QueryString["name"]; string strLocation = Request.QueryString["loc"]; lblID.Text = strID; lblName.Text = strName; lblLocation.Text = strLocation; }
VB.NET code behind
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Dim strID As String = Request.QueryString("id") Dim strName As String = Request.QueryString("name") Dim strLocation As String = Request.QueryString("loc") lblID.Text = strID lblName.Text = strName lblLocation.Text = strLocation End Sub
Hope this helps
If you like this post than join us or share
24 comments:
please, can you post the whole source code in vb.net with the asp.net pages
This comment has been removed by a blog administrator.
This comment has been removed by a blog administrator.
IN THIS HOW TO CREATE HYBERLINK IN FIRST COLUMN(REFERENCE NO.).WHILE CLICKING HAVE TO OPEN NEW ASP PAGE. GIVE ME THE SOLUTION.(ASP.NET 2005 AND SQL SERVER 2005)
Private Sub dataload()
Dim i As Integer
i = 0
Dim constr As String = "Data Source=muru\server2005;Initial Catalog=mis;User Id=sa;Password=professional2005;Integrated Security=False"
Dim objconnection As New SqlConnection(constr)
objconnection.Open()
Dim sqlstr As String = "SELECT NO AS REFNO,DATE,RONO,RODT,CLIENT,FDATE,TDATE,AMOUNT FROM RO07_08 ORDER BY DATE,CLIENT"
Dim ds As New DataSet
Dim da As SqlDataAdapter = New SqlDataAdapter(sqlstr, objconnection)
da.Fill(ds, "ro07_08")
If ds.Tables(0).Rows.Count = 0 Then Exit Sub
dgv.DataSource = ds.Tables(0).DefaultView
dgv.DataBind()
objconnection.Close()
da.Dispose()
da.Dispose()
sqlstr = ""
End Sub
Hi Friend this works great I was seaching from long time on net thanks for this code I am making a forum will use it in this but still I want a code that when people reply to question the replied question gets posts below answer
any reply or help appreciated
thanks a lot
thanks you
Thanks it works for me.....
This comment has been removed by a blog administrator.
I love this site csharpdotnetfreak.blogspot.com. Lot of great information. I am Tech guy. I have been a Desktop Technician since 1997 but have tons of other interests. In my spare time... Oh, wait I don't have any of that (just kidding). Anyways, I have been aware of this website for quite some time and decided to join the community and contribute as well as learn a lot from others. I am excited to get started on the forum and am looking forward to a great journey together. Lots of potential friends and I look forward to meeting many online.
best one for developing web development knowledge
sir i did the same thing what u have given but there s error n connectionstring can u help me out
after i am getting the values in the textbox which is in default2.aspx if iam trying to update i cant able to update the record kindly give code
how to update the Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
Dim strID As String = Request.QueryString("id")
Dim strName As String = Request.QueryString("name")
Dim strLocation As String = Request.QueryString("loc")
lblID.Text = strID
lblName.Text = strName
lblLocation.Text = strLocation
End Sub
after this how to update the querystring ,in button click plz tell me the code
thank u very much
I was little bit of confusing whenever there is use of Hyperlink field but now thanks a lot to u to make me understood.
That is the Quiry string extension
how can i get an image also to another page which is in gridview?
HOW CAN I GET IMAGE TO ANOTHER PAGE WHICH IS IN GRIDVIEW BY CLICK ON THAT IMAGE?
Hi i used the above code for passing a row values of a grid from one page to another page. the text "Transfer values to other page" is not hyperlinked while am run my page. Help me for this task......
How do i the value that i get from the Hyperlink as a parameter in the same page?
tried to use this with linq to sql but got an error on the page with the gridview stating that System.WEB.UI.WebControls.DataControlField Collection is not allowed. Any thoughts?
This comment has been removed by a blog administrator.
thanks a lot...................
Thank Youuuu
Post a Comment