vb.net - How to populate a ComboBox based on another ComboBox through SQL Server? -

-

this question exact duplicate of:

i want able have 2 comboboxes 1 parent or owner of second one, through connection string on sql server. means whenever select value in first combobox, second combobox filter it's results display corresponding values related first combobox. if see code below, error states:

error 1 method 'private sub cboclient_selectedindexchanged(sender object, e system.eventargs, envname string)' cannot handle event 'public event selectedindexchanged(sender object, e system.eventargs)' because not have compatible signature.

goal:

  1. change database connection
  2. query proper user data correct database
  3. populate user combo box user data

my code:

 private sub cboclient_selectedindexchanged(sender object, e eventargs, byval envname string) handles cboclient.selectedindexchanged         using con2 new sqlconnection(configurationmanager.connectionstrings("constr").connectionstring)             'getting connection string specific client             dim cmd2 new sqlcommand("select * tblconnections envname = '" & "@envname" & "'", con2)             con2.open()             dim dt new datatable             dt.load(cmd2.executereader())             cmd2.parameters.add("@envname", sqldbtype.varchar)             cmd2.parameters("@envname").value = envname             if dt.rows.count > 0                 dim clientconstring string = dt(0)("connectionstring")                 'getting yalusers info client specific database\                 using con3 new sqlconnection(clientconstring)                     cmd2 = new sqlcommand("select * yalusers", con3)                     con3.open()                     dt.load(cmd2.executereader())                     cbouser.datasource = dt                     cbouser.displaymember = "first_name"                     cbouser.valuemember = "id"                     con3.close()                 end using              else                 'show error message : missing connection string in yalconnections table               end if              con2.close()         end using     end sub

how can fixed?

update: when run app, have 6 items in first combobox , ever 1 select, doesn't populate second combobox. why??

you cannot add parameter event handler. must have definition:

private sub cboclient_selectedindexchanged(sender object, e eventargs) handles cboclient.selectedindexchanged     doselectedindexchanged(sender, e, something) end sub

create separate subroutine work need not let handle event.

private sub doselectedindexchanged(sender object, e eventargs, byval envname string) handles cboclient.selectedindexchanged

Comments

Post a Comment

Popular posts from this blog

PHP DOM loadHTML() method unusual warning -

-
i had following code works fine on localhost: $document = new domdocument(); $document->loadhtml($p_result); $form = $document->getelementsbytagname('form')->item(0); // code continues using $form variable after same code updated on outside server, loadhtml() failed , issued warning. warning: domdocument::loadhtml() expects parameter 1 valid path, string given in path/name/to/script.php returned null instead of object code pretty gets fatal error. note contents of $p_result absolutely same on outside server , on localhost. but why displays kind of warning , why not work? doesn't loadhtml() expects argument 1 string in first place? why method expects parameter 1 valid path ? just make clear i'm not calling loadhtmlfile() , i'm calling loadhtml() . thanks. you're affected one of php bugs . issue present in php 5.6.8 , 5.6.9. have affected php version on server, , bug-free version on localhost. the bug forbids null
Read more

python - How to create jsonb index using GIN on SQLAlchemy? -

-
here's current code creating index jsonb. index("mytable_data_idx_id_key", mytable.data['id'].astext, postgresql_using='gin') but got error. sqlalchemy.exc.programmingerror: (psycopg2.programmingerror) data type text has no default operator class access method "gin" hint: must specify operator class index or define default operator class data type. [sql: "create index event_data_idx_id_key on event using gin ((data ->> 'id'))"] is there way create index on sqlalchemy? the postgresql specific sqlalchemy docs @ http://docs.sqlalchemy.org/en/latest/dialects/postgresql.html#operator-classes mention postgresql_ops dictionary provide "operator class" used postgresql, , provide example illustrating use: index('my_index', my_table.c.id, my_table.c.data, postgresql_ops={ 'data': 'text_pattern_ops',
Read more

c# - TransactionScope not rolling back although no complete() is called -

-
i'm using transactionscope rollback transaction fail bool errorreported = false; action<importerrorlog> newerrorcallback = e => { errorreported = true; errorcallback(e); }; using (var transaction = new transactionscope()) { foreach (importtaskdefinition task in taskdefinition) { loader.load(streamfile, newerrorcallback, task.destinationtable, processingtaskid); } if (!errorreported) transaction.complete(); } i'm sure there no transactionscope started ahead or after code. i'm using entity framework insert in db. regardless state of errorreported transaction never rolled in case of error. what missing ? transactionscope sets transaction.current . that's does. wants transacted must @ property. i believe ef each time connection opened reason. probably, connection open when scope installed. open connection inside of scope or enlist manually. ef has nasty "design decision": default opens
Read more