<%@ Page
Language="C#"
AutoEventWireup="true"
CodeFile="Default2.aspx.cs"
Inherits="Default2"
%>
<!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></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1"
runat="server"
AutoGenerateColumns="false"
OnSelectedIndexChanging="GridView1_SelectedIndexChanging"
AutoGenerateSelectButton="True">
<Columns>
<asp:BoundField DataField="Name"
HeaderText="Name"
/>
<asp:BoundField DataField="Branch"
HeaderText="Branch"
/>
<asp:BoundField DataField="City" HeaderText="City" />
</Columns>
</asp:GridView>
<table>
<tr>
<td>
Name
</td>
<td>
<asp:TextBox ID="txt_name"
runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Branch
</td>
<td>
<asp:TextBox ID="txt_branch"
runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
City
</td>
<td>
<asp:TextBox ID="txt_city"
runat="server"></asp:TextBox>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
==========================================================================
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
public partial class Default2 :
System.Web.UI.Page
{
protected void
Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGridView();
}
}
//method for binding GridView
protected void
BindGridView()
{
DataTable dt = new
DataTable();
SqlConnection con = new
SqlConnection(@"Data
Source=KCLINK-PC;Initial Catalog=Naresh;Integrated Security=True");
SqlDataAdapter da = new
SqlDataAdapter("Select
name,branch,city from tbl_student", con);
con.Open();
da.Fill(dt);
con.Close();
if (dt.Rows.Count > 0)
{
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
protected void
GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
txt_name.Text = GridView1.Rows[e.NewSelectedIndex].Cells[1].Text;
txt_branch.Text = GridView1.Rows[e.NewSelectedIndex].Cells[2].Text;
txt_city.Text = GridView1.Rows[e.NewSelectedIndex].Cells[3].Text;
}
}
=================================================================
CREATE TABLE [dbo].[tbl_student](
[Id] [int] NULL,
[Name] [varchar](50) NULL,
[Branch] [varchar](50) NULL,
[City] [varchar](50) NULL)