Problem binding to CheckBox

[Rodney Lane]

Hi,

I am using an oledb data adapter to connect to an MSAccess 2003 database. I
use bindings on my windows forms to bind fields to the controls and for text
boxes and grids it has been fine.

I am having problems with binding to a check box. It works fine until I
attempt to add a new record to the dataset through the binding context
object.

The code that adds the new record to the dataset is listed below
Me.BindingContext(dsDataSet, TableName).EndCurrentEdit()

Me.BindingContext(dsDataSet, TableName).AddNew()

The add new statement generates the following error :

"DataBinding could not find a row in the list that is suitable for all
bindings"

If I remove the check box from the data binding - I can add the record ok.
The field it is binding to in the database is a Yes/No field.

Any help or insight will be much appreciated.

Cheers

Rodney Lane

[Menu Chen]

I see....
I thinks checkbox is not suitable for database binding,
althrouhg microsoft have promised that all the controls
can binding to database.
But ,you can try to do like this:before you want to add a
new record to the database,remove the checkbox from data
binding .And after you have succeed in Updating the
database,move the checkbox in again.I think it may be
works.
Sorry for my poor English.
Best Regards.

-----Original Message-----
Hi,

I am using an oledb data adapter to connect to an MSAccess 2003 database. Iuse bindings on my windows forms to bind fields to the controls and for textboxes and grids it has been fine.

I am having problems with binding to a check box. It works fine until Iattempt to add a new record to the dataset through the binding contextobject.

The code that adds the new record to the dataset is listed belowMe.BindingContext(dsDataSet, TableName).EndCurrentEdit()

Me.BindingContext(dsDataSet, TableName).AddNew()

The add new statement generates the following error :

"DataBinding could not find a row in the list that is suitable for allbindings"

If I remove the check box from the data binding - I can add the record ok.The field it is binding to in the database is a Yes/No field.
Any help or insight will be much appreciated.

Cheers

Rodney Lane
.

[Rodney Lane]

Thanks

I'll try that if i can find no other alternative

many thnaks

Rod.
"Menu Chen" <an*******@discussions.microsoft.com> wrote in message
news:0d****************************@phx.gbl...

I see....
I thinks checkbox is not suitable for database binding,
althrouhg microsoft have promised that all the controls
can binding to database.
But ,you can try to do like this:before you want to add a
new record to the database,remove the checkbox from data
binding .And after you have succeed in Updating the
database,move the checkbox in again.I think it may be
works.
Sorry for my poor English.
Best Regards.

-----Original Message-----
Hi,

I am using an oledb data adapter to connect to an

MSAccess 2003 database. I

use bindings on my windows forms to bind fields to the

controls and for text

boxes and grids it has been fine.

I am having problems with binding to a check box. It

works fine until I

attempt to add a new record to the dataset through the

binding context

object.

The code that adds the new record to the dataset is

listed below

Me.BindingContext(dsDataSet, TableName).EndCurrentEdit()

Me.BindingContext(dsDataSet, TableName).AddNew()

The add new statement generates the following error :

"DataBinding could not find a row in the list that is

suitable for all

bindings"

If I remove the check box from the data binding - I can

add the record ok.

The field it is binding to in the database is a Yes/No

field.

Any help or insight will be much appreciated.

Cheers

Rodney Lane
.