C#操作3大常用数据库的源码和要点

      1、C#连接ORACLE的实现代码

    首先要在后台添加引用

using System.Data.OracleClient;

using System.Data;

连接时需要ConnectionString字符串，出现在web.config文件中，如下所示：

       称;User ID=用户名;Password=密码;"providerName="System.Data.OracleClient"/>
                                                                                                                                                                                另外一种连接字符串写法：

        
   

  

对应的调用字符串                                                                              

{                                                                                                  private string strconnect =ConfigurationManager.ConnectionStrings["connection"].ToString();
    privatestring strconnect =ConfigurationManager.AppSettings["OraConnString"].ToString();

}

 

操作数据库的方法（写一个简单的小实例：）

       public DataTable ExecuteSQLFillTable(string strSQL)
       {
           DataTable dt = new DataTable();
           OracleConnection conn = new OracleConnection(strconnect);
           OracleCommand cmd = conn.CreateCommand();
           cmd.CommandText = strSQL;
           OracleDataAdapter adapter = new OracleDataAdapter(cmd);
           adapter.Fill(dt);
           return dt;
       }                                                                                        

2、C#操作sqlserver数据库 

    首先要在后台添加引用

using System.Data.OracleClient;

usingSystem.Data;   

 

.confi配置文件设置如下

 
        ID=******;Password=******;Max Pool Size=4096"/>  

                                                                              

使用方法同oracle大同小异。 操作数据库时只是使用的类有所改变。   

 

操作数据库的方法（写一个简单的小实例：）

public DataTable ExecuteSQLFillTable(string strSQL)
{
DataTable dt = new DataTable();
SqlConnection conn = new SqlConnection (strconnect);
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = strSQL;
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(dt);
return dt;
}                                                                                           

  3、C#操作MySql数据库

 

web.config配置       
   

 

MySqlConnection myConnection= newMySqlConnection("Database=xbxx;DataSource=localhost;UserId=root;Password=baobaowawa");

MySqlCommand myCommand =new MySqlCommand(query,myConnection);

myCommand.Connection =myConnection;

myConnection.Open();

MySqlDataReadermyReader;

myReader =myCommand.ExecuteReader();