473,321 Members | 1,622 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

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 2135
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

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

Similar topics

6
by: Andreas Lauffer | last post by:
I changed from Access97 to AccessXP and I have immense performance problems. Details: - Access XP MDB with Jet 4.0 ( no ADP-Project ) - Linked Tables to SQL-Server 2000 over ODBC I used...
3
by: Doug Baroter | last post by:
Hi, One of my clients has the following situation. They use Access DB for data update etc. some business functions while they also want to view the Access data quickly and more efficiently in...
5
by: pete | last post by:
Today I need to copy 8 records in a table. I have to use Access 200 because of the limitation of Enterprise Manager's inability to cope with field with more than 900 characters. Selected records,...
1
by: elpico | last post by:
Hi there, I've only recently started a project using sql server 2000 for the first time. One of the considerations we have to take is that we need to continuously age/purge data from a couple of...
7
by: iqbal | last post by:
Hi all, We have an application through which we are bulk inserting rows into a view. The definition of the view is such that it selects columns from a table on a remote server. I have added the...
8
by: Uttam | last post by:
Hello, I am currently in the process of developing an application in a pure desktop world using Access 2000. I am intending to convert this pure desktop application into a Client Server...
2
by: groupy | last post by:
Hello all, my question might be trivial but since my background isn't DB i'll dare to ask it any way: how to create a real (not virtual) table from view1 & view2 ni sql server? what should i...
2
by: Jobs | last post by:
Download the JAVA , .NET and SQL Server interview with answers Download the JAVA , .NET and SQL Server interview sheet and rate yourself. This will help you judge yourself are you really worth of...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.