(C#.NET)Oracle数据库操作类
【转】http://hi.baidu.com/di_wan/blog/item/e51effd61814bb2a06088b62.html
用OracleConnection连接Oracle
在Web.config中配置
<add key="Oracle" value="XXX"/>
<add key="USER" value="XXX"/>
<add key="PASS" value="XXX"/>
------------------------------------------------------------------------------------------
public System.Data.OracleClient.OracleConnection cnn;
/// <summary>
/// 打开数据库连接
/// </summary>
public void Open()
{
cnn = new OracleConnection(System.Configuration.ConfigurationSettings.AppSettings["Oracle"]);
cnn.Open();
}
/// <summary>
/// 打开数据库连接,返回cnn
/// </summary>
public OracleConnection OpenCnn()
{
cnn = new OracleConnection(System.Configuration.ConfigurationSettings.AppSettings["Oracle"]);
cnn.Open();
return (cnn);
}
/// <summary>
/// 关闭数据库连接
/// </summary>
public void Close()
{
cnn.Close();
}
/// <summary>
/// 返回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>
/// 返回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>
/// 返回影响数据库的行数
/// </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>
/// 邦定DroDownList
/// </summary>
/// <param name="DroDList"></param>控件名
/// <param name="sql"></param>连接字符串
/// <param name="TableName"></param>表名
/// <param name="DataTextFd"></param>提供文本内容的数据源字段
/// <param name="DataValueFd"></param>为列表项提供值的数据源字段
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();
}
}