configuring Web.config files: Configuring database connection Parameters
< appSettings >
<!--
CONNSTR parameter settings, case description:
(1) SQL Server database, such as "server = Local;database = Test;uid = Sa;pwd =;"
(2) Access databases, such as "DATAEX.MDB;" User ID = ' admin '; Jet oledb:database password = ' admin ';
-->
< add key = "ConnStr" value = "DBEXAMPLE.MDB;" User id= ' admin '; Jet oledb:database password= ' admin '; "/>
</appSettings >
code to write ConnDbForAccess.cs
Using System;
Using System.Data;
Using System.Data.OleDb;
Using System.Web;
Using System.Web.UI;
Namespace Com.LXJ.Database
{
<summary>
Summary description of the Conn.
</summary>
public class Conndbforacccess
{
<summary>
Connecting Database strings
</summary>
private string connectionString;
<summary>
Stores a database connection (a protected class that can only be accessed by a class that derives from it)
</summary>
protected OleDbConnection Connection;
<summary>
Constructors: Default connections for Databases
</summary>
Public conndbforacccess ()
{
String connstr;
ConnStr = system.configuration.configurationsettings.appsettings["ConnStr"]; Read from the Web.config configuration
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + HttpContext.Current.Request.PhysicalApplicati Onpath + connstr;
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.PhysicalApplicati Onpath + newconnectionstring;
Connection = new OleDbConnection (connectionString);
}
<summary>
Get connection string
</summary>
public string ConnectionString
{
Get
{
return connectionString;
}
}
<summary>
Execution of SQL statements does not return results such as delete, UPDATE, INSERT, etc.
</summary>
<param name= "strSQL" ></param>
<returns> Operation Success Mark </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 SQL statement return results 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>
Execute SQL statement return result to 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 and returns 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;
}
} //
} //