Databinding a check list box

[John]

Hi

I have a check box list box on a windows form. How can I data bind it to an
access table. I don't need a multi-tier solution. Just a solution.

Thanks

Regards

 

[Dave Sexton]

Hi,

I don't think CheckedListBox supports binding to list sources. You should just acquire the data and fill the Items collection in a
loop.

 

[John]

Sorry, how can I acquire the data?

Thanks

Regards

 

[Dave Sexton]

Hi John,

Use the OleDbConnection class. (FYI, this would be the data tier of your application):

OleDbConnection on MSDN (code example):
http://msdn2.microsoft.com/en-us/library/system.data.oledb.oledbconnection.aspx

ConnectionString Property on MSDN (examples of oledb connection strings):
http://msdn2.microsoft.com/en-us/library/system.data.oledb.oledbconnection.connectionstring.aspx