DataBindings problem

[mustangman96]

How can I bind my checkbox control to a dataset?
I use sqlDataAdapter to generate the dataset.

The SQL column type is "bit" and allows nulls. Name is: "active".

This works fine with a textBox:

this.mytextBox.DataBindings.Add("Text",this.dsMyDataSet.partners,"name");

But this doesn't work with my checkBox:

this.mycheckBox.DataBindings.Add("Checked",this.dsMyDataSet.partners,"active");

The code runs and when I click on the dataGrid the following error raises:

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

 

[obislavu]

If you bind a grid with a DataTable which contains the bit columns then you have only to do like here and all the bit columns will be shown as checkbox with the right value from the table:
// Here is the categories table which have 2 bit columns:
this.oleDbConnection1.Open();
dt = new DataTable();
this.oleDbSelectCommand1.CommandText="Select * from Categories";
this.oleDbDataAdapter1.Fill(dt);
this.dataGrid1.SetDataBinding(dt,""

This is the simplest example but in real project/applications there is more work to do when binding a grid and update the source data.

-obislavu-

 

[mustangman96]

Obislavu, thank you for your help, but that wasn't really the answer to my problem.

If anyone interested the solution was:

I have to set the DefaultValue property of the column before the datagrid.datasource property gets the dataset.

this.dsMyDataSet.partners.activeColumn.DefaultValue=false;
this.dataGrid1.DataSource=this.dsMyDataSet.partners;

Now it works!