Oracle和SqlServer数据库连接

1.SqlServer连接

①App.config中的配置

 <configuration> 
    <connectionStrings> 
        <add name="sqlConnstring"         connectionString="server=10.52.6.11;database=AccountDB;uid=sa;pwd=wz!sfc168;"         providerName="System.Data.SqlClient"/> 
    </connectionStrings> 
</configuration>

②SqlHelper代码实现
using System.Data.SqlClient;    //SqlServer引用

public static readonly string connString = ConfigurationManager.ConnectionStrings["sqlConnstring"].ConnectionString;  //连接字符串

 
public static DataTable ExecuteDataTable(string strSql, params SqlParameter[] parms)
{
      DataTable dt = new DataTable();
      using (SqlConnection conn = new SqlConnection(connString))
      {
           SqlCommand cmd = new SqlCommand(strSql, conn);
           //cmd.CommandType = CommandType.StoredProcedure;   //存储过程
           cmd.CommandType = CommandType.Text;                         //Sql语句
           cmd.Parameters.Clear();
           cmd.Parameters.AddRange(parms);
           conn.Open();
           SqlDataAdapter adapter = new SqlDataAdapter();
           adapter.SelectCommand = cmd;
           adapter.Fill(dt);
           return dt;
       }

}

2.Oracle连接

①App.config中的配置

<configuration> 
    <connectionStrings>
        <add name="oracleConnstring" connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.152.204.10)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=MESDB)));Persist Security Info=True;User ID=sa;Password=!sa******;" providerName="Oracle.DataAccess.Client"/> 
    </connectionStrings> 
</configuration>

②OracleHelper代码实现
using Oracle.ManagedDataAccess.Client;  //引用Oracle客户端

public static readonly string connString = ConfigurationManager.ConnectionStrings["oracleConnstring"].ConnectionString;  //连接字符串

 using (OracleConnection conn = new OracleConnection(connString))
 {
          conn.Open();
          OracleCommand cmd = conn.CreateCommand();
          cmd.CommandText = "SELECT ************";        //sql脚本语句
          OracleDataReader odr = cmd.ExecuteReader();
          while (odr.HasRows)
         {
              txtResult.Text = odr.GetString(0);
         }
        odr.Close();
}

这篇好文章是转载于：学新通技术网