how to insert,update,delete record from datagridview in C#

Question

pls send me code of how to insert,update,delete record in datagridview using C#

Satyapriya Nayak · Answer

Hi Arvind, Try this... 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

Senthilkumar · Answer

Hi, The grid view add operation can be done in multiple ways. This is upto the requirement. If you want to get all the values outside the grid then it can be fetch and added to the datasource like dataset and rebind it. Otherwise add the control in the footer and enable the controls to keying the value. The update and delete can be done in the item command. http://www.aspsnippets.com/Articles/GridView---Add-Edit-Update-Delete-and-Paging-the-AJAX-way.aspx

how to insert,update,delete record from datagridview in C#

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)