SPextreme.com

Home
	About Us
	Contact Us
Open Source
	Hudson Remote
	Eclispe .NET Tools
	Open License
Products
	Database Client
	Jail Gate
	Playoff Ladder Creator
	Preference Packer
	LErrorMsg
	Web Dictionary

Database Client

DatabaseClient is a set of objects for use with the .NET framework, which provides a wrapper for all the standard database calls. DatabaseClient currently supports SQL Server, Oracle, OLE and ODBC calls.

DatabaseClient includes two objects. They are called DatabaseWrapper and DatabaseHelper.

DatabaseWrapper is used to create a database connection and make SQL calls to any database using either a Query or Non-Query based call. The wrapper also supports Scalar calls. DatabaseWrapper was designed so that all the database calls incur no more overhead then directly interacting with the standard database provider methods.

DatabaseHelper is used to make it even easier to interact with your database. It contains a set of static methods to quickly obtain the data you require from your database. The set of methods provide all of the same database interactions as DatabaseWrapper.

DatabaseClient is completely documented using the MSDN format to make it simpler to read and find information.

With DatabaseClient you will no longer need to write complicated database code for different database provides. You'll wonder how you lived without it.

Download Demo Now

Secure Order Form

System Requirements

Windows
.NET Framework 1.1

Features

Supports SQL Server, Oracle, OLE, and ODBC
Supports standard database calls(ExecuteQuery, ExecuteNonQuery, ExecuteScalar)
Returns queried data in a DataSet
Ability to define the connection string in the web.config file
DatabaseHelper is a set of static functions to perform any SQL call in a single line of code
Separates database interactions from your code
Complete documentation

Example

Below is an example of how to use the DatabaseClient's DatabaseHelper. The example uses the Northwind database to display the employees in the desired country('USA') in a DataGrid. The following are the steps taken to get this working in the example.

Copy the DatabaseClient.dll to the /bin directory.
Added '<add key="SPextreme.DatabaseClient.ConnectionString" value="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=C:\\northwind.mdb"/>' to the web.config
Add '<%@ Import Namespace="DatabaseClient" %>' to the example.aspx page.
Call the DatabaseHelper method to get the employee data.

<%@ Import Namespace="DatabaseClient" %>

<script language="C#" runat="server">
protected void Page_Load( Object sender, EventArgs e )
{
   DataSet	data;
   Hashtable	ht = new Hashtable( );
   ht.Add( "@country", "USA" );

   data	= DatabaseHelper.ExecuteQuery( DatabaseClientType.OLE,
            "SELECT * FROM Employees WHERE country = @country", ht );

   testGrid.DataSource = data;
   testGrid.DataBind( );
}
</script>

<html>
<body>
   <asp:DataGrid
      id="testGrid"
      runat="server"
   />
</body>
</html>