推荐订阅源

using System;
using System.Collections.Generic;
using System.Text;
using System.Collections;
using System.Data;
using System.Data.OleDb;
using System.Configuration;

namespace Athrun
{
    class OleDbDAL
    {
        //protected static string connectionString = ConfigurationSettings.AppSettings["DefaultDataSource"];//.net1.1
        protected static string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["connString"].ToString();
        public OleDbDAL()
        {
            //構造function
        }
        公用方法

        執行簡單SQL語句

        執行帶參數的SQL語句

        存儲過程操作    
    }
}

1

 using System;
 using System.Collections;
 using System.Collections.Specialized;
 using System.Data;
 using System.Data.OleDb;
 using System.Configuration;
 
   
     public  class DBHelper
     {
         //数据库连接字符串(web.config来配置)
         //<add key="ConnectionString" value="server=127.0.0.1;database=DATABASE;uid=sa;pwd=" />        
         protected static string connectionString = ConfigurationSettings.AppSettings["ConnectionString"];
      
 
         执行简单SQL语句
 
         执行带参数的SQL语句
 
         存储过程操作
 
     }