vb.net - Binding ComboBox to DataTable That is not in Dataset -
i using vb.net develop small application. want bind combobox datatable not in dataset. binding dataset follows:
bsos=new bindingsource(ds,"tablename") assume created own distinct table values follows:
tblos = dstaset.tables("computers").defaultview.totable(true, "os") what want following:
bsos = new bindingsource(tblos) but error comes:
unable cast object of type 'system.data.datatable' type 'system.componentmodel.icontainer'. is there away without adding table dataset?
this should work:
combobox.datasource = tblos combobox.valuemember = "<column name want value>" combobox.displaymember = "<column name value want display in list>" to update datasource values can this:
dim tblos datatable = combobox.datasource dim dr datarow = tblos.newrow() dr.item(0) = "value" dr.item(n) = "display" since datatable isn't bound doubt possible update automatically. if keep tblos property, instead of local variable, update combobox gets new row.
Comments
Post a Comment