gridview

Question

how to insertupdate and delete records in gridview.in c# language(desktop application)

vikas kanani · Answer

in this article just delete event is worked.rest of the events is not worked.plz checked and reply

Satyapriya Nayak · Answer

Hi Vikas Try this... Normal 0 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=@snoname=@nameaddress=@addressage=@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(snonameaddressage) 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