Bind Checkbox

[djj55]

Hello, how do I bind a check box to a data set? I have:

Dim gCONNSTRING As String = "DSN=MyDSN;"
Dim gDBCONN2 As New Odbc.OdbcConnection(gCONNSTRING)
gDBCONN2.Open()
oCommand.Connection = gDBCONN2
strSQL = "SELECT * FROM mySQLTable"
oCommand.CommandText = strSQL
oAdapter.SelectCommand = oCommand
oAdapter.Fill(ds_User, "UserInfo")
Me.cbo_Associate.DataSource = Me.ds_User.Tables("UserInfo")
Me.cbo_Associate.DisplayMember = "Associate"
Me.txt_UserName.DataBindings.Add(New Binding("Text", Me.ds_User.Tables("UserInfo"), "UserName"))
[b]Me.chk_Active.DataBindings.Add(New Binding("Bit", Me.ds_User.Tables("UserInfo"), "myBitColumn"))[/b]

works fine until the last line. It does not like Bit, Boolean, or Text.

Thank you for any help/ideas
djj

 

[jebenson]

Bind to the Checked property of the checkbox, since that is what you want to happen:


Me.chk_Active.DataBindings.Add(New Binding([red]"Checked"[/red], Me.ds_User.Tables("UserInfo"), "myBitColumn"))

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day! Ye has a choice: talk like a pira

 

[djj55]

Now it makes sence. I was thinking value type not Property Name, even though that is what it clearly states.

Thanks for the assistance
djj