using the data base class

here we built a simple search engine that uses the batabase class that we built before


using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace databasetest
{
///

/// Summary description for WebForm1.
///

public class WebForm1 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid DG1;
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.Button BtnSearch;
protected System.Web.UI.WebControls.TextBox txtSearchWord;
db db1;
private void Page_Load(object sender, System.EventArgs e)
{
db1=new db("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("database//freddydb.mdb"));
DG1.DataSource = db1.executeSQL("select * from users");
DG1.DataBind();
db1.closeDBCommand();
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}
///

/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
///

private void InitializeComponent()
{
this.BtnSearch.Click += new System.EventHandler(this.BtnSearch_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void BtnSearch_Click(object sender, System.EventArgs e)
{
try
{
if (txtSearchWord.Text.Trim()!="" )
{
DG1.DataSource = db1.executeSQL("select * from users where username like '"+txtSearchWord.Text+"%' or userfirstName like '"+txtSearchWord.Text+"%' or userLastName like '"+txtSearchWord.Text+"%'");
DG1.DataBind();
db1.closeDBCommand();
}
}
catch (Exception ex)
{
response.write (ex.Message);
}
}
}
}

connecting a database with c# / asp.net

this is the code of database connection and sql executing functions

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

///

/// data base class
///

public class db
{
OleDbConnection gDbConn;
OleDbCommand gDbCmd;
public string error;
public db(string connStr)
{
try
{
gDbCmd = new OleDbCommand();
gDbConn = new OleDbConnection();
gDbConn.ConnectionString = connStr;
error="class built successfully";
}
catch (Exception e)
{
error = "[class constructor] building class faild, error in connecting database error discribe: "+e.Message ;
}
}
public OleDbDataReader executeSQL(String sql)
{
try
{
OleDbDataReader rs ;
gDbConn.Open();
gDbCmd.Connection = gDbConn;
gDbCmd.CommandText = sql;
if (sql.Contains("select") )
rs = gDbCmd.ExecuteReader();
else
{
gDbCmd.ExecuteNonQuery();
rs = null;
}
error = "executeSQL executed successfully";
return rs;
}
catch(Exception e)
{
error = "[execute sql] failed to execute sql statement error discribe:" + e.Message
return null;
}
}
}

an example of using this class here: http://byramix.blogspot.com/2006/10/using-data-base-class.html