Use Access as a backing database to write a case to write a record in C #

Specific steps:

1. Create and open a OleDbConnection object

2. Create an inserted SQL statement

3. Create a OleDbCommand object

4. Using the OleDbCommand object to insert data

5. Close OleDbConnection

The implementation code is as follows:

< Here's what we need: System.Data.OleDb.OleDbConnection Class! (If you operate SQL database, we'd better use the System.Data.SqlClient.SqlConnection Class)>

Using System.Data
Using System.Data.OleDb

String strconn = "Provider = microsoft.jet.oledb.4.0; Data Source = Sample.mdb ";
OleDbConnection myconn = new OleDbConnection (strconn);
MyConn.Open ();

SQL statements

String Strinsert = "INSERT into books (BookID, BookTitle, Bookauthor, Bookprice, Bookstock) VALUES (";
Strinsert + = T_bookid. Text + ", '";
Strinsert + = T_booktitle. Text + "', '";
Strinsert + = T_bookauthor. Text + "',";
Strinsert + = T_bookprice. Text + ",";
Strinsert + = T_bookstock. Text + ")";

Define the Command object and execute the appropriate SQL statement

OleDbCommand Inst = new OleDbCommand (Strinsert, myconn);

Inst. ExecuteNonQuery ();

Myconn.close ();

Use Access as a backing database to write a case to write a record in C #