472,146 Members | 1,415 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,146 software developers and data experts.

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

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
Mar 4 '07 #1
4 2023
1,646 1GB
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
Mar 4 '07 #2
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 :)
Mar 4 '07 #3
1,646 1GB
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.
Mar 5 '07 #4
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.


Feel free to ask any further questions.

Many thanks,

Mar 19 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by elpico | last post: by
reply views Thread by Saiars | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.