How can I get record from gridview

Question

Hi, I have added button in gridview. I want to get row values of gridview into textboxes on click on corresponding button. plz, help me. Thanks, in advance

Prabhu Raja · Answer

Hi Alok, I have attached Source Code Here. It will guide to Achieve your tasks. ---------------------------------------------------- If this post helps you, then mark this post as "Correct Answer"

Jiteendra Sampathirao · Answer

HI, In the gridview: ' > Text="" CommandArgument=' ' /> In the Gridview Rowcommand Event write this int Idvalue = Convert.ToInt32(e.CommandArgument); if(e.commandName==linkRetrieve) { Fetch_records(Idvalue); } private void Fetch_records(string value) { string selectquery = ""; selectquery = "select ID, UserName, Email_Id, State FROM Registration where ID=" + value; SqlConnection sqlcon = new SqlConnection(ConfigurationManager.AppSettings["SqlServer_value"]); SqlCommand sqlcomm = new SqlCommand(); sqlcomm = sqlcon.CreateCommand(); sqlcomm.CommandType = CommandType.Text; sqlcomm.CommandText = selectquery; sqlcon.Open(); SqlDataReader sqlred = null; sqlred = sqlcomm.ExecuteReader(); if (sqlred.Read()) { if (sqlred["UserName"] != null) { txtName.Text = sqlred["UserName"].ToString(); } if (sqlred["Email_Id"] != null) { txtEmailId.Text = sqlred["Email_Id"].ToString(); } if (sqlred["State"] != null) { ddlState.SelectedValue = sqlred["State"].ToString(); } } sqlcomm.Dispose(); sqlcon.Close(); } web.config file

Satyapriya Nayak · Answer

Hi Alok, Here is your solution. Normal 0 Note : - Here in gridview control add AutoGenerateSelectButton="true" AutoGenerateColumns="true". Normal 0 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 Thanks If this post helps you mark it as answer

How can I get record from gridview

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)