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" 
            οnclick="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();
    }
}

效果如下:



评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值