vb.net - Combobox databinding through code -



vb.net - Combobox databinding through code -

i have form binding info controls. code

private sub form1_load(sender system.object, e system.eventargs) handles mybase.load seek conn = new oledbconnection("provider=microsoft.ace.oledb.12.0;;data source=c:\users\desraj\desktop\mydb.accdb;") conn.open() formload() adap = new oledbdataadapter("select * mytable", conn) dim ds new dataset adap.fill(ds, "mytable") bindingsource1.datasource = ds.tables(0) bindingnavigator1.bindingsource = bindingsource1 textbox1.databindings.add("text", bindingsource1, "id") textbox2.databindings.add("text", bindingsource1, "myname") combobox1.databindings.add("text", bindingsource1, "city_code") combobox2.databindings.add("text", bindingsource1, "state_code") grab ex exception msgbox(ex.message.tostring) end seek end sub public sub formload() seek cmd = new oledbcommand("select * mycity", conn) reader = cmd.executereader while reader.read = true combobox1.items.add(reader.item(1)) end while reader.close() cmd = new oledbcommand("select * mystate", conn) reader = cmd.executereader while reader.read = true combobox2.items.add(reader.item(1)) end while reader.close() grab ex exception msgbox(ex.message) end seek end sub

have 3 tables table 1: mytable 4 columns id,myname,city_code(fk),state_code(fk) table 2: mycity 2 columns city_code,city table 3: mystate 2 columns state_code,state example: mytable has next values id myname city_code state_code 1 alan 2 3 2 stone 3 1 3 brock 1 2 mycity has next values city_code city 1 abc 2 xyz 3 pqr mystate has next values state_code state 1 lmn 2 fgh 3 def

the problem instead of loading combobox1 , combobox2 city , state, loads city_code , state_code. how can load city , state in combobox1 , combobox2, having foreign keys in mytable?

you should first binding parent list combobox setting displaymember, valuemember , datasource. valuemember name of pk. utilize databindings bind selectedvalue fk column of kid table, e.g.

with citycombobox .displymember = "city" .valuemember = "city_code" .datasource = citybindingsource .databindings.add("selectedvalue", personbindingsource, "city_code") end

note 2 different bindingsources used.

vb.net combobox

Comments

Post a Comment

Popular posts from this blog

java Multi query from Mysql using netbeans -

java Multi query from Mysql using netbeans - i have java code retrieve info mysql appropriate code in netbeans.the code below. want multi query such illustration finding total number of products , on.could help me please. in advance import java.sql.*; public class javamysqlselectexample { public static void main(string[] args) { seek { string mydriver = "com.mysql.jdbc.driver"; string myurl = "jdbc:mysql://localhost/sample"; class.forname(mydriver); connection conn = drivermanager.getconnection(myurl, "root", "mypasscode1"); string query = "select * products"; statement st = conn.createstatement(); resultset rs = st.executequery(query); while (rs.next()==true) { int code = rs.getint("code"); string productname = rs.getstring("product_name"); string producttype = rs.getstring("product_type"); system.out.format(" %d, %s, %s\n", code, pr
Read more

c# - DotNetZip fails with "stream does not support seek operations" -

c# - DotNetZip fails with "stream does not support seek operations" - i using dotnetzip in c# unzip stream follows: public static void unzipfromstream(stream stream, string outdir) { //omit seek grab block using (zipfile zip = zipfile.read(stream)){ foreach (zipentry e in zip){ e.extract(outdir, extractexistingfileaction.overwritesilently); } } } stream obtained using webclient client = new webclient(); stream fs = client.openread(url); however, got next exception exception during extracting zip stream system.notsupportedexception: stream not back upwards seek operations. @ system.net.connectstream.get_position() @ ionic.zip.zipfile.read(stream zipstream, textwriter statusmessagewriter, encoding encoding, eventhandler`1 readprogress) on server side(asp.net mvc 4), returning filepathresult or filestreamresult both caused exception. should obtain stream differently on client side? or how create server homec
Read more

c++ - StartServiceCtrlDispatcher don't can access 1063 error -

c++ - StartServiceCtrlDispatcher don't can access 1063 error - i write on c++ service , have error, , don't can fixed it. my service main function int main (int argc, tchar *argv[]) {dword f; for(int i=0;i<113;i++) f = getlasterror(); servicepath = lptstr(argv[0]); outputdebugstring(_t("my sample service: main: entry")); //installservice(); service_table_entry servicetable[] = { {service_name, (lpservice_main_function) servicemain}, {null, null} }; // startservice(); if(!startservicectrldispatcher(servicetable)) { f = getlasterror(); //addlogmessage("error: startservicectrldispatcher"); } else if( memcmp(argv[argc-1],"install",7)) { installservice(); } else if( memcmp(argv[argc-1],"remove",6)) { removeservice(); } else if( memcmp(argv[argc-1],"start",5)) { startservice(); } else if( memcmp(argv[argc-1],"stop",4))
Read more