If you are interested in having all your database processes handled for you. Download Microsoft Application Blocks for .NET

A view simple calls takes care of all you SQL Server Connections:

http://www.microsoft.com/downloads/details.aspx?FamilyId=76FE2B16-3271-42C2-B138-2891102590AD&displaylang=en

You can't go wrong with this.
Hope this helps


[Edited by dcostelloe on 01-05-2003 at 10:46 AM GMT]

____________________________
Life is but a merry go round
around and around :-)

Visit us today:
http://www.welford-costelloe.com

Thanks dcostelloe

This is really a good place to start with ADO.NET , saves a ton of typing in code. @ 813 KB it is a snap download .. no problems faced so far

____________________________
BrainBench ADO.NET and ASP.NET Certified Developer

Couldn' remember where I found the link. Got this a whil back. Really good tool.

____________________________
My boss is a Jewish Carpenter (Jesus Christ)


Brain Bench Certified VB.NET Developer

Guys FYI Microsoft Application Blocks are a suite of assemblies that support many enterprise-wide scenarios - ie. Exception-handling and database access and many more... I believe that they were written to test the CLR and then expanded to production-ish code.
I would suggest that they are used wisely and that the developer understands all of the code before incorporating into a real-world environ.
Just a thought,
Kieron


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)

This DataAccess Application Block is not only for Sql -Server
Check this out  
Oracle -Sql Server
A good explanation on how this actually works can be found Here

[Edited by zimcoder on 17-08-2004 at 03:39 PM GMT]

____________________________
BrainBench ADO.NET and ASP.NET Certified Developer