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;
/// <summary>
/// Summary description for ketnoi
/// </summary>
public class ketnoi
{
public OleDbConnection chuoiketnoi()
{
string kn;
kn = "provider=microsoft.jet.oledb.4.0;data source=App_Data\\banhang.mdb";
return new OleDbConnection(kn);
}
public DataTable laytable(string sql)
{
OleDbConnection c = chuoiketnoi();
c.Open();
OleDbDataAdapter da = new OleDbDataAdapter(sql, c);
DataTable tb = new DataTable();
da.Fill(tb);
c.Close();
return tb;
}
public void ExecuteNonQuery(string sql)
{
OleDbConnection c = chuoiketnoi();
c.Open();
OleDbCommand cmd = new OleDbCommand(sql, c);
cmd.ExecuteNonQuery();
c.Close();
cmd.Dispose();
}
public string ExecuteScalar(string sql)
{
OleDbConnection c = chuoiketnoi();
c.Open();
OleDbCommand cmd = new OleDbCommand(sql, c);
string kq;
kq = cmd.ExecuteScalar().ToString();
c.Close();
cmd.Dispose();
return kq;
}
public OleDbDataReader ExecuteReader(string sql)
{
OleDbConnection c = chuoiketnoi();
c.Open();
OleDbCommand cmd = new OleDbCommand(sql, c);
OleDbDataReader reader = cmd.ExecuteReader();
return reader;
}
}