Home > IT Answers > Development > How to work with Visual Basics 6.0 and SQL Se...
Help

Question

  Asked: Apr 18 2008   1:17 PM GMT
  Asked by: SQL Server Ask the Experts

How to work with Visual Basics 6.0 and SQL Server 2000


Visual Basic, SQL Server 2000, SQL Server integration/interoperability, VB

I am designing a system with Visual Basics 6.0 as the user interface and SQL Server 2000 as the backend. How can I add data to the database through Visual Basics? How about deleting data in the tables?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Apr 18 2008  6:19 PM GMT  by Mrdenny




The most secure method for adding and deleting data is through stored procedures.

These will allow you to add, and process data, as well as retreive data from the database.

The Back To Basics series on my blog should provide you with some good info.

This sample code shows how to use a stored procedure in VB6 including using parameters.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Development and SQL Server.

Looking for relevant Development Whitepapers? Visit the SearchWinDevelopment.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Mrdenny  |   Apr 18 2008  6:19PM GMT

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.