Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

nisc wwwxxx, wwwxxx0cm, should producers of software-based services, such as atms, be held liable for economic injuries suffered when their systems fail?, wwwxxx0cm,, Event 9 IIS log failed to write entry, wwwxxx jeffs, Catastrophic failure Unexpected method call sequence. 0x8000ffff (-2147418113)., ksh lock a file, [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed



#1: Free .Net data provider

Posted on 2006-07-31 10:22:43 by jms


here is information about a free, simple and effective data provider for
Web and windows Forms.

..Net DatabaseHandler 1.1 was developed in C# and it may be used both
with .Net 1.1 and 2.0 applications.

It allows a developer to use the same API for accessing Sql Server 2000,
SQL Server 2005, MSDE, MS Access and MySQL.

How to use it:

1) Add a reference in your project to DatabaseHandler.dll

2) Add the following "using" statement in the class where you want to
use the component:
# using DatabaseHandler;

3) Instantiate the provider:

# SQL Server:
Provider provider = new Provider("MS SQLServer", your connection string");

# MS Access:
Provider provider = new Provider("MS Access", "your connection string");

# MySQL:
Provider provider = new Provider("MySQL", "your connection string");

4) The following methods are available for use:

# int provider.GetIntValue(command);
# string provider.GetStringValue(command);
# bool provider.ExecuteNonQuery(command);
# object provider.GetDataReader(command);
# DataSet provider.GetDataSet(command);

Example for the GetDataReader method:

# MS SQLServer
SqlDataReaderreader = (SqlDataReader)provider.GetDataReader(command);

# MS Access
OleDbDataReader reader = (OleDbDataReader)provider.GetDataReader(command);
MySQLDataReader reader = (MySQLDataReader)provider.GetDataReader(command);

More info and download at:

I hope it helps!

Report this message