469,645 Members | 1,653 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,645 developers. It's quick & easy.

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

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
Mar 4 '07 #1
4 1911
willakawill
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
willakawill
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.

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

Feel free to ask any further questions.

Many thanks,

J
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 gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.