public class Conn
{
public OleDbConnection my_Conn;
public static string strConn
{
get
{
StringBuilder builder1 = new StringBuilder();
builder1.Append("Provider = Microsoft.Jet.OLEDB.4.0");
builder1.Append("; ");
builder1.Append("Data Source = ");
builder1.Append(HttpContext.Current.Server.MapPath("."));
builder1.Append(@"\");
builder1.Append(ConfigurationSettings.AppSettings["DataPath"]);
return builder1.ToString();
}
}
public void DBopen()
{
if (this.my_Conn.State == ConnectionState.Closed)
{
this.my_Conn.Open();
}
}
public void DBclose()
{
if (this.my_Conn.State == ConnectionState.Open)
{
this.my_Conn.Close();
}
}
public DataSet CreateDataSet(string strSql, string tableName)
{
OleDbDataAdapter adapter1 = new OleDbDataAdapter(strSql, this.my_Conn);
DataSet set1 = new DataSet();
adapter1.Fill(set1, tableName);
return set1;
}
public int ExecuteSql(string strSql)
{
OleDbCommand command1 = new OleDbCommand(strSql, this.my_Conn);
return command1.ExecuteNonQuery();
}
public OleDbDataReader ExecuteOleDbDataReader(string strSql)
{
OleDbCommand command1 = new OleDbCommand(strSql, this.my_Conn);
return command1.ExecuteReader();
}
public Conn()
{
this.my_Conn = new OleDbConnection(Conn.strConn);
}
}