{
string sSQL = "UPDATE tbl_Loan SET BorrowerName = @BorrowerName "
+ ",DateCreated = @DateCreated"
+ ",DateDue = @DateDue"
+ ",DateClosedString = @DateClosedString"
+ ",Suspensedescription = @Suspensedescription"
+ " WHERE Id = @RecordId ";

OleDbConnection objConn = new System.Data.OleDb.OleDbConnection(ConnectionString);

OleDbCommand Cmd = new OleDbCommand(sSQL, objConn);

Cmd.Parameters.Add(new OleDbParameter("@BorrowerName", txtBorrowerName.Text));
Cmd.Parameters.Add(new OleDbParameter("@DateCreated", txtDateCreated.Text));
Cmd.Parameters.Add(new OleDbParameter("@DateDue", txtDateDue.Text));
Cmd.Parameters.Add(new OleDbParameter("@DateClosedString", txtClosed.Text));
Cmd.Parameters.Add(new OleDbParameter("@Suspensedescription", txtDesc.Text));
Cmd.Parameters.Add(new OleDbParameter("@RecordId", RecordID));

objConn.Open();
int nResult = Cmd.ExecuteNonQuery();
objConn.Close();
lblResult.Text = string.Format("Result: {0}", nResult == 1 ? "saved" : "err saving");
}

Properties.Settings.Default.AccessFilePathAndname;

if (File.Exists(sAccessFilePath))
{
ConnectionString = SuspenseMgrAccess.Properties.Settings.Default.AccessConnectionString;
OleDbConnection objConn = new System.Data.OleDb.OleDbConnection(ConnectionString);

String QueryString = "SELECT * FROM tbl_Loan";
OleDbCommand Cmd = new OleDbCommand(QueryString, objConn);

objConn.Open();
OleDbDataReader reader = Cmd.ExecuteReader();

OleDbDataAdapter dataAdapter = new OleDbDataAdapter(QueryString, objConn);
OleDbCommandBuilder commandBuilder = new OleDbCommandBuilder(dataAdapter);
DataTable table = new DataTable();
dataAdapter.Fill(table);

dataGridView1.DataSource = table;
objConn.Close();
}