How to insert data into Ms Access database in ASP.NET C#

In this video article we will learn how to insert data into MS-Access database table. Example of inserting data into MS-Access database. First to create the connection with the database using OleDbConnection class which is exist in the system.Data.OleDb. Now, use insert into command to insert data into database. In the last we use ExecuteNonQuery( ) method to load the data into database table.

[kimwellbantay]

how do you do it if you have more that 1 field. Say for example you have a lastname, first name, and middle name? thanks

[harshtilvani]

Error
Arise: value is not match for destination