App_Code/DB.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using System.Collections.Generic;



/// <summary>
/// DB 的摘要说明
/// </summary>
public class DB
{
    //下载于51aspx.com
    public static string ConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Server.MapPath("~") + @"\data\db_traincenter.mdb";
    //下载于51aspx.com
    public static string ErrMsg = "";
    //下载于51aspx.com
    public static List<OleDbParameter> lstPara = new List<OleDbParameter>();

    public static DataTable GetTable(string strSql)
    {
        OleDbConnection conn = null;
        try
        {
            conn = new OleDbConnection(ConnString);
            OleDbDataAdapter ada = new OleDbDataAdapter(strSql, conn);
            DataSet ds = new DataSet();
            ada.Fill(ds);

            return ds.Tables[0];
        }
        catch (OleDbException ex)
        {
            ErrMsg = ex.Message;
            return null;
        }
        finally
        {
            if (conn != null) conn.Close();
        }
    }

    public static object GetField(string strSql)
    {
        OleDbConnection conn = null;
        try
        {
            conn = new OleDbConnection(ConnString);

            OleDbCommand cmd = new OleDbCommand(strSql, conn);
            conn.Open();
            return cmd.ExecuteScalar();
        }