ASP. NET database connection class ClassConn and oledb database connection method

ASP. NET database connection class: ClassConn

 
 

  
  
UsingSystem;
  
  
UsingSystem. Collections;
  
  
UsingSystem. ComponentModel;
  
  
UsingSystem. Data;
  
  
UsingSystem. Data. SqlClient;
  
  
UsingSystem. Drawing;
  
  
UsingSystem. Web;
  
  
UsingSystem. Web. SessionState;
  
  
UsingSystem. Web. UI;
  
  
UsingSystem. Web. UI. HtmlControls;
  
  
UsingSystem. Web. UI. WebControls;
  
  
 
  
  
NamespaceZz
  
  
{
  
  
/// <Summary> 
  
  
/// Summary of ClassConn. 
  
  
/// </Summary> 
  
  
Public ClassConn// ASP. NET database connection class 
  
  
{
  
  
PublicConn ()
  
  
{
  
  
// 
  
  
// TODO: add the constructor logic here 
  
  
// 
  
  
}
  
  
PublicSqlConnection connstr;// Connection string 
  
  
Public StringGetconnstr ()// Obtain the connection string 
  
  
{
  
  
StringConstr;
  
  
Constr = System. Configuration. ConfigurationSettings. receivettings ["Connstring"];
  
  
ReturnConstr;
  
  
}
  
  
Public VoidOpen ()// Open the database 
  
  
{
  
  
StringConstr;
  
  
Constr = getconnstr ();
  
  
Connstr =NewSqlConnection (constr );
  
  
Connstr. Open ();
  
  
}
  
  
Public VoidClose ()// Close the database 
  
  
{
  
  
Connstr. Dispose ();
  
  
Connstr. Close ();
  
  
}
  
  
Public VoidExecsql (StringSQL)// Execute the SQL statement 
  
  
{
  
  
Open ();
  
  
SqlCommand cmd =NewSqlCommand (SQL, connstr );
  
  
Cmd. ExecuteNonQuery ();
  
  
Close ();
  
  
}
  
  
PublicDataSet dataset (StringSQL)// Return the DataSet object 
  
  
{
  
  
Open ();
  
  
SqlDataAdapter rs =NewSqlDataAdapter (SQL, connstr );
  
  
DataSet ds =NewDataSet ();
  
  
Rs. Fill (ds );
  
  
ReturnDs;
  
  
}
  
  
PublicDataView dataview (StringSQL)// Return the DataView object 
  
  
{
  
  
DataSet ds =NewDataSet ();
  
  
Ds = dataset (SQL );
  
  
DataView dv =NewDataView (ds. Tables [0]);
  
  
ReturnDv;
  
  
}
  
  
PublicSqlDataReader datareader (StringSQL)// Return the DataReader object 
  
  
{
  
  
Open ();
  
  
SqlCommand cmd =NewSqlCommand (SQL, connstr );
  
  
SqlDataReader dr = cmd. ExecuteReader ();
  
  
ReturnDr;
  
  
}
  
  
}
  
  
}
 
 

2. Use the ASP. NET database connection class to connect to the oledb Database

 
 

  
  
UsingSystem;
  
  
UsingSystem. Collections;
  
  
UsingSystem. ComponentModel;
  
  
UsingSystem. Data;
  
  
UsingSystem. Data. OleDb;
  
  
UsingSystem. Drawing;
  
  
UsingSystem. Web;
  
  
UsingSystem. Web. SessionState;
  
  
UsingSystem. Web. UI;
  
  
UsingSystem. Web. UI. WebControls;
  
  
UsingSystem. Web. UI. HtmlControls;
  
  
 
  
  
NamespaceXyl
  
  
{
  
  
/// <Summary> 
  
  
/// Summary of ClassConn. 
  
  
/// </Summary> 
  
  
Public ClassClassConn
  
  
{
  
  
PublicClassConn ()
  
  
{
  
  
// 
  
  
// TODO: add the constructor logic here 
  
  
// 
  
  
}
  
  
PublicOleDbConnection connstr;
  
  
Public StringGetconnstr ()
  
  
{
  
  
StringConstr;
  
  
Constr ="Provider = Microsoft. Jet. OleDb.4.0; Data Source ="+ HttpRuntime. AppDomainAppPath + System. Configuration. ConfigurationSettings. deleettings ["Connstring"];
  
  
ReturnConstr;
  
  
}
  
  
Public VoidOpenDB ()
  
  
{
  
  
StringConstr;
  
  
Constr = getconnstr ();
  
  
Connstr =NewOleDbConnection (constr );
  
  
Connstr. Open ();
  
  
}
  
  
Public VoidCloseDB ()
  
  
{
  
  
Connstr. Dispose ();
  
  
Connstr. Close ();
  
  
}
  
  
Public VoidExecsql (StringSQL)
  
  
{
  
  
OpenDB ();
  
  
OleDbCommand cmd =NewOleDbCommand (SQL, connstr );
  
  
Cmd. ExecuteNonQuery ();
  
  
CloseDB ();
  
  
}
  
  
PublicDataSet DataSets (StringSQL)
  
  
{
  
  
OpenDB ();
  
  
OleDbDataAdapter rs =NewOleDbDataAdapter (SQL, connstr );
  
  
DataSet ds =NewDataSet ();
  
  
Rs. Fill (ds );
  
  
ReturnDs;
  
  
}
  
  
PublicDataView DataViews (StringSQL)
  
  
{
  
  
DataSet ds =NewDataSet ();
  
  
Ds = DataSets (SQL );
  
  
DataView dv =NewDataView (ds. Tables [0]);
  
  
ReturnDv;
  
  
}
  
  
PublicOleDbDataReader MyDataReader (StringSQL)
  
  
{
  
  
OpenDB ();
  
  
OleDbCommand myCom =NewOleDbCommand (SQL, connstr );
  
  
OleDbDataReader myreader = myCom. ExecuteReader ();
  
  
ReturnMyreader;
  
  
}
  
  
}
  
  
}
 
 

The above introduces the ASP. NET database connection class ClassConn and the method for connecting to the oledb database.

1. Implementation of ASP. NET database Driver Class: DBHelper
2. ASP. NET database operation class written in C #
3. ASP. NET database image storage to Sql2000
4. Add an ASP. NET custom error handling page
5. Application of session storage mode in ASP. NET