Breaking News: Grepper is joining You.com. Read the official announcement!

insert data to access database c#

Misty Mosquito answered on March 25, 2022 Popularity 8/10 Helpfulness 2/10

answer insert data to access database c#

insert data to access database c#

Comment

string constr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\\your_DataBase_Name.accdb;";
                   OleDbConnection Con = new OleDbConnection(constr);
                   Con.Open();
                   OleDbCommand com = new OleDbCommand();
                   com.Connection = Con;
                   com = new OleDbCommand("your insert command here", Con);
                   int Num=com.ExecuteNonQuery();
                   if (Num != 0)
                   {
                       MessageBox.Show("Record Successfully Added....", "Add Record", MessageBoxButtons.OK, MessageBoxIcon.Information);
                       this.Close();
                   }
                   else
                   {
                       MessageBox.Show("Record is not Added....", "Add Record Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                   }

Popularity 8/10 Helpfulness 2/10 Language csharp

Source: www.codeproject.com

Tags: c# database insert

Link to this answer
Share Copy Link