How to work with Visual Basics 6.0 and SQL Server 2000
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?

Software/Hardware used:
ASKED: April 18, 2008  1:17 PM
UPDATED: February 11, 2012  12:19 PM

Answer Wiki:
The most secure method for adding and deleting data is through <a href="http://itknowledgeexchange.techtarget.com/sql-server/back-to-basics-stored-procedures-the-work-horse-of-the-database/">stored procedures</a>. These will allow you to add, and process data, as well as retreive data from the database. The <a href="http://itknowledgeexchange.techtarget.com/sql-server/tag/back-to-basics/">Back To Basics</a> series on my blog should provide you with some good info. This <a href="http://www.freevbcode.com/ShowCode.Asp?ID=3687">sample code</a> shows how to use a stored procedure in VB6 including using parameters.
Last Wiki Answer Submitted:  April 18, 2008  6:19 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

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

 64,520 pts.

 

how to connect sql server 2000 with visiual basic 6.0

 10 pts.