Post
Ask Question

Select gridview AutoGenerateSelectButton display data in label

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