CheckedListBox Basics

  • Thread starter Thread starter kifaro
  • Start date Start date
K

kifaro

Please excuse me if these are really basic questions but I cannot find
the documentation I need to be able to accomplish this.

I have a checked listbox I am filling from a ds:

mysql = "select id,name from company where supportedvendor=1 and
accessmfg=1 order by name"
ds = SqlHelper.ExecuteDataset(gsconnection,
CommandType.Text, mysql)

Me.clVendors.DataSource = ds.Tables(0)
Me.clVendors.DisplayMember = "name"
Me.clVendors.ValueMember = "id"

then I have
Dim dsVendor As DataSet
mysql = "select vendorId from quotevendor where
Proposalnum=" & iProposalNum & "and revision=" & iRevision
dsVendor = SqlHelper.ExecuteDataset(gsconnection,
CommandType.Text, mysql)

This dataset lists which items are to be checked. The vendorID field
corresponds to the ID field.

I know how to get it on the way out using the CheckedItems
collection!!

Thanks,
Aaron
 
Back
Top