asp.net自定义数据库连接类(OLEDB)

类库.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();
    }
}

效果如下:



郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。