DataBinding and Update

[dionchen1]

Hi, everyone:

I am using VS.NET 2003 to create a winForm application ( Same result in VS.NET 2002). The application accesses MS Access DB so that an user can edit the DB.

When I have Datagrid bounded to the tables, all the updates (Insert,Delete and Update) work perfect. However, I have one table that I have to bound it to TextBoxes and CheckBoxes.
If I insert or delete a record, it updates the DB fine. When I change the text in the texboxes, or click on the checkboxes, The record is supposed to be modified. When I click on my save button, I use table.GetChanges(DataRowState.Modified) to retrieve the changes. Surprisely, there is no changes, even though I thought I have the right binding.

Apparently, when I change the textboxes or checkboxes, the datarow status did not change to Modified. I can not figure out what I missed here. Please help. Thanks in advance.

Dion

More info:

I have columns as Text, Number and Yes/No in the MS Access DB. Here are the simplified code to do the binding:

For Number:

Binding b1 = new Binding("Text", dsMain1, "LMMaster.LMMasterLMSimConfig.LessonTime");
b1.Parse+=new ConvertEventHandler(TextStringToInteger);
b1.Format+=new ConvertEventHandler(IntegerToTextString);
txtLessonTime.DataBindings.Add(b1);

For Text:

txtConfig.DataBindings.Add(new Binding("Text", dsMain1, "LMMaster.LMMasterLMSimConfig.Config"));


For CheckBox:

chkboxHelp.DataBindings.Add(new Binding("Checked", dsMain1, "LMMaster.LMMasterLMSimConfig.Help"));