用OracleConnection连接Oracle
在Web.config中配置
1<add key="Oracle" value="Data Source=xxx;User ID=xxx;Password=xxx"></add>
public System.Data.OracleClient.OracleConnection cnn;
///
1<summary>
2/// 打开数据库连接
3/// </summary>
public void Open()
{
cnn=new OracleConnection(System.Configuration.ConfigurationSettings.AppSettings["Oracle"]);
cnn.Open();
}
///
1<summary>
2/// 打开数据库连接，返回cnn
3/// </summary>
public OracleConnection OpenCnn()
{
cnn=new OracleConnection(System.Configuration.ConfigurationSettings.AppSettings["Oracle"]);
cnn.Open();
return(cnn);
}
///
1<summary>
2/// 关闭数据库连接
3/// </summary>
public void Close()
{
cnn.Close();
}
///
1<summary>
2/// 返回DataSet
3/// </summary>
///
1<param name="CmdString"/>
///
1<param name="TableName"/>
///
1<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;
}
///
1<summary>
2/// 返回OleDbDataReader
3/// </summary>
///
1<param name="CmdString"/>
///
1<returns></returns>
public OracleDataReader GetDataReader(string CmdString)
{
Open();
OracleCommand myCmd =new OracleCommand(CmdString,cnn);
OracleDataReader myDr =myCmd.ExecuteReader();
return myDr;
}
///
1<summary>
2/// 返回影响数据库的行数
3/// </summary>
///
1<param name="CmdString"/>
///
1<returns></returns>
public int ExecuteSQL(string CmdString)
{
Open();
OracleCommand myCmd =new OracleCommand(CmdString,cnn);
int Cmd =myCmd.ExecuteNonQuery();
Close();
return Cmd;
}
///
1<summary>
2/// 邦定DroDownList
3/// </summary>
///
1<param name="DroDList"/>
控件名
///
1<param name="sql"/>
连接字符串
///
1<param name="TableName"/>
表名
///
1<param name="DataTextFd"/>
提供文本内容的数据源字段
///
1<param name="DataValueFd"/>
为列表项提供值的数据源字段
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();
}
}