asp.net自定义数据库连接类（OLEDB）

浏览数：23 / 时间：2015年06月12日

类库.cs代码如下：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.OleDb;

/// <summary>
///Myclass 的摘要说明
/// </summary>
/// 
namespace test
{
    public class superCnn
    {
        public OleDbConnection cnn;
        private OleDbCommand cmd;
        private OleDbDataReader datar;
        public superCnn(string mdbFileName)
        {
            string _path = "~\\App_Data\\" + mdbFileName;
            string str_conn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="
                + System.Web.HttpContext.Current.Server.MapPath(_path);
            //MapPath(_path); 
            cnn = new OleDbConnection(str_conn);
        }
        public void open() {
            cnn.Open();
        
        }
        public void close()
        {
            cnn.Close();

        }
        public OleDbDataReader getDatar(string _sql) {
            cmd = new OleDbCommand(_sql, cnn);
            datar = cmd.ExecuteReader();
            return datar;
        
        }
    }
}

.aspx代码如下：

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="superCnn_test.aspx.cs" Inherits="superCnn_test" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>

<asp:Button ID="btn_test" runat="server" Text="测试superCnn"
onclick="btn_test_Click" />

</div>
</form>
</body>
</html>

.aspx.cs代码如下：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using test;
using System.Data.OleDb;

public partial class superCnn_test : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btn_test_Click(object sender, EventArgs e)
    {
        superCnn cnn = new superCnn("data.mdb");
        cnn.open();
        OleDbDataReader datar = cnn.getDatar("select * from T_IMGS");
        while (datar.Read()) {
            Response.Write(datar["img_url"].ToString()+"<br>");
        }
        cnn.close();
    }
}

效果如下：