Storing Database to Text Boxes and automatically update using timer

[CommonElements]

Hi,

1. I am using Visual Studio.NET 2005 C# Win Form
2. I have setup a database connection to my Access Database using ADO.NET
3. On my system timer I have the following code to execute every 1 sec:

private void timer1_Tick(object sender, EventArgs e)
{
OleDbConnection myConnection = new OleDbConnection(myConnectionString);
OleDbCommand myCommand = new OleDbCommand("SELECT *FROM Lights_Settings", myConnection);
OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(myCommand);
 
  try
  {
myConnection.Open(); 
myDataAdapter.Fill(myDataSet, "Lights_Settings"); 
this.textBox_north.DataBindings.Clear();
this.textBox_north.DataBindings.Add("text", myDataSet, "Lights_Settings.North" );
 myConnection.Close();
 
}
            catch (Exception ex)
            {
                MessageBox.Show("Error reading database: " + ex.Message);
                myConnection.Close();
            }
 
        }
 

4. The problem: If I change the values in the database table, when the timer ticks over again the text box value is not updated. If I remove the textbox_north.d atabindings.Cle ar() I will get an error because I am will be writing to the same databind twice.

Any Solutions??

thanks

[dwadish]

Please Commend the line this.textBox_no rth.DataBinding s.Clear();

hope it will ok

Hi,

1. I am using Visual Studio.NET 2005 C# Win Form
2. I have setup a database connection to my Access Database using ADO.NET
3. On my system timer I have the following code to execute every 1 sec:

private void timer1_Tick(obj ect sender, EventArgs e)
{
OleDbConnection myConnection = new OleDbConnection (myConnectionSt ring);
OleDbCommand myCommand = new OleDbCommand("S ELECT *FROM Lights_Settings ", myConnection);
OleDbDataAdapte r myDataAdapter = new OleDbDataAdapte r(myCommand);

try
{
myConnection.Op en();
myDataAdapter.F ill(myDataSet, "Lights_Setting s");
this.textBox_no rth.DataBinding s.Clear();
this.textBox_no rth.DataBinding s.Add("text", myDataSet, "Lights_Setting s.North" );
myConnection.Cl ose();

}
catch (Exception ex)
{
MessageBox.Show ("Error reading database: " + ex.Message);
myConnection.Cl ose();
}

}

4. The problem: If I change the values in the database table, when the timer ticks over again the text box value is not updated. If I remove the textbox_north.d atabindings.Cle ar() I will get an error because I am will be writing to the same databind twice.

Any Solutions??

thanks

[CommonElements]

Yes I commented out the line this.textBox_No rth.databinding s.clear() and i got the following error message:

"This causes two bindings in the collection to bind to the same property. Parameter name: binding"

Im guessing I am getting this error because I am bind the datasource in a timer and it will keep binding the same source over and over again.

Any solutions?