Jassimi
asked on
search with combobox
Hi..
I have one table in the database, this table contains on two columns(BRANCH, TYPE),
the data are:
BRANCH TYPE
======= =====
BMW 320i
HONDA ACCORD
HONDA CITY
HONDA CIVIC
TOYOTA CAMRY
in visual studio 2005, there is one form have two comboboxes(cmbBRANCH, cmbTYPE),
both of them are connected to the database table,
cmbBRANCH is connected with BRANCH feild, and cmbTYPE connected with TYPE feild.
What I want is when the user choose the branch name thats being inside the first combobox(cmbBRANCH), the data related with this name will display in the second combobox (cmbTYPE),
for example: when the user choose HONDA from (cmbBRANCH),
all Types of HONDA (ACCORD, CITY,CIVIC) will display inside (cmbTYPE)
is there any solution for that?
I have one table in the database, this table contains on two columns(BRANCH, TYPE),
the data are:
BRANCH TYPE
======= =====
BMW 320i
HONDA ACCORD
HONDA CITY
HONDA CIVIC
TOYOTA CAMRY
in visual studio 2005, there is one form have two comboboxes(cmbBRANCH, cmbTYPE),
both of them are connected to the database table,
cmbBRANCH is connected with BRANCH feild, and cmbTYPE connected with TYPE feild.
What I want is when the user choose the branch name thats being inside the first combobox(cmbBRANCH), the data related with this name will display in the second combobox (cmbTYPE),
for example: when the user choose HONDA from (cmbBRANCH),
all Types of HONDA (ACCORD, CITY,CIVIC) will display inside (cmbTYPE)
is there any solution for that?
ASKER
ok..
can you tell me where can I find sutopostback ?
can you tell me where can I find sutopostback ?
It is a property you set on the control.
Either right click the combobox and select Properties check under Behaviour
or you can set programatically in the page load event
Either right click the combobox and select Properties check under Behaviour
or you can set programatically in the page load event
cmbBRANCH.AutoPostBack = True
Dear Jassimi,
The suggestions I am passing is based on ASP.Net2 for web applications and not full blown VB Apps.
you will obviously not have page post backs in a desktop app.
Rather use an event to specify when the second control should bind with its dataset.
The suggestions I am passing is based on ASP.Net2 for web applications and not full blown VB Apps.
you will obviously not have page post backs in a desktop app.
Rather use an event to specify when the second control should bind with its dataset.
ASKER
I tried it programatically and put cmbBRANCH.AutoPostBack = True
but I got this error:
'AutoPostBack' is not a member of 'System.Windows.Forms.Comb oBox'.
but I got this error:
'AutoPostBack' is not a member of 'System.Windows.Forms.Comb
ASKER
yea... I'm using windows application, not web application
You might want to try and populate the data to combobox2 on the combox1 event SelectedIndexChanged
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Set ComboBox 1's DataFieldValue = where clause of the second combobox's query.
Query 1
"Select Branch from Table"
(Set autopostback on cmbBRANCH)
In the Databind Event of cmbBRANCH add the second bit of code....
Query2
"Select Type from Table where Branch = @cmbBranch.SelectedValue"
You might also want to set the DataValueField on cmbBranch
Set the initial cmbTYPE.Visible = False
and then update the cmbType.Visible = True on Postback databind event of cmbBranch
Hope this will help.