retriving datagridview record into textbox

Question

Sir i am making one C# application in which i used 1 datagridview when i search any record in datagridview using search button. result is fillter and showing in datagridview. but  how to retrive this datagridview record in textbox for edit purpose and after edit it save in database . i am tired to write code for this. but it not works properly.

Satyapriya Nayak · Answer

Hi Arvind Insert Update delete datagridview Normal 0 App.xml file 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 Update_delete_datagridview { public partial class Form1 : Form { OleDbDataAdapter oledbda; OleDbCommandBuilder olcb; DataTable dataTable; BindingSource bindingSource; string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings[dsn]; string str; public Form1() { InitializeComponent(); } private void Form1_Load(object sender EventArgs e) { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = SELECT * FROM student; oledbda = new OleDbDataAdapter(str con); olcb = new OleDbCommandBuilder(oledbda); dataTable = new DataTable(); oledbda.Fill(dataTable); con.Close(); bindingSource = new BindingSource(); bindingSource.DataSource = dataTable; dataGridView1.DataSource = bindingSource; dataGridView1.Columns[0].Visible = false; } private void btnaddupdate_Click(object sender EventArgs e) { try { oledbda.Update(dataTable); } catch (Exception exceptionObj) { MessageBox.Show(exceptionObj.Message.ToString()); } MessageBox.Show(Records updated); } private void btndelete_Click(object sender EventArgs e) { try { dataGridView1.Rows.RemoveAt(dataGridView1.CurrentRow.Index); oledbda.Update(dataTable); } catch (Exception exceptionObj) { MessageBox.Show(exceptionObj.Message.ToString()); } MessageBox.Show(Records Deleted); } } } Thanks If this post helps you mark it as answer

MuthuMari M · Answer

Hi pls refer this code and u will get ideas http://www.aspsnippets.com/Articles/GridView---Add-Edit-Update-Delete-and-Paging-the-AJAX-way.aspx Thanks. If this post is useful then mark it as  Accepted Answer