using System.Data.OleDb;
//DataBase : db.mdb
//Table : tbl
//Fields: FName, LName
//TextBoxs: tbFName, tbLName
//Button: btnSave
private void btnSave_Click(object sender, EventArgs e)
{
OleDbConnection connection = new OleDbConnection();
connection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\\db.mdb";
OleDbCommand command = new OleDbCommand();
command.CommandText = "Insert into tbl([FName],[LName]) Values(@fFName,@fLName)";
command.Connection = connection;
OleDbParameter parameter = command.Parameters.Add("@fFName", DbType.String);
parameter.Value = tbFName.Text.Trim();
parameter = command.Parameters.Add("@fLName", DbType.String);
parameter.Value = tbLName.Text.Trim();
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}