Loading

vb.net2008

soniya

how to write this program in vb.net2008 with Odbc?
select companyname from comapny table show in combobox1 then companywise project name show in combobox2

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Shirsendu Nandi15y ago
You can do like this also while(rsBooks.Read ()) { this.combobox1.Items.Add (rsBooks[("companyname"]); }
0
Jaganathan Bantheswaran15y ago
Hi,

Already you know that how to connect VS 2008 with ODBC i guess.

so get the values from the odbc using the query like "select companyname from comapnytable"

add the values to combo box.

write a code to add values to combobox2 while selecting a value from combobox1. [ query for this is "select project name from projecttable where company="fffff" ]

As like
```
 while(rsBooks.Read ())             {                 this.combobox1.Items.Add (rsBooks.GetString("companyname");             }
```
0