Insert update and delete in windows form appplication in c# using access database

Question

Satyapriya Nayak · Answer

Hi Rashmi Try this... Normal 0 App.config 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_navigate { public partial class Form1 : Form { string ConnectionString = System.Configuration. ConfigurationSettings .AppSettings[ dsn ]; OleDbCommand com; OleDbDataAdapter oledbda; string str; DataSet ds; byte flag; BindingManagerBase bm; public Form1() { InitializeComponent(); } private void Form1_Load( object sender EventArgs e) { OleDbConnection con = new OleDbConnection (ConnectionString); con.Open(); str = select * from student ; com = new OleDbCommand (str con); oledbda = new OleDbDataAdapter (com); ds = new DataSet (); oledbda.Fill(ds student ); textBox1.DataBindings.Add( Text  ds student.id ); textBox2.DataBindings.Add( Text  ds student.name ); bm = this .BindingContext[ds student ]; con.Close(); bindgrid(); } private void bindgrid() { OleDbConnection con = new OleDbConnection (ConnectionString); con.Open(); str = select * from student ; com = new OleDbCommand (str con); oledbda = new OleDbDataAdapter (com); ds = new DataSet (); oledbda.Fill(ds student ); dataGridView1.DataMember = student ; dataGridView1.DataSource = ds; con.Close(); } private void btn_first_Click( object sender EventArgs e) { bm.Position = 0; } private void btn_next_Click( object sender EventArgs e) { bm.Position += 1; } private void btn_previous_Click( object sender EventArgs e) { bm.Position -= 1; } private void btn_last_Click( object sender EventArgs e) { bm.Position = bm.Count - 1; } private void btn_add_Click( object sender EventArgs e) { textBox1.Text =  ; textBox2.Text =  ; textBox1.Focus(); flag = 1; } private void btn_modify_Click( object sender EventArgs e) { flag = 2; } private void btn_save_Click( object sender EventArgs e) { if (flag == 1) { OleDbConnection con = new OleDbConnection (ConnectionString); con.Open(); str = insert into student(idname) values (@id@name) ; com = new OleDbCommand (str con); com.Parameters.AddWithValue( @sid  textBox1.Text); com.Parameters.AddWithValue( @sname  textBox2.Text); com.ExecuteNonQuery(); con.Close(); MessageBox .Show( Records Successfuly Inserted ); bindgrid(); } if (flag == 2) { OleDbConnection con = new OleDbConnection (ConnectionString); con.Open(); str = update student set name=' + textBox2.Text.Trim() + ' where id=' + textBox1.Text.Trim() + ' ; com = new OleDbCommand (str con); com.ExecuteNonQuery(); con.Close(); MessageBox .Show( Records Successfuly Updated ); bindgrid(); } } private void btn_delete_Click( object sender EventArgs e) { DialogResult result; result = MessageBox .Show( Are You sure want to Delete?  Conformation  MessageBoxButtons .YesNo); if (result == System.Windows.Forms. DialogResult .Yes) { OleDbConnection con = new OleDbConnection (ConnectionString); str = delete from student where id=@id ; com = new OleDbCommand (str con); com.Parameters.AddWithValue( @id  textBox1.Text); con.Open(); com.ExecuteNonQuery(); con.Close(); MessageBox .Show( Records Successfuly Deleted ); bindgrid(); } else { MessageBox .Show( No action ); } } } } Thanks If this post helps you mark it as answer

Satyapriya Nayak · Answer

Hi Rashmi 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

Satyapriya Nayak · Answer

Hi Rashmi Try this... App.config 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

rashmi kc · Answer

how to provide like when i double click on the row of the gridview and modify their only and to save or when i double click on grid view row its name and id should display on the two text box and when we click modify the modified value ll be saved how to do ths.