C Access database add and delete simple method

  • 2020-05-30 20:58:23
  • OfStack

Reference set:
using System.Data.OleDb;

static string exePath = System.Environment.CurrentDirectory;// This procedure is located in the path 

// Create a connection object 
OleDbConnection conn = new OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;data source=" + exePath + @"\ The file name .mdb"); 

1. For queries, OleDbDataAdapter is used to obtain table data (including the so-called "refresh" and "connect to the database") and query by conditions

private void  Fetch data table / The query ()
    // Fetch data table 
    //string sql = "select * from  The name of the table  order by  field 1";
    // The query 
    string sql = "select * from  The name of the table  where  field 2="...;

    OleDbDataAdapter da = new OleDbDataAdapter(sql, conn); // Create the adapter object 
    DataTable dt = new DataTable(); // New table object 
    da.Fill(dt); // Populate the table object with the adapter object 
    dataGridView1.DataSource = dt; // Take the table object as DataGridView The data source 


Among them, "fetch data table" is a method that is frequently nested and called, so conn.Open and Close should be removed to avoid error reporting due to accumulation with Open in other methods.

2. OleDbCommand is used for modifying table data, such as adding, deleting and saving

private void  increase / delete / change ()
     // increase 
     string sql = "insert into  The name of the table ( field 1, field 2, field 3, field 4)values(...)";
     // delete  
     //string sql = "delete from  The name of the table  where  field 1="...; 
     // change  
     //string sql = "update student set  Student id =" ...; 

     OleDbCommand comm = new OleDbCommand(sql, conn);


The number of tuples in which ExecuteNonQuery has been successfully changed, so comm.ExecuteNonQuery () can also be modified to judge and prompt the user for success or failure.

int i = comm.ExecuteNonQuery();
if (i > 0)
      MessageBox.Show(" Data added successfully !", " Operating hints ", MessageBoxButtons.OK, MessageBoxIcon.Information);
      MessageBox.Show(" Add failure !", " Operating hints ", MessageBoxButtons.OK, MessageBoxIcon.Error);

3. Save the data changes in DataGridView

private void saveData2()

     string sql = "select * from  The name of the table ";

     OleDbDataAdapter da = new OleDbDataAdapter(sql, conn);

     OleDbCommandBuilder bld = new OleDbCommandBuilder(da);
     da.UpdateCommand = bld.GetUpdateCommand();

        // the DataGridView Assigned to dataTbale . (DataTable) "Is a type conversion, as long as what follows can be converted to dataTable type 
     DataTable dt = (DataTable)dataGridView1.DataSource; 



Related articles: