sqlserver2000、oracle、firebrid数据库配置vs2003

 sqlserver2000配置vs2003：
 

// webconfig配置：
     < appSettings >
     < add key = " strconn "  value = " server=.;uid=sa;pwd=sa;database=olog " ></ add >
   </ appSettings >

// 引入：
using  System.Data.SqlClient;
using  System.Configuration;
// 连接操作代码
  public  SqlConnection con;
         public  DB()
         ... {
            string strcon = ConfigurationSettings.AppSettings["strconn"].ToString();
                         con = new SqlConnection(strcon);
        }
        // 根据sql获得表内容
         public  DataTable GetData( string  sql)
         ... {
            SqlDataAdapter sda = new SqlDataAdapter(sql,con);
            DataTable dt = new DataTable();
            con.Open();
            sda.Fill(dt);  
            con.Close();
            return dt;
        
        }
          // 语句的执行。。。。。
         public   void  ExeSql( string  sql)
         ... {
            SqlCommand cmd = new SqlCommand(sql,con);
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();

        }
         // 取得唯一的参数
         public   string  Excegetonly( string  sql)
         ... {
            SqlCommand cmd = new SqlCommand(sql,con);
            con.Open();
             string only = cmd.ExecuteScalar().ToString();
            con.Close();
            return only;

        }

oracle配置vs2003：

// webconfig配置代码：
   < appSettings >
  < add key = " ConnString "  value = " Data source=xlpt239;Password=hktb6972;Persist Security Info=True;User Id=hikchina "   />
</ appSettings >
// 注意：xlpt239是oracle的字符串连接符。即oracle中配置的连接字符串在C:oracleora81 etworkADMIN中的
tnsnames.ora文本中
// 引入：
using  System.Data.OracleClient;
using  System.Configuration;
// 连接操作代码：
public   class  DBClass
     ... {
        private OracleConnection conn;
        public DBClass()
        ...{
            //
            // TODO: 在此处添加构造函数逻辑
            //
            string strcon =  ConfigurationSettings.AppSettings["ConnString"];
            conn = new OracleConnection(strcon);
        }
        
        //DataSet读取数据库
        public DataSet DSData(string strSQL,ref string err)
        ...{
            //conn = new OracleConnection(sConnStr);

            try
            ...{
                conn.Open();
                OracleDataAdapter hikcmd=new OracleDataAdapter(strSQL,conn);
                DataSet ds = new DataSet();
                hikcmd.Fill(ds);
                return ds;
            }
            catch(Exception ex)
            ...{
                Close();
                err=ex.Message;
                return null;
            }
        }

        //DataReader读取数据库
        public OracleDataReader GetReaderData(string strSQL,ref string err)
        ...{
            //conn = new OracleConnection(sConnStr);

            try
            ...{
                conn.Open();
                OracleCommand hikQuery=new OracleCommand(strSQL,conn);    
                return hikQuery.ExecuteReader();
            }
            catch(Exception ex)
            ...{    
                Close();
                err=ex.Message;
                return null;
            }
        }
        //string 读取数据库，即一个数据
        public string GetOnlyData(string sql,ref string err)
        ...{
            //conn = new OracleConnection(sConnStr);
            try
            ...{
                conn.Open();
                OracleCommand hikget = new OracleCommand(sql,conn);
                return hikget.ExecuteScalar().ToString();  //.ExecuteScalar().ToString();

            }
            catch(Exception ex)
            ...{
                Close();
                err = ex.Message;
                return null;
            }
        }
        //执行指定Sql语句
        public bool ExecuteSql(String strSQL,ref string err)
        ...{
            //conn = new OracleConnection(sConnStr);

            try
            ...{
                conn.Open();
                OracleCommand hikcmd = new OracleCommand(strSQL,conn);
                hikcmd.ExecuteNonQuery();
                return true;
            }
            catch(Exception ex)
            ...{
                err=ex.Message;
                return false;
            }
            finally
            ...{
                Close();
            }
        }

        //关闭数据库连接 
        public void Close()
        ...{
            conn.Close();
            conn = null;
        }
    }

firebird数据库与vs2003配置：

// webcpnfig配置代码：
      < appSettings >
        
         < add key = " ConnectionString "  value = " Provider=IBOLE.Provider.v4;Password=masterkey;Persist Security Info=True;Data Source=192.168.88.238:HJJC;Pooling=true;Min Pool Size=0;Max Pool Size=20000; "   />
     </ appSettings >   

// 引入：
using  System.Data;
using  System.Data.OleDb;
// 连接操作代码：
public   class  ConnectDataBase
     ... {
        System.Data.OleDb.OleDbConnection conn;
    
        public ConnectDataBase()
        ...{
            string sConnStr = ConfigurationSettings.AppSettings["ConnectionString"];
            conn = new OleDbConnection(sConnStr);
        }

        //DataSet读取数据库
        public DataSet GetDataSet(string strSQL,ref string err)
        ...{
            

            try
            ...{
                if(conn.State == System.Data.ConnectionState.Closed)
                ...{
                    conn.Open();
                }                
                OleDbDataAdapter Da;
                //strSQL ="select user_id,user_name,passwd,remark,qx from hiktb_user_info where user_id='0001'";
                Da = new OleDbDataAdapter(strSQL,conn);
                DataSet ds = new DataSet();
                Da.Fill(ds);

                return ds;

            }
            catch(Exception ex)
            ...{
                
                err=ex.Message;
                return null;
            }
            finally
            ...{
                Close();
            }
        }

        //DataReader读取数据库
        public OleDbDataReader GetReaderData(string strSQL,ref string err)
        ...{
            //conn = new OracleConnection(sConnStr);

            try
            ...{
                if(conn.State == System.Data.ConnectionState.Closed)
                ...{
                    conn.Open();
                }
                System.Data.OleDb.OleDbCommand   fbQuery=new System.Data.OleDb.OleDbCommand (strSQL,conn);
                return fbQuery.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
            }
            catch(Exception ex)
            ...{    
                
                err=ex.Message;
                return null;
            }
            finally
            ...{
                Close();
            }
        }
        //string 读取数据库，即一个数据
        public string GetOneData(string sql,ref string err)
        ...{
            //conn = new OracleConnection(sConnStr);
            try
            ...{
                if(conn.State == System.Data.ConnectionState.Closed)
                ...{
                    conn.Open();
                }
                System.Data.OleDb.OleDbCommand   fbQuery=new System.Data.OleDb.OleDbCommand (sql,conn);
                
                return fbQuery.ExecuteScalar().ToString();

            }
            catch(Exception ex)
            ...{
                
                err = ex.Message;
                return null;
            }
            finally
            ...{
                Close();
            }
        }
        //执行指定Sql语句
        public bool ExecuteSql(String strSQL,ref string err)
        ...{
            

            try
            ...{
                if(conn.State == System.Data.ConnectionState.Closed)
                ...{
                    conn.Open();
                }
                System.Data.OleDb.OleDbCommand  fbQuery=new System.Data.OleDb.OleDbCommand (strSQL,conn);
                fbQuery.ExecuteNonQuery();
                return true;
            }
            catch(Exception ex)
            ...{
                err=ex.Message;
                return false;
            }
            finally
            ...{
                Close();
            }
        }

        //关闭数据库连接 
        public void Close()
        ...{
            conn.Close();
            conn = null;
        }
    }