App_Code/Iface/Tools.cs

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

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

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

/// <summary>
/// Tools 的摘要说明
/// </summary>
public class Tools
{
    OleDbConnection myConnection;
    OleDbCommand myCommand = new OleDbCommand();

    public void GetConnection()
    {

        //1.连接数据库
        String ConnStr = ConfigurationManager.ConnectionStrings["CONNECTIONSTRING"].ConnectionString;
        myConnection = new OleDbConnection(ConnStr);
        myConnection.Open();
    }

    #region 公共方法

    /// <summary>
    /// 执行查询语句，返回DataSet
    /// </summary>
    /// <param name="SQLString">查询语句</param>
    /// <returns>DataSet</returns>
    public DataSet Query(string SQLString)
    {
        DataSet ds = new DataSet();
        try
        {
            GetConnection();

           OleDbDataAdapter command;

            string[] tempsql = SQLString.Split(';');
            for (int i = 0; i < tempsql.Length; i++)
            {
                command = new OleDbDataAdapter(tempsql[i], myConnection);
                command.Fill(ds, i.ToString());
            }

            return ds;
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message);
        }
        finally
        {