C# code for Insert Data into Database

//First we should add the following Namespace

using System.Data;
using System.Data.OleDb;

//Database connection code

{
OleDbConnection connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\\SamDB.mdb;Persist Security Info=True");
connection.Open();
String query;
query = "insert into sample(NAME,ADDRESS,PHONENO)" +
             "VALUES ('" + custName + "'," + txtAddress.Text.Trim() + ",'" + txtMobileNumber.Text.Trim() + "')";
       
OleDbCommand command = new OleDbCommand(query, connection);
int status = command.ExecuteNonQuery();
if (status > 0)
lblTranStatus.Text = status + " Data inserted Successfully";
else
      lblTranStatus.Text = "FAILED!!!";

connection.Close();
connection.Dispose();
}