sql 链接数据库 执行方法

DataBase

 

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

/// <summary>
/// DataBase 的摘要说明
/// </summary>
public class DataBase
{
 public DataBase()
 {
  //
  // TODO: 在此处添加构造函数逻辑
  //
 }
    private SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString);

    public SqlConnection MyConn
    {
        get { return conn; }
    }
}

-----------------------------------------------------------------------------

 

DataCom

 

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;

/// <summary>
/// DataCom 的摘要说明
/// </summary>
public class DataCom:DataBase
{
 public DataCom()
 {
  //
  // TODO: 在此处添加构造函数逻辑
  //
 }
    public DataTable ExeDT(SqlCommand cmd) {
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
        return dt;
    }
    public DataSet ExeDST(SqlCommand cmd)
    {
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet dt = new DataSet();
        da.Fill(dt);
        return dt;
    }
    public int ExeNo(SqlCommand cmd)
    {
        MyConn.Open();
        int i = cmd.ExecuteNonQuery();
        MyConn.Close();
        return i;
    }
    public int ExeScr(SqlCommand cmd)
    {
       
        cmd.Connection = MyConn;
        MyConn.Open();
        int i = Convert.ToInt32(cmd.ExecuteScalar());
        MyConn.Close();
        return i;

    }
    public DataSet FYExeDt(SqlCommand cmd, int start, int max, string table)
    {
        SqlDataAdapter da = new SqlDataAdapter(cmd);//创建适配器对象，参数为执行对象
        DataSet dt = new DataSet();//创建内存表对象
        da.Fill(dt, start, max, table);//用适配器对象填充内存表
        return dt;//返回内存表对象
    }
}

 

-----------------------------------------------------

 

FJX

 

 

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

/// <summary>
/// FJX 的摘要说明
/// </summary>
public class FJX:DataCom
{
 public FJX()
 {
  //
  // TODO: 在此处添加构造函数逻辑
  //
 }
    /// <summary>
    /// 查询
    /// </summary>
    /// <param name="strSelect">列名(*)</param>
    /// <param name="strWhere">where语句(where id="+id+")</param>
    /// <param name="strTableName">表名(table)</param>
    /// <param name="strOrder">排列order by id desc</param>
    /// <returns></returns>
    public DataTable List(string strsql)
    {
       // string strsql = "select " + strSelect + " from " + strTableName + " " + strWhere + " " + strOrder + "";
        SqlCommand cmd = new SqlCommand(strsql, MyConn);
        return ExeDT(cmd);
    }
    /// <summary>
    /// 分页查询
    /// </summary>
    /// <param name="strSelect">列名(*)</param>
    /// <param name="strWhere">where语句(where id="+id+")</param>
    /// <param name="strTableName">表名(table)</param>
    /// <param name="strOrder">排列order by id desc</param>
    /// <param name="start">int 开始数</param>
    /// <param name="max">int 最大数</param>
    /// <returns></returns>
    public DataSet FYList(string strsql, int start, int max, string strTableName)
    {
        SqlCommand cmd = new SqlCommand(strsql, MyConn);
        return FYExeDt(cmd, start, max, strTableName);
    }
    /// <summary>
    ///  插入
    /// </summary>
    /// <param name="strTableName">string strTableName = "users(username,userpwd)";</param>
    /// <param name="strinsert">string strinsert = "('aaa','bbb')";</param>
    /// <returns></returns>
    public int Add(string strsql)
    {
        SqlCommand cmd = new SqlCommand(strsql, MyConn);
        return ExeNo(cmd);
    }
    /// <summary>
    /// 删除
    /// </summary>
    /// <param name="strTableName">string strTableName = "users";</param>
    /// <param name="strWhere"> string strWhere = "where sid=6";</param>
    /// <returns></returns>
    public int Del(string strsql)
    {
        SqlCommand cmd = new SqlCommand(strsql, MyConn);
        return ExeNo(cmd);
    }
    /// <summary>
    /// 修改
    /// </summary>
    /// <param name="strTableName"> string strTableName = "users";</param>
    /// <param name="strWhere">string strWhere = "where sid=3";</param>
    /// <param name="strupdate">string strupdate = "username=4,userpwd=4";</param>
    /// <returns></returns>
    public int Up(string strsql)
    {
        SqlCommand cmd = new SqlCommand(strsql, MyConn);
        return ExeNo(cmd);
    }
}