C#.net connecting to an Access action class

1. Configure the Web. config file: Configure database connection parameters

<configuration>
<appSettings/>
<connectionStrings>

<add name= "ConnectionString" connectionstring= "Provider=Microsoft.Jet.OLEDB.4.0;Data source=f:\teachersystem\ App_data\db.mdb; Jet oledb:database password=123 "
Providername= "System.Data.OleDb"/>
</connectionStrings>

2
Programming begins:

1. Establish Access database and data table as required

2, write the database access, operation of the common class, this class can be reused in any future development of the system

(1), create a new C # class library project named "COM.LXJ", set project properties: assembly name, Default namespace is "Com.lxj"

(2), create a directory under this project directory database, the new C # class file ConnDbForAccess.cs in the database directory.

Add Reference: System.Web.dll

(3), write the Code of ConnDbForAccess.cs

Using System;
Using System.Data;
Using System.Data.OleDb;
Using System.Web;
Using System.Web.UI;
Using System.Configuration;

Namespace Com.LXJ.Database
{
<summary>
A summary description of the Conn.
</summary>
public class Conndbforacccess
{
<summary>
Connection Database string
</summary>
private string connectionString;

<summary>
Store a database connection (a protected class that can only be accessed by a class derived from it)
</summary>
protected OleDbConnection Connection;

<summary>
Constructors: Default connections for Databases
</summary>
Public conndbforacccess ()
{
String connstr;
ConnStr = configurationmanager.connectionstrings["ConnectionString"]. Connectionstring.tostring ();
ConnStr = system.configuration.configurationsettings.appsettings["ConnectionString"]. ToString (); Read from the Web. config configuration
connectionString = ConnStr;
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + HttpContext.Current.Request.PhysicalApplicationPath + connstr;
connectionString = system.configuration.configurationsettings.appsettings["connectionString"]. ToString ();
//
Connection = new OleDbConnection (connectionString);
}

<summary>
Constructors: Database connections with parameters
</summary>
<param name= "Newconnectionstring" ></param>
Public conndbforacccess (String newconnectionstring)
{
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + HttpContext.Current.Request.PhysicalApplicationPath + newconnectionstring;
connectionString = newconnectionstring;
Connection = new OleDbConnection (connectionString);
}

<summary>
Get the connection string
</summary>
public string ConnectionString
{
Get
{
return connectionString;
}
}


<summary>
Execute SQL statement does not return results, such as: Perform delete, update, INSERT, etc.
</summary>
<param name= "strSQL" ></param>
<returns> Operation Success Sign </returns>
public bool Exesql (string strSQL)
{
BOOL Resultstate = false;

Connection.Open ();
OleDbTransaction Mytrans = Connection.begintransaction ();
OleDbCommand command = new OleDbCommand (strSQL, Connection, Mytrans);

Try
{
Command. ExecuteNonQuery ();
Mytrans.commit ();
Resultstate = true;
}
Catch
{
Mytrans.rollback ();
Resultstate = false;
}
Finally
{
Connection.close ();
}
return resultstate;
}

<summary>
Execute the SQL statement to return the result to DataReader
</summary>
<param name= "strSQL" ></param>
<returns>dataReader</returns>
Private OleDbDataReader Returndatareader (string strSQL)
{
Connection.Open ();
OleDbCommand command = new OleDbCommand (strSQL, Connection);
OleDbDataReader dataReader = command. ExecuteReader ();
Connection.close ();

return dataReader;
}

<summary>
Executes the SQL statement to return the result to the dataset
</summary>
<param name= "strSQL" ></param>
<returns>DataSet</returns>
Public DataSet Returndataset (string strSQL)
{
Connection.Open ();
DataSet DataSet = new DataSet ();
OleDbDataAdapter oledbda = new OleDbDataAdapter (strSQL, Connection);
Oledbda.fill (DataSet, "objdataset");

Connection.close ();
return dataSet;
}

<summary>
Executes a query statement while returning the number of query results
</summary>
<param name= "strSQL" ></param>
<returns>sqlResultCount</returns>
public int Returnsqlresultcount (string strSQL)
{
int sqlresultcount = 0;

Try
{
Connection.Open ();
OleDbCommand command = new OleDbCommand (strSQL, Connection);
OleDbDataReader dataReader = command. ExecuteReader ();

while (Datareader.read ())
{
sqlresultcount++;
}
Datareader.close ();
}
Catch
{
Sqlresultcount = 0;
}
Finally
{
Connection.close ();
}
return sqlresultcount;
}


}//
}//

C#.net connecting to an Access action class