標籤：asp.net 類 庫
類庫.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(); }}
asp.net自訂資料庫連接類（OLEDB）
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
