(C #. NET) Oracle Database Operations class
"Turn" http://hi.baidu.com/di_wan/blog/item/e51effd61814bb2a06088b62.html
Connect Oracle with OracleConnection
Configuring in Web.config
<add key= "Oracle" value= "XXX"/>
<add key= "USER" value= "XXX"/>
<add key= "Pass" value= "XXX"/>
------------------------------------------------------------------------------------------
public System.Data.OracleClient.OracleConnection CNN;
<summary>
Open a database connection
</summary>
public void Open ()
{
CNN = new OracleConnection (system.configuration.configurationsettings.appsettings["Oracle"]);
Cnn. Open ();
}
<summary>
Open the database connection and return to CNN
</summary>
Public OracleConnection opencnn ()
{
CNN = new OracleConnection (system.configuration.configurationsettings.appsettings["Oracle"]);
Cnn. Open ();
return (CNN);
}
<summary>
To close a database connection
</summary>
public void Close ()
{
Cnn. Close ();
}
///<summary>
///back to DataSet
///</summary >
///<param name= "cmdstring" ></param>
///<param Name = "TableName" ></param>
///<returns></returns>
Public DataSet GetDataSet (string cmdstring, String tablename)
{
Open ();
OracleDataAdapter Myda = new OracleDataAdapter ();
Myda.selectcommand = new OracleCommand (cmdstring, CNN);
DataSet myds = new DataSet ();
Myda.fill (myds, TableName);
Close ();
return myds;
}
///<summary>
///back OleDbDataReader
///< /summary>
///<param name= "cmdstring" ></param>
///< returns></returns>
Public oracledatareader getdatareader (string cmdstring)
{
Open ();
OracleCommand mycmd = new OracleCommand (cmdstring, CNN);
OracleDataReader mydr = Mycmd.executereader ();
return mydr;
}
<summary>
Returns the number of rows that affect the database
</summary>
<param name= "Cmdstring" ></param>
<returns></returns>
public int ExecuteSQL (string cmdstring)
{
Open ();
OracleCommand mycmd = new OracleCommand (cmdstring, CNN);
int Cmd = Mycmd.executenonquery ();
Close ();
return CMD;
}
<summary>
Bang Ding Drodownlist
</summary>
<param name= "drodlist" ></param> control name
<param name= "SQL" ></param> Connection strings
<param name= "tablename" ></param> table name
<param name= "DATATEXTFD" ></param> data source fields that provide text content
<param name= "DATAVALUEFD" ></param> data source fields that provide values for list items
public void Drolist (DropDownList drodlist, String sql, String tablename, String datatextfd, String datavaluefd)
{
Open ();
OracleDataAdapter Myda = new OracleDataAdapter (sql, CNN);
MyDa.SelectCommand.CommandType = CommandType.Text;
DataSet myds = new DataSet ();
Try
{
Myda.fill (myDS, TableName);
Drodlist.datasource = Myds.tables[tablename];
Drodlist.datatextfield = DATATEXTFD;
Drodlist.datavaluefield = DATAVALUEFD;
Drodlist.databind ();
}
catch (Exception e)
{
Response.Write (E.message);
}
Finally
{
Close ();
}
}