VB and SQL Server

Hi all,

Where can I find resources on the net on VB programming with SQL server as back-end?  I need info on "best practices" for connecting to sql server, lock types, cursors, exectuing SPs, sample code for db operations such as inset/delete/save etc.

Thanks

VBTiger
vbtigerAsked:
Who is Participating?
 
Farzad AkbarnejadConnect With a Mentor DeveloperCommented:
Hi,
Use ADO (ActiveX data Object) in Visual Basic to connect to SQL Server. Here is the samples:

http://msdn.microsoft.com/data/downloads/samples/default.aspx#SQLSamples

-FA
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.