DataGridview

Question

How To UPDATE Database ..Datagidview via..

Satyapriya Nayak · Answer

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 Insert Update Delete DataGridView. App.config 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 > Form1.cs 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 Insert_Update_Delete_DataGridView { public partial class Form1 : Form { string ConnectionString = System.Configuration. ConfigurationSettings .AppSettings[ "dsn" ]; OleDbCommand com; OleDbDataAdapter oledbda; string str; DataSet ds; public Form1() { InitializeComponent(); } private void Form1_Load( object sender, EventArgs e) { bindgrid(); } private void bindgrid() { OleDbConnection con = new OleDbConnection (ConnectionString); con.Open(); str = "select * from employee" ; com = new OleDbCommand (str, con); oledbda = new OleDbDataAdapter (com); ds = new DataSet (); oledbda.Fill(ds, "employee" ); dataGridView1.DataMember= "employee" ; dataGridView1.DataSource = ds; con.Close(); } private void Clear() { txt_sno.Text = "" ; txt_name.Text = "" ; txt_address.Text = "" ; txt_age.Text = "" ; } private void btn_edit_Click( object sender, EventArgs e) { int i; i = dataGridView1.SelectedCells[0].RowIndex; txt_sno.Text = dataGridView1.Rows[i].Cells[1].Value.ToString(); txt_name.Text = dataGridView1.Rows[i].Cells[2].Value.ToString(); txt_address.Text = dataGridView1.Rows[i].Cells[3].Value.ToString(); txt_age.Text = dataGridView1.Rows[i].Cells[4].Value.ToString(); } private void btn_update_Click( object sender, EventArgs e) { OleDbConnection con = new OleDbConnection (ConnectionString); con.Open(); str = "Update employee set sno=@sno,name=@name,address=@address,age=@age Where sno=@sno" ; com = new OleDbCommand (str, con); com.Parameters.AddWithValue( "@sno" , txt_sno.Text); com.Parameters.AddWithValue( "@name" , txt_name.Text); com.Parameters.AddWithValue( "@address" , txt_address.Text); com.Parameters.AddWithValue( "@age" , txt_age.Text); com.ExecuteNonQuery(); MessageBox .Show( "Record Successfully Updated" ); con.Close(); bindgrid(); Clear(); } private void btn_delete_Click( object sender, EventArgs e) { OleDbConnection con = new OleDbConnection (ConnectionString); com = new OleDbCommand (); if (dataGridView1.Rows.Count > 1 && dataGridView1.SelectedRows[0].Index != dataGridView1.Rows.Count - 1) { com.CommandText = "DELETE FROM employee WHERE ID=" + dataGridView1.SelectedRows[0].Cells[0].Value.ToString() + "" ; con.Open(); com.Connection = con; com.ExecuteNonQuery(); con.Close(); dataGridView1.Rows.RemoveAt(dataGridView1.SelectedRows[0].Index); MessageBox .Show( "Record Successfully Deleted" ); } bindgrid(); } private void btn_insert_Click( object sender, EventArgs e) { OleDbConnection con = new OleDbConnection (ConnectionString); con.Open(); str = "Insert into employee(sno,name,address,age) Values (@sno,@name,@address,@age)" ; com = new OleDbCommand (str, con); com.Parameters.AddWithValue( "@sno" , txt_sno.Text); com.Parameters.AddWithValue( "@name" , txt_name.Text); com.Parameters.AddWithValue( "@address" , txt_address.Text); com.Parameters.AddWithValue( "@age" , txt_age.Text); com.ExecuteNonQuery(); con.Close(); MessageBox .Show( "Record Successfully Inserted" ); bindgrid(); Clear(); } } } Thanks If this post helps you mark it as answer /* Style Definitions */ table.MsoNormalTable{mso-style-name:"Table Normal";mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:"";mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin:0in;mso-para-margin-bottom:.0001pt;mso-pagination:widow-orphan;font-size:11.0pt;font-family:"Calibri","sans-serif";mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:"Times New Roman";mso-fareast-theme-font:minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:"Times New Roman";mso-bidi-theme-font:minor-bidi;}