C# Datagridview to textbox

Question

Hi need help on getting the values from datagridview to textboxes i am having a datagridview getting data's from SQL which has 4 column and number of rows retrieved from sql i am having 4 textboxes i want the datagridview selected row's column values to the textboxes tried few things which i am getting error. Kindly advice

Munesh Sharma · Answer

This link will help you http://dotnet-munesh.blogspot.in/2014/04/display-selected-row-from-datagrid-view.html

Andrew Mills · Answer

// The following code works perfect for me: private void dgvCustomers_SelectionChanged(Object sender EventArgs e) { MessageBox.Show(SelectionChanged event happened!); DataGridViewRow row = this.dgvCustomers.SelectedRows[0]; txtID.Text = row.Cells[0].Value.ToString(); txtFirst.Text = row.Cells[1].Value.ToString(); txtLast.Text = row.Cells[2].Value.ToString(); } //BUT you must enter the following line in the load event // to 'wire up' the event as there is nothing on the form // in design view to double-click on to do this! dgvCustomers.SelectionChanged += dgvCustomers_SelectionChanged;

Vulpes · Answer

I suspect this question is about the Windows Forms DataGridView rather than the ASP.NET GridView control. If that's the case then I'd handle the RowEnter event as follows: private void dataGridView1_RowEnter(object sender DataGridViewCellEventArgs e) { if (!dataGridView1.Rows[e.RowIndex].IsNewRow) { textBox1.Text = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString(); textBox2.Text = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString(); textBox3.Text = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString(); textBox4.Text = dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString(); } else { textBox1.Text = ; textBox2.Text = ; textBox3.Text = ; textBox4.Text = ; } }

Prabhu Raja · Answer

Hi You may use SelectedIndexChanged() Event of GridView Like // get the values of selected row from a Gridview and display the values in textboxes protected void GridView1_SelectedIndexChanged(object sender EventArgs e) { TextBox1.Text = GridView1.SelectedRow.Cells[0].Text; TextBox2.Text = GridView1.SelectedRow.Cells[1].Text; TextBox3.Text = GridView1.SelectedRow.Cells[2].Text; TextBox4.Text = GridView1.SelectedRow.Cells[3].Text; } ----------------------------------------------------------------- If this post helps you then mark as Correct Answer Thank You