VB6 - Sql server 2000 -- retreive table names and create views

[AkMaLiTo]

hi...
i am in a mess, i need to use visual basic 6 with sql server 2000 database..
could someone tell me the best component to use with sql ?
the project is as follow:
retreive table names in a combo box, then choose a field, then set conditions, then create sql views according to these conditions..

seems simple, but i am really quizzed, could someone help ? as a start with the component and how to retreive table names from sql database and add them to the combo box ?

any help will be greatly appreciated, many thanks in advance

[willakawill]

Hi. you would normally use ADO objects to work with sql server. Google 'vb ADO tutorial' and you will have plenty to read up on. Good luck

[AkMaLiTo]

i tried and did lots of searches..
can u please help me with at least "how to retreive table names from the sql db" ?? thanks in advance :)

[willakawill]

There is all the help you need where you 'tried and did lots of searches'. TSDN is not a tutorial site. When you have implemented some code and get stuck you are welcome to return here and ask for assistance.

[jharrod]

Hi AkMaLiTo,

I am new to this forum and was searching for an answer for a question that was similar to yours.

I found a page below which I believe will be of help to you.

http://www.4guysfromrolla.com/webtech/090899-1.shtml

Feel free to ask any further questions.

Many thanks,

J