先看看与MSSQL连接的写法
WEBCONFIG文件
- <configuration>
- <appSettings>
- <add key="DBConnectionString" value="server=(local);database=MyOA;User Id=sa;pwd=123" />
- </appSettings>
- <connectionStrings/>
Database.cs
- using System.Data.SqlClient;
- public class Database
- {
- protected SqlConnection Connection;
- protected String ConnectionString;
- /// <summary>
- /// 构造函数
- /// </summary>
- public Database()
- {
- ConnectionString = ConfigurationSettings.AppSettings["DBConnectionString"];
- }
- }
修改为ORACLE连接的话可以参照
- <?xml version="1.0"?>
- <configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
- <connectionStrings>
- <!--
- 连接oracle
- -->
- <add name="DBConnectionString" connectionString="Data Source=servername;Persist Security Info=True;User ID=sysuser;Password=sysuser;Unicode=True" providerName="System.Data.OracleClient"/>
- </connectionStrings>
- <system.web>
- <compilation debug="true">
- <assemblies>
- <!--
- 配置oracle
- -->
- <add assembly="System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
- </assemblies>
- </compilation>
- </system.web>
- </configuration>
Database.cs文件
- using System.Data.OracleClient;
- public class Database
- {
- protected OracleConnection Connection;
- protected String ConnectionString;
- /// <summary>
- /// 构造函数
- /// </summary>
- public Database()
- {
- ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString ;
- }
- }
然后把后面的sqlcommand sqladapter之类全部换成oracle