VB.NET

RSS

combobox

Please support our VB.NET advertiser: DiscountASP.NET – 3 Months Free on VB.NET Web Hosting

•

Posts: 24

Reputation: kritiohri is an unknown quantity at this point

Solved Threads: 0

kritiohri

Offline

Newbie Poster

combobox

Jan 5th, 2009

I have two fields in a table(dept_code and DEPT_name) in SQL.In my form iam having two comboboxs. one for dept_name and the other for Dept_code.What i want is that when i select a particular dept_name from the combobox its associated dept_code should come in the other combobox????

•

Posts: 1,867

Reputation: Ramy Mahrous has a spectacular aura about

Solved Threads: 214

Ramy Mahrous Ramy Mahrous is offline

Offline

Posting Virtuoso

Re: combobox

Jan 5th, 2009

After assign ComboBox your datasource (your department table) navigate in ComboBox properties you'll find which help you doing your task.

BI Developer | LINKdotNET
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous

•

Posts: 33

Reputation: manoj_582033 is an unknown quantity at this point

Solved Threads: 0

manoj_582033 manoj_582033 is offline

Offline

Light Poster

Re: combobox

Jan 5th, 2009

Hi You Must try this

 Help with Code Tags 
 vbnet Syntax (Toggle Plain Text) 
Protected Sub DropDownList1_SelectedIndexChanged()
  con=new sqlcnnection(constr)
  adpt=new sqldataadapter("select dept_code  from T.N. where dept_name='"+dropdownlist1.selecteditem+"'",con)
  ds=new dataset
  adpt.fill(ds,"T.N.")
  dim i as string=ds.tables(0).rows(0).item(0)
  dropdownlist2.item.clear()
  dropdownlist2.item.add(i)
End Sub
Protected Sub DropDownList1_SelectedIndexChanged()
  con=new sqlcnnection(constr)
  adpt=new sqldataadapter("select dept_code  from T.N. where dept_name='"+dropdownlist1.selecteditem+"'",con)
  ds=new dataset
  adpt.fill(ds,"T.N.")
  dim i as string=ds.tables(0).rows(0).item(0)
  dropdownlist2.item.clear()
  dropdownlist2.item.add(i)
End Sub

Last edited by Narue : Jan 5th, 2009 at 8:30 am. Reason: added code tags

Thread Tools Display Modes

Quick Reply to Thread

•

Only community members can participate in forum threads. You must register or log in to contribute.

Similar Threads

ComboBox Events (VB.NET)
Issue related to combobox.... (VB.NET)
need help with ComboBox (C++, Dialog) (C++)
Hiding dataitems in a combobox (VB.NET)
How to use combobox function (C++)
Filling a ComboBox.... (Java)

Other Threads in the VB.NET Forum

Previous Thread: about outlook express
Next Thread: merging two txt files into one txt file

•

Views: 246 | Replies: 2 | Currently Viewing: 1 (0 members and 1 guests)

•

Thread Tools	Display Modes
Show Printable Version Email this Page	Linear Mode Switch to Hybrid Mode Switch to Threaded Mode