Its a desktop application .I have fetched and displayed the record in DataGridView,now I want to edi...

Question

Its a desktop application .I have fetched and displayed the record in DataGridView,now I want to edit/add/delete the values in dataGrid itself and update the respective table in database.Looking for a favorable reply soon .Thank you.

Answer 1

its a desktop application(c#2008 and sql server2005).i want to update multiple tables.

Answer 2

Hi Shilpa,

Try this...

App.xml file

 

<?xml version="1.0" encoding="utf-8" ?>

<configuration>

<appSettings>

                        <add key="dsn" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\EMP.mdb" />

            </appSettings>

</configuration>

 

 

 

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