How to passing selected value from each row of the gridview to another page textbox ?

Posted by SHAROOKH under ASP.NET on 3/4/2013 | Points: 10 | Views : 7891 | Status : [Member] | Replies : 2
Gridview conained two or more Data field like productid,productname etc .If gridview contained the select button click ,thats the selected row contained data will be show on to the another web page textbox or labels




Responses

Posted by: Satyapriyanayak on: 3/4/2013 [Member] [MVP] Silver | Points: 25

Up
0
Down
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Display_selected_records._Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateSelectButton="true" AutoGenerateColumns="true"
BackColor="#CCFFCC" Font-Bold="False" ForeColor="Maroon"
onselectedindexchanged="GridView1_SelectedIndexChanged">
<AlternatingRowStyle BackColor="#FFCC66" />
</asp:GridView>
<br />
<asp:Label ID="lb1" runat="server" Text="ID : " Font-Bold="True" Width="100px"></asp:Label>
<asp:Label ID="lbl_id" runat="server" ForeColor="#CC3300"></asp:Label>
<br />
<br />
<asp:Label ID="lb3" runat="server" Text="NAME : " Font-Bold="True"
Width="100px"></asp:Label>
<asp:Label ID="lbl_name" runat="server" ForeColor="#CC3300"></asp:Label>
<br />
<br />
<asp:Label ID="lb5" runat="server" Text="ADDRESS : " Font-Bold="True"
Width="100px"></asp:Label>
<asp:Label ID="lbl_address" runat="server" ForeColor="#CC3300"></asp:Label>
<br />
<br />
<asp:Label ID="lb7" runat="server" Text="MARK : " Font-Bold="True"
Width="100px"></asp:Label>
<asp:Label ID="lbl_marks" runat="server" ForeColor="#CC3300"></asp:Label>
<br />
<br />
<asp:Label ID="lb9" runat="server" Text="YEAR : " Font-Bold="True"
Width="100px"></asp:Label>
<asp:Label ID="lbl_year" runat="server" ForeColor="#CC3300"></asp:Label>
</div>
</form>
</body>
</html>


using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace Display_selected_records
{
public partial class _Default : System.Web.UI.Page
{
string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
string str;
SqlCommand com;
SqlDataAdapter sqlda;
DataSet ds;

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
lbl_id.Text = GridView1.SelectedRow.Cells[1].Text;
lbl_name.Text = GridView1.SelectedRow.Cells[2].Text;
lbl_address.Text = GridView1.SelectedRow.Cells[3].Text;
lbl_marks.Text = GridView1.SelectedRow.Cells[4].Text;
lbl_year.Text = GridView1.SelectedRow.Cells[5].Text;
}

void bindgrid()
{
SqlConnection con = new SqlConnection(strConnString);
con.Open();
str = "select * from student";
com = new SqlCommand(str, con);
sqlda = new SqlDataAdapter(com);
ds = new DataSet();
sqlda.Fill(ds, "student");
GridView1.DataSource = ds;
GridView1.DataMember = "student";
GridView1.DataBind();
con.Close();
}

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bindgrid();
}
}
}
}


If this post helps you mark it as answer
Thanks

SHAROOKH, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Santhi on: 3/4/2013 [Member] Starter | Points: 25

Up
0
Down
Hi

Refer this link.
This may be useful
http://www.dotnetcurry.com/ShowArticle.aspx?ID=147

Thanks & Regards,
Santhi .V

SHAROOKH, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response