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

Hi Arvind,


Try this...

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

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