Checkbox and Databinding at Design time

[M]

I binding controls to a dataset at design time.
I find the checkboxs will cause the program crash when one of these
databinding fields is dbnull.
The only way for me is not set databindings for the checkboxs and adding
code after fill the dataset and before update the dataset.
I bind them to the checked property
Is there some easy way to set databinding for checkbox?

Thanks

[One Handed Man \( OHM - Terry Burns \)]

MyCheckBox.Data Bindings.Add( . . . . .

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .
If U Need My Email ,Ask Me

Time flies when you don't know what you're doing

"M" <mx****@hotvoic e.com> wrote in message
news:O2******** ******@tk2msftn gp13.phx.gbl...

I binding controls to a dataset at design time.
I find the checkboxs will cause the program crash when one of these
databinding fields is dbnull.
The only way for me is not set databindings for the checkboxs and adding
code after fill the dataset and before update the dataset.
I bind them to the checked property
Is there some easy way to set databinding for checkbox?

Thanks

[M]

I do not see any differnce from set data binding at design time.
It still will cause the prgram crash if the field is dbnull.

"One Handed Man ( OHM - Terry Burns )" <news.microsoft .com> wrote in message
news:OX******** *****@tk2msftng p13.phx.gbl...

MyCheckBox.Data Bindings.Add( . . . . .

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .
If U Need My Email ,Ask Me

Time flies when you don't know what you're doing

"M" <mx****@hotvoic e.com> wrote in message
news:O2******** ******@tk2msftn gp13.phx.gbl...

I binding controls to a dataset at design time.
I find the checkboxs will cause the program crash when one of these
databinding fields is dbnull.
The only way for me is not set databindings for the checkboxs and adding
code after fill the dataset and before update the dataset.
I bind them to the checked property
Is there some easy way to set databinding for checkbox?

Thanks

[Cor Ligthert]

M,

Because your database item is not the same type as your databinding would
expect. therefore I think you can surely not do it at design time.

You can try to use the binding events
http://msdn.microsoft.com/library/de...ventstopic.asp

click on the member there is more information.

I hope this helps?

Cor

[M]

Right Now I am using
'Fill Dataset
If MyDs.tables(0). Columns.Item(1) Is System.DBNull.V alue Then
MyDs.tables(0). Columns.Item.Ro ws(0).Item(1) = False
End If

and

'Update dataset
MyDs.tables(0). .Rows(0).Item(" GuidelinesMaxRe g") = Me.Chkbox.Check ed

It works

But I think Textbox or c1NumericEdit accept binding to field which value may
be dbNull.value.
If there are some properties can be set and make the checkbox also can do
that way and save me some coding.

[Scott Meddows]

M,

Can you assign a default value to that column in your database?

"M" <mx****@hotvoic e.com> wrote in message news:et******** ********@TK2MSF TNGP09.phx.gbl. ..

Right Now I am using
'Fill Dataset
If MyDs.tables(0). Columns.Item(1) Is System.DBNull.V alue Then
MyDs.tables(0). Columns.Item.Ro ws(0).Item(1) = False
End If

and

'Update dataset
MyDs.tables(0). .Rows(0).Item(" GuidelinesMaxRe g") = Me.Chkbox.Check ed

It works

But I think Textbox or c1NumericEdit accept binding to field which value may
be dbNull.value.
If there are some properties can be set and make the checkbox also can do
that way and save me some coding.

[Cor Ligthert]

M,

I did not test it, (copied from a program and changed somewhat) you can try
it in this way.

Maybe you can try it for yourself?

Cor
\\\
Dim Mybinding as New Binding("Checke d", dv, "MyCheckIte m")
AddHandler Mybinding.Forma t, AddressOf DBtoCheckbox
////
\\\
Private Sub DBtoCheckbox(By Val sender As Object, _
ByVal cevent As ConvertEventArg s)
If cevent.Value Is DBNull.Value Then
cevent.Value = False
End If
End Sub
///

Right Now I am using
'Fill Dataset
If MyDs.tables(0). Columns.Item(1) Is System.DBNull.V alue Then
MyDs.tables(0). Columns.Item.Ro ws(0).Item(1) = False
End If

and

'Update dataset
MyDs.tables(0). .Rows(0).Item(" GuidelinesMaxRe g") = Me.Chkbox.Check ed

It works

But I think Textbox or c1NumericEdit accept binding to field which value may be dbNull.value.
If there are some properties can be set and make the checkbox also can do
that way and save me some coding.