C#

//load to combobox<br />
DataSet DBset = new DataSet("Client_Number");<br />
DBCommand = new OleDbCommand("Select Client_Number from tbClient", DBConnection);<br />
OleDbDataAdapter mydb = new OleDbDataAdapter();<br />
mydb.SelectCommand = DBCommand;<br />
mydb.Fill(DBset);<br />
cmbClientID.BeginUpdate();<br />
cmbClientID.DataSource = DBset.Tables["Client_Number"];<br />
cmbClientID.DisplayMember = "Client_Number";<br />
cmbClientID.ValueMember = "Client_Number";<br />
cmbClientID.EndUpdate();

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 />
        }