combobox

Expand Post »

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

Similar Threads

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

kritiohri

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

24 posts
since Nov 2008

Permalink

Jan 5th, 2009

Re: combobox

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

Ramy Mahrous

Featured Poster

Reputation Points: 480

Solved Threads: 276

Postaholic

Offline

2,189 posts
since Aug 2006

Permalink

Jan 5th, 2009

Re: combobox

Hi You Must try this

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 9:30 am. Reason: added code tags

manoj_582033

Reputation Points: 10

Solved Threads: 2

Light Poster

Offline

39 posts
since Nov 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in VB.NET Forum Timeline: about outlook express

Next Thread in VB.NET Forum Timeline: merging two txt files into one txt file

DaniWeb Message

Cancel Changes

User Name
Password