ASP.NET连接Oracle

来源：互联网发布：常用端口编辑：程序博客网时间：2024/05/22 18:55

首先配置web.config

 <add key="OracleConnectionString" value="Provider=OraOLEDB.Oracle.1;Persist Security Info=False;Password=123456;User ID=system;Data Source=mydb;" />

就这一句话就行了，网上也有使用oracle的方式配置，一直没成功过，先能用再说吧。

获取连接字符串：

public static string OracleConnectionString{    get    {        return ConfigurationManager.AppSettings["OracleConnectionString"];    }             }

public static DataSet ExecuteDataset(string connectionString, CommandType commandType, string commandText)//底层的方法{    //pass through the call providing null for the set of OleDbParameters    return ExecuteDataset(connectionString, commandType, commandText, (OleDbParameter[])null);}public static DataSet ExecuteDataset(string connectionString, CommandType commandType, string commandText, params OleDbParameter[] commandParameters){    //create & open an OleDbConnection, and dispose of it after we are done.    using (OleDbConnection cn = new OleDbConnection(connectionString))    {        cn.Open();        //call the overload that takes a connection in place of the connection string        return ExecuteDataset(cn, commandType, commandText, commandParameters);    }}

string conn = PubConstant.OracleConnectionString;//获取连接字符串private void Bind(){    DataSet ds = OleDbHelper.ExecuteDataset(conn, CommandType.Text, "select * from AAUSER");//直接调用Helper就行了。    rptData.DataSource = ds;    rptData.DataBind();}

有人说引用这个引用那个，其实，什么都没引用，其实是因为引用了也不行，using就找到OracleClient。

0 0