How to show Gridview row into textboxes and then how to update that value?

Posted by Raghuldrag under C# on 6/6/2013 | Points: 10 | Views : 2096 | Status : [Member] | Replies : 1
Hi all,
Can anyone give me code for below scenario

First I get data from table and show in the datagrid of asp.net
When i click the First row of GridView it must come to the textboxes
like this
Texbox1.Text=ganesh(name)
TextBox2.Text=21(age)
TextBox3.Text=MCA(degree)
with update also how to do that?




Responses

Posted by: Satyapriyanayak on: 6/6/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

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

Login to post response