Library code snippets tagged with ado.net

• SQL Data Provider VB.NET Class

  by

  This class includes some useful methods for working with Misrosoft SQL Server in .NET simply and quickly. vb.net, .net, ado.net, sql

• Transactions made easy with .NET 2.0

  by Xavier Larrea

  One of the more significant improvement in .NET 2.0 is the transactions area. Now with a single line it becomes extremely easy to support transactional code blocks using the concept of “ambient” transaction thanks to TransactionScope in the System.Transactions namespace. c#, asp.net, .net, ado.net

• Database Independent ADO.NET 2.0

  by Xavier Larrea

  ADO.NET 2 has new classes that makes it quite easy to write data-programs independent of the database engine. Learn how here. ado.net

• How to run through multiple DataReader results

  by Edward Tanguay

  You can save code by piling SQL statements into one SqlCommand and then getting a DataReader with multiple result sets. vb.net, .net, ado.net

• How to access a MySQL database with .NET

  by Edward Tanguay

  Demonstrates how to connect to a MySQL database with C#. asp.net, vb.net, ado.net, mysql

• How to delete records with SqlCommand

  by Edward Tanguay

  This code shows you how to delete records with an SQL statement and get the number of records deleted returned back as an integer. c#, ado.net, sql

• Placing results from DataReader into an Array

  by Edward Tanguay

  Since a connection cannot be used until a DataReader has been closed, it is quite often necessary to read the results of a DataReader into an array, then close the DataReader, then you can process the data in the array while you use the connection for something else. This shows you how. c#, ado.net