VB.NET

VB.NET RSS

combobox

Please support our VB.NET advertiser: Intel Parallel Studio Home

•

Join Date: Nov 2008

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????

•

Join Date: Aug 2006

Posts: 2,065

Reputation: Ramy Mahrous is just really nice

Solved Threads: 256

Ramy Mahrous Ramy Mahrous is offline

Offline

Postaholic

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

•

Join Date: Nov 2008

Posts: 34

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