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