sql低层操作

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.SqlClient;

public class TempDB
{
    public TempDB()
 {
  //
  // TODO: 在此处添加构造函数逻辑
  //
    }

    public DataSet getDateSet(string sql)
    {
        DB db = new DB();
        DataSet ds = new DataSet();
        db.OpenConnection();
        ds = db.getDateSet(sql);
        db.CloseConnection();
        return ds;
    }

    public void ExceSql(string sql)
    {
        DB db = new DB();
        db.OpenConnection();
        db.ExecuteSql(sql);
        db.CloseConnection();

    }
}

/// <summary>
/// DB 的摘要说明
/// </summary>
public class DB
{
    private readonly string SqlConnectionString = ConfigurationManager.ConnectionStrings["ConnectionStrings"].ConnectionString;//得到连接数据库字符串
    private SqlConnection sqlConn;
    private SqlCommand sqlComm;
    private SqlDataAdapter sqlAdapter;
    private SqlDataReader sqlReader;

 public DB()
 {
  //
  // TODO: 在此处添加构造函数逻辑
  //
    }

    public void OpenConnection()//打开数据库连接
    {
        try
        {
            sqlConn = new SqlConnection(SqlConnectionString);
            sqlConn.Open();
        }
        catch (SqlException ex)
        {
            throw ex;
        }
    }

    public void CloseConnection()
    {
        try
        {
            sqlConn.Close();
            if (sqlComm != null)
            {
                sqlComm.Dispose();
            }
            if (sqlAdapter != null)
            {
                sqlAdapter.Dispose();
            }
            if (sqlReader != null)
            {
                sqlReader.Close();
                sqlReader.Dispose();
            }
        }
        catch (SqlException ex)
        {
            throw ex;
        }
    }

    public DataSet GetDataSet(string sqlStr)
    {
        DataSet ds = new DataSet();
        try
        {
            sqlAdapter = new SqlDataAdapter(sqlStr, sqlConn);
            sqlAdapter.Fill(ds);
        }
        catch (SqlException ex)
        {
            throw ex;
        }
        return ds;
    }

    public SqlDataReader GetDataReader(string sqlStr)
    {
        try
        {
            sqlComm = new SqlCommand(sqlStr, sqlConn);
            sqlReader = sqlComm.ExecuteReader();
        }
        catch (SqlException ex)
        {
            throw ex;
        }

        return sqlReader;
    }

    public int ExecuteSql(string sqlStr)
    {
        int result = 0;
        try
        {
            sqlComm = new SqlCommand(sqlStr, sqlConn);
            result = sqlComm.ExecuteNonQuery();
        }
        catch (SqlException ex)
        {
            throw ex;
        }

        return result;
    }

    public Object Excular(string sqlStr)
    {
        object obj;
        try
        {
            sqlComm = new SqlCommand(sqlStr, sqlConn);
            obj = sqlComm.ExecuteScalar();
        }
        catch (SqlException ex)
        {
            throw ex;
        }

        return obj;
    }
}

//---------------------------------------------------------

        TempDB objdb = new TempDB();
        ...
        dt = objdb.getDateSet(strSql).Tables[0];

//---------------------------------------------------------

    <connectionStrings>
      <add name="ConnectionString" connectionString="server=192.168.0.188;Database=MoneyLine;Uid=sa;Pwd=;Connect Timeout=4000;pooling=true;Max Pool Size=200;Min Pool Size=10"/>
    </connectionStrings>

转载于:https://www.cnblogs.com/lf_software/archive/2009/03/03/1402369.html