Display selected records in label when click link button in gridview

Posted by Satyapriyanayak under ASP.NET category on | Points: 40 | Views : 3758
We will know how to display selected records in label when click link in gridview.Here we use 4 label control and a gridview.We will generated a select link button inside grid view as (AutoGenerateSelectButton="true").So when user will click on select link button corresponding records will be displayed in label control.

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>
<form id="form1" runat="server">
<asp:GridView ID="GridView1" runat="server" AutoGenerateSelectButton="true" AutoGenerateColumns="true"
BackColor="#CCFFCC" Font-Bold="False" ForeColor="Maroon">
<AlternatingRowStyle BackColor="#FFCC66" />
<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"
<asp:Label ID="lbl_name" runat="server" ForeColor="#CC3300"></asp:Label>
<br />
<br />
<asp:Label ID="lb5" runat="server" Text="ADDRESS : " Font-Bold="True"
<asp:Label ID="lbl_address" runat="server" ForeColor="#CC3300"></asp:Label>
<br />
<br />
<asp:Label ID="lb7" runat="server" Text="MARK : " Font-Bold="True"
<asp:Label ID="lbl_marks" runat="server" ForeColor="#CC3300"></asp:Label>
<br />
<br />
<asp:Label ID="lb9" runat="server" Text="YEAR : " Font-Bold="True"
<asp:Label ID="lbl_year" runat="server" ForeColor="#CC3300"></asp:Label>

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
End If
End Sub
Sub bindgrid()
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"
Catch ex As Exception
End Try
End Sub

Protected Sub GridView1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridView1.SelectedIndexChanged
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
End Try
End Sub
End Class

Comments or Responses

Login to post response