i want to retreive data in textboxes from datagridview in windows application

Question

hiii friends i have one datagridview and 4 textboxs.i want when i am selecting one whole column of datagridview its data should be displayed in textboxes friends plzz help mee

Satyapriya Nayak · Answer

Another method 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(); } } } Thanks

Satyapriya Nayak · Answer

Hi Hemant, Try this... 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(); } } } Thanks If this post helps you mark it as answer