C#

CurrencyManager DBManager;<br />
OleDbConnection DBConnection;<br />
OleDbCommand DBCommand;<br />
OleDbDataAdapter DBAdapter;<br />
//DataSet dbSet;<br />
DataTable DBTable;<br />
//DataRow dbRow;<br />
string DBPath; //directory to database file<br />
....<br />
    DBPath = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source = " + openFileDialog1.FileName;<br />
    // connect to books database<br />
    DBConnection = new OleDbConnection(DBPath);<br />
    //open the connection<br />
    DBConnection.Open();<br />
    // establish command object<br />
    DBCommand = new OleDbCommand("Select * from handbook", DBConnection);<br />
    // establish data adapter/data table<br />
     DBAdapter = new OleDbDataAdapter();<br />
    DBAdapter.SelectCommand = DBCommand;<br />
    DBTable = new DataTable();<br />
    DBAdapter.Fill(DBTable);<br />
    // bind controls to data table<br />
    txt1.DataBindings.Add("Text", DBTable, "ID");<br />
    txt2.DataBindings.Add("Text", DBTable, "Serial");<br />
    txt3.DataBindings.Add("Text", DBTable, "Comment");<br />
    // establish currency manager<br />
    DBManager = CurrencyManager)BindingContext[DBTable];<br />
    DBManager.RemoveAt(DBManager.Position);<br />
    DBAdapter.Update();<br />
    ....

        private void button5_Click(object sender, EventArgs e)<br />
            Add<br />
        {<br />
            DataSet dbSet;<br />
            DataRow dbRow;<br />
            <br />
<br />
            dbRow = DBTable.NewRow();<br />
            dbRow[1] = 5;<br />
            dbRow[2] = "aaa";<br />
            DBTable.Rows.Add(dbRow);<br />
            DBTable = new DataTable();<br />
            DBAdapter.Fill(DBTable);<br />
<br />
            DBCommand = new OleDbCommand("insert into handbook (Serial, Comment) values (" + txt2.Text + ", " + txt3.Text + ")", DBConnection);<br />
            DBAdapter.InsertCommand = DBCommand;<br />
            //DBTable.Rows.Add(new object[] { 5, 5, "5" });<br />
            <br />
            DBAdapter.Update(DBTable);<br />
        }

class UpdateCounterCmd: ICommand
{
   private System.Windows.Forms.Label lblCount; //Label to be Modified.
   private Form1 frmMain; //Reference to the main form.

   private MethodInvoker delInvokeMe; // The MethodInvoker.


   public UpdateCounterCmd(Form1 formMain)
   {
      lblCount = new System.Windows.Forms.Label();
      frmMain = formMain;

      delInvokeMe = new MethodInvoker(Count);
   }
   
   public void Execute()
   {
      delInvokeMe.BeginInvoke(CallBack, null);
   }
   
   private void CallBack(IAsyncResult ar)
   {
      delInvokeMe.EndInvoke(ar);
   }
   
   private void Count()
   {
      frmMain.SuspendLayout();
      lblCounter.AutoSize = true;
      lblCounter.Location = new System.Drawing.Point(333, 96);
      lblCounter.Name = "LabelCount";
      lblCounter.Size = new System.Drawing.Size(35, 13);
      lblCounter.TabIndex = 0;
      lblCounter.Text = "Counting: 0";
      lblCounter.Visible = true;
      frmMain.Controls.Add(lblCounter); //PROBLEM CROSSING THREADS!
      
      int i = 0;
      for (i = 0; i <= 100; i++)
      {
         lblCounter.Text = "Counting: " + i.ToString();
         frmMain.ResumeLayout(true);
         frmMain.PerformLayout();
         frmMain.SuspendLayout();
      }
   }
   
}