Free .Net data provider

Discussion in 'ASP .Net' started by Joel Silva, Jul 31, 2006.

  1. Joel Silva

    Joel Silva Guest

    Hi,

    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);
    # MySQL
    MySQLDataReader reader = (MySQLDataReader)provider.GetDataReader(command);



    More info and download at:

    http://www.webdp.net/free-software/databasehandler.aspx


    I hope it helps!
    Joel
     
    Joel Silva, Jul 31, 2006
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. BS
    Replies:
    3
    Views:
    2,061
    Alvin Bruney [MVP]
    Jun 17, 2004
  2. sloan
    Replies:
    5
    Views:
    1,512
    sloan
    Jun 4, 2006
  3. sloan
    Replies:
    1
    Views:
    512
    Chad Scharf
    Jul 3, 2007
  4. george
    Replies:
    0
    Views:
    1,142
    george
    Aug 29, 2008
  5. mohammed_a_o
    Replies:
    0
    Views:
    283
    mohammed_a_o
    Nov 30, 2010
Loading...

Share This Page