gridview how to select row cell value ...........

Question

gridview how to retrive selected row cell value ..... plz write quarie ..............

Satyapriya Nayak · Answer

Method-1 using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace Datagridview_select_textbox_data { public partial class Form1 : Form { string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"]; OleDbCommand com; OleDbDataAdapter oledbda; string str; DataSet ds; public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { bindgrid(); } private void bindgrid() { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = "select * from employee"; com = new OleDbCommand(str, con); oledbda = new OleDbDataAdapter(com); ds = new DataSet(); oledbda.Fill(ds, "employee"); dataGridView1.DataMember = "employee"; dataGridView1.DataSource = ds; con.Close(); } private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { int i; i = dataGridView1.SelectedCells[0].RowIndex; txt_sno.Text = dataGridView1.Rows[i].Cells[1].Value.ToString(); txt_name.Text = dataGridView1.Rows[i].Cells[2].Value.ToString(); txt_address.Text = dataGridView1.Rows[i].Cells[3].Value.ToString(); txt_age.Text = dataGridView1.Rows[i].Cells[4].Value.ToString(); } } } Method-2 using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace Datagridview_select_textbox_data { public partial class Form1 : Form { string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"]; OleDbCommand com; OleDbDataAdapter oledbda; string str; DataSet ds; public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { bindgrid(); } private void bindgrid() { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = "select * from employee"; com = new OleDbCommand(str, con); oledbda = new OleDbDataAdapter(com); ds = new DataSet(); oledbda.Fill(ds, "employee"); dataGridView1.DataMember = "employee"; dataGridView1.DataSource = ds; con.Close(); } private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { DataGridViewRow row = dataGridView1.Rows[e.RowIndex]; txt_sno.Text = row.Cells[0].Value.ToString(); txt_name.Text = row.Cells[1].Value.ToString(); txt_address.Text = row.Cells[2].Value.ToString(); txt_age.Text = row.Cells[3].Value.ToString(); } } } Method-3 using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace Datagridview_select_textbox_data { public partial class Form1 : Form { string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"]; OleDbCommand com; OleDbDataAdapter oledbda; string str; DataSet ds; public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { bindgrid(); } private void bindgrid() { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = "select * from employee"; com = new OleDbCommand(str, con); oledbda = new OleDbDataAdapter(com); ds = new DataSet(); oledbda.Fill(ds, "employee"); dataGridView1.DataMember = "employee"; dataGridView1.DataSource = ds; con.Close(); } private void dataGridView1_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e) { txt_sno.Text = dataGridView1.CurrentRow.Cells[0].Value.ToString(); txt_name.Text = dataGridView1.CurrentRow.Cells[1].Value.ToString(); txt_address.Text = dataGridView1.CurrentRow.Cells[2].Value.ToString(); txt_age.Text = dataGridView1.CurrentRow.Cells[3].Value.ToString(); } } }

Upamanyu Roy Choudhury · Answer

Hi, There are many ways you can do the same thing. You can get in RowCommand event of gridview. Apporach 1 protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Select") { GridViewRow row = (GridViewRow)(((Button)e.CommandSource).NamingContainer); Response.Write(row.Cells[0].Text); Response.Write(row.Cells[1].Text); } } Apporach2 : Use GridView.SelectedRow property. String cellText = this . gridView . SelectedRow . Cells [ cellIndex ]. Text ; Approach 3 inside the gridview tag include the field you want to access in this field: then in the event: gridview1_SelectedIndexChanged(object sender, EventArgs e) { string FolderID = gridview1.SelectedDataKey[0].ToString() } Approach 4 When we are you looping through gridview's row in rowdatabound event protected void GridView1 _RowDataBound( object sender, GridViewRowEventArgs e) { TextBox tb = ( TextBox ) e.row.FindControl( " TextBox1 " ) ; string val=tb.Text; } You can go thorough the following article which describes the concept in a simple manner http://www.dotnetfunda.com/articles/article442-how-to-get-the-values-of-selected-row-from-a-gridview-using-aspnet.aspx If you find this post as useful then please mark it as an answer. Regrads, Upamanyu

gridview how to select row cell value ...........

Answers (2)