Hi Aaron,

I have been working with .NET (VB.NET, ASP.NET and C#) and SQL Server 2000
for almost 3 years now. You should be using the SQLClient Data Provider
that the .NET Framework provides as it is the best choice.

If you need a good data access layer to get you started, I would suggest
looking into Microsoft's Application Data Blocks on MSDN. They provide the
necessary code for your data layer and get it started in the right
direction.

Hope this helps,
Greg

-----Original Message-----
From: Aaron Costello
[mailto:mssqldba-ezmlmshield-x2717439.[Email address protected]
Sent: Wednesday, March 30, 2005 11:35 AM
To: LazyDBA Discussion
Subject: VB.net - SQL Server 2000

Hi



I'm a foxpro/vb.net Programmer and am new to SQL Server. (recently purchased
SQL Server 2000)



The object I'm currently working with in vb.net for all SQL Server related
tasks is the 'SqlClient' class



SqlConnection

SqlCommand

SqlDataAdapter

SqlDataReader



(Running stored procedures and SQL commands to return stats and selections
on large databases record volumes.)



Just wondering if anyone has any experience working with this object in
vb.net and whether there are any additional/alternative methods/objects I
should be aware of which could enhance performance/ability.



Kind regards,



Aaron

Aaron Costello

Programmer / Developer





---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]




MS Sql Server LazyDBA home page