首先配置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, Co