Integrating VB6 Forms into SQL Server

[jrden]

Hello Everyone
Im trying to link my forms in VB into my SQL server 2000 Databse.
There doesnt seem to be many tutorials to help with this on the internet, im quite new to SQL ive been using VB6 with Access 2000 linking tables, queries etc with these two applications. I now want to move to SQL VB6 and finding it hard to know how to link up say, text1.text on a vb form with a field in sql server. i.e. update field Customer name from a VB text box, there seems to be alot on updating from sql server syntax but nothing when you actually place values in a VB text box. I have used the ADOdc Data control used a stored procedure in sql and linked these, this returns all records instead of just updating or deleting info on one record, has anyone got any ideas where to start.
My boss is starting to pi*s me off asking how far ive got!
Thank you in advance.
Jim

 

[Warnie]

Jim,

As an alternative to stored procedure, you can use the ADO objects. ADO gives the recordset, connection and command objects which can help you build a query in your VB code and send it to the database.Hope this helps....

Warnie

 

[GHolden]

You might want to try and get hold of this book.

Title: Beginning SQL Server 2000 for Visual Basic Developers
Author: Thearon Willis
Publisher: Wrox Press
ISBN: 1861004672

I found it really useful when moving from Access to SQL Server

There are two ways to write error-free programs; only the third one works.

 

[jrden]

Hi Warnie
The only problem with using the SQL syntax in my VB code would be that id have to update the vb application when theres an update,then place the update on about 50 client machines, wheres as if i call a stored procedure from sql2000 i can just change it in there once, thats not as much hassle.
G Holden thanks for your tip on the book, have had a few books but they never seem to get down to the hard stuff also seem to have chapter after chapter of the same old basic things you know anyway, thats why a web site would be good, but thanks anyway. hope this isnt to negative, just been there dont want to waste time.