Click here for important information about Computing.net.

adding data in combobox from sql server 2008 r2 in vb 2010

Tags:
Access
String
SQL Server
database
filter
May 28, 2012 at 05:06:42
Specs: Windows 7, 2gb
Hi All,

I have a database called cohort in sql server 2008 r2 express with a table called school with the following fields; schoolname,schoolcode,zone,district,division.I also have vb 2010 form with five comboboxes.Now my question is how can i link comboxbox1 to table field schoolname,combobox2 to schoolcode,combobox3 to zone,combobox4 to district,combobox5 to division. And how to apply filter in combobox.For example if i select a particular division in combobox the next combobox for zone should only display zones for that particular division etc. I have tried to add data source to my vb application but cannot access it. Is there any coding that can substitute data objects on the form. I have managed to write a connection string for the database.


See More: adding data in combobox from sql server 2008 r2 in vb 2010

Report •

#1
May 29, 2012 at 09:15:25
Now my question is how can i link comboxbox1 to table field schoolname,combobox2 to schoolcode,combobox3 to zone,combobox4 to district,combobox5 to division.
http://msdn.microsoft.com/en-us/lib...

And how to apply filter in combobox.For example if i select a particular division in combobox the next combobox for zone should only display zones for that particular division etc.
You might have to do this manually.

I have tried to add data source to my vb application but cannot access it.
Why not?

Is there any coding that can substitute data objects on the form.
Not sure I understand the question.

How To Ask Questions The Smart Way


Report •
Start a discussion
Related Solutions
See More ↓


Ask Question