App_Code/access.cs

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

using System;
using System.Data;
using System.Data.OleDb;
//using System.Data.SqlClient;
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;


//该源码下载自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)
/// <summary>
/// access 的摘要说明
/// </summary>
public class access
{
	public access()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    public static string connstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.Web.HttpContext.Current.Server.MapPath("~/App_Data/web.mdb");
    //public static string connstring = ConfigurationManager.AppSettings["test"];

    public static DataSet GDS(string sql)
    {
        OleDbDataAdapter dap = new OleDbDataAdapter(sql,connstring);
        //SqlDataAdapter dap = new SqlDataAdapter(sql,connstring);
        DataSet ds = new DataSet();
        dap.Fill(ds);
        return ds;
    }
    public static void Dsql(string sql)
    {
        OleDbConnection conn = new OleDbConnection();
        //SqlConnection conn = new SqlConnection();
        conn.ConnectionString = connstring;
        conn.Open();
        OleDbCommand cmd = new OleDbCommand(sql,conn);
        //SqlCommand cmd = new SqlCommand(sql,conn);
        cmd.ExecuteNonQuery();
        conn.Close();
    }
}