Linking to SQlServer and displaying those items in listbox.

[aiswarya]

I've a table named student in my database.In it there are 7 columns .Now, in my form, when I click my table name, the name of columns should be displayed in
one listbox ie in listbox1. Again, when I click one column name in listbox1,the corresponding attributes of that column should be displayed in listbox2. If the column selected is of varchar type, then the items populated in listbox should be in single quotes. If the column selected is of integer type, then the items populated in listbox should be as such.Please help me.

[cloud255]

Which language are you using?

and what are the possible types in the database? only int and varchar or are there more possibilities?

[DrBunchman]

Have you written any code for this at all? Please show us what you have so far.

Dr B