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
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