Note: - Here in gridview control add
AutoGenerateSelectButton="true" AutoGenerateColumns="true".
Table structure
![table structure in sql]()
Default.aspx code
<%@
Page Language="VB"
AutoEventWireup="false"
CodeFile="Default.aspx.vb"
Inherits="_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">
<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>
Default.aspx.vb code
Imports
System.Data.SqlClient
Imports
System.Data
Partial
Class _Default
Inherits System.Web.UI.Page
Dim strConnString
As String =
System.Configuration.ConfigurationManager.ConnectionStrings.Item("ConnectionString"
.ToString()
Dim con As
New SqlConnection(strConnString)
Dim sqlda As
SqlDataAdapter
Dim com As
SqlCommand
Dim ds As
DataSet
Dim str As
String
Protected
Sub Page_Load(ByVal sender
As Object,
ByVal e As
System.EventArgs) Handles
Me.Load
If Not
IsPostBack Then
bindgrid()
End If
End Sub
Sub bindgrid()
Try
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()
Catch ex As
Exception
Response.Write(ex.Message)
End Try
End Sub
Protected Sub
GridView1_SelectedIndexChanged(ByVal sender
As Object,
ByVal e As
System.EventArgs) Handles
GridView1.SelectedIndexChanged
Try
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
Catch ex As
Exception
Response.Write(ex.Message)
End Try
End Sub
End
Class
Output
![link in gridview]()
Thanks for reading