如何连接ACCESS数据库

   public partial class _Default : System.Web.UI.Page
    {
        // 连接字符串
        private String strConnect = "provider=microsoft.jet.oledb.4.0;data source=" + System.Web.HttpContext.Current.Server.MapPath("App_Data/DemoDB.mdb");
        OleDbConnection objConnection;
        // 要对数据源执行的SQL或者是存储过程
        OleDbCommand cmd;

 

        protected void Page_Load(object sender, EventArgs e)
        {

            this.objConnection = new OleDbConnection(strConnect);
            // 如果是第一次载入
            if (!Page.IsPostBack)
            {
                cmd = new OleDbCommand("select count(NEWS_ID)   from   NEWS", objConnection);
                objConnection.Open();
                // 设置要分页的数据的总数  
                AspNetPager1.RecordCount = (int)cmd.ExecuteScalar();
                //objConnection.Close();
                AspNetPager1.DataBind();
                //绑定数据  
                BindData();
                objConnection.Close();

            }

        }
        /*
         * 数据绑定方法
         */
        void BindData()
        {
            cmd = new OleDbCommand("SELECT   NEWS_ID,NEWS_NO,NEWS_TITLE,NEWS_CONTENT,NEWS_DATE   FROM   NEWS   ORDER BY NEWS_ID DESC", this .objConnection );
            // 数据适配器，用于填充数据集（DataSet）
            OleDbDataAdapter adapter = new OleDbDataAdapter(cmd);
            // 声明数据集和
            DataSet ds = new DataSet();
            // 注意下面这句，只填充当前页要显示的数据，不能把所有数据全填充到DataSet中，否则无法实现分页  
            adapter.Fill(ds, AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, "NEWS");
            dlist.DataSource = ds.Tables["NEWS"];
            dlist.DataBind();
        }