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(id,name) 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=@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

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.

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

Answers (4)