asked on
vb.net Combobox Binding
Hi,
is there a way to have a combobox that fills its list with data from a different column but saves the selection binding to another column?
Say I have a column A with no values, and another column B with all the choices, can I tell the combobox to get its items from B and then save the user selection to column A
is there a way to have a combobox that fills its list with data from a different column but saves the selection binding to another column?
Say I have a column A with no values, and another column B with all the choices, can I tell the combobox to get its items from B and then save the user selection to column A
Visual Basic.NET.NET Programming
Last Comment
Ark
Comboboxes don't have columns. I'm not sure what you're getting at here.
ASKER
Sorry I meant a field in a database table
If your combo is bound, then bind it to ColumnA, but use ColumnB when building the Datasource for the Combo.
ASKER
ok great,
for the code I currently have this,
soumissionNumber.DataBindi
How could I incorporate columnB Scott?
for the code I currently have this,
soumissionNumber.DataBindi
How could I incorporate columnB Scott?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Strange solution to have 2 same columns. IMHO better have TABLE B with all choices and TABLE A with column A binded to ID field of TABLE B. In this case you can fill combo using TABLE B as datasource, ID field as ValueMember and TextField as DisplayMember, like James suggesting.