Simple Data Entry In Microsoft Access Database

In the previous post. We described the connection to the Microsoft Access database.

Now we will add some functionality to that. The user can insert diferent records.

For start, make a form like this (the names of the components are specified on the picture)

Now in the button1 event method insert this code

string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db.mdb;";
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = connStr;
string cmdStr = "INSERT INTO Info (FirstName, LastName)" +
" VALUES('"+textBox1.Text+"', '"+textBox2.Text+"');";
OleDbCommand cmd = new OleDbCommand(cmdStr, conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();

The code is the same from the previous post with only one difference, the string cmdStr is changed. Now the command in the table columns will insert the data which is written in the text boxes.

Now the table will have different records

Tagged as: C#

Sharing is Caring...

Sign up for Free Course on How to Make Money Online?

Other Related Posts:

1. Creating a Database Connection
2. ASP.Net Database Connection
3. Adding Items to ListView Control
4. Read/Write Registry Keys
5. Read From File Using StreamReader Class