C#

<br />
//use this if the default Insert, Delete, Select, Update Queries are fine<br />
OleDbCommandBuilder cmd = new OleDbCommandBuilder( dAdapter );<br />
<br />
// give the update method the following:<br />
// DataSet which contains the data<br />
// Name of the table you are updating<br />
dAdapter.Update(dSet, "Table name");<br />

<br />
    public partial class Form2 : Form<br />
    {<br />
        Timer t = new Timer();<br />
        int timePassed;<br />
<br />
        public Form2()<br />
        {<br />
            InitializeComponent();<br />
            t.Tick += new EventHandler(t_Tick); //everytime it reaches the interval it goes to the tick event<br />
            <br />
        }<br />
<br />
        void t_Tick(object sender, EventArgs e)<br />
        {<br />
            timePassed += t.Interval; //add the interval to the time passed<br />
<br />
            //do something in your progressbar<br />
<br />
<br />
<br />
            if (timePassed >= 10000) //if more than 10 seconds passed<br />
            {<br />
                t.Stop();<br />
                this.Close(); //close the form;<br />
            }<br />
        }<br />
<br />
        private void Form2_Load(object sender, EventArgs e)<br />
        {<br />
            t.Interval = 2000; //2 seconds<br />
            timePassed = 0;<br />
            t.Start();<br />
        }<br />
    }<br />