数据库操作小类

最新推荐文章于 2024-10-02 00:27:17 发布

takeie

最新推荐文章于 2024-10-02 00:27:17 发布

阅读量571

点赞数

文章标签：数据库 dataset string system class 存储

本文链接：https://blog.csdn.net/takeie/article/details/1598010

版权

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

/// <summary>
/// DbFunction 的摘要说明
/// </summary>
public class DbFunction
{
    readonly static string sqlstr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
   static SqlConnection MyConn;
public DbFunction()
{
  //
  // TODO: 在此处添加构造函数逻辑
  //
}
    public static SqlConnection Open()
    {
        //返回并打开sqlconnection
         MyConn = new SqlConnection(sqlstr);
       MyConn.Open();
       return MyConn;
    }
    public static int ExecuteSqltStr(string CommStr)
    {
        //执行Sqlsting
        SqlCommand Comd = new SqlCommand(CommStr, MyConn);
        Comd.CommandType = CommandType.Text;
        int nAffected = Comd.ExecuteNonQuery();
        return nAffected;
    }
    public static DataSet GetDataSet(string ComdStr)
    {
        //获得Dataset

        SqlDataAdapter adAdapter = new SqlDataAdapter();
        adAdapter.SelectCommand = new SqlCommand(ComdStr, MyConn);
        adAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
        DataSet drDataSet = new DataSet();
        adAdapter.Fill(drDataSet);
        return drDataSet;
    }
    public static SqlDataReader GetDataReader(string Comdstr)
    {
        //获得Databeader
        SqlCommand Comd = new SqlCommand(Comdstr,MyConn);
        SqlDataReader Datareader = Comd.ExecuteReader();
        return Datareader;
    }
    public static int ExecuteSqlPro(string CommStr)
    {
        //执行存储过程
        SqlCommand Comd = new SqlCommand(CommStr, MyConn);
        Comd.CommandType = CommandType.StoredProcedure;
        int nAffected = Comd.ExecuteNonQuery();
        return nAffected;
    }
    public static void Close()
    {
        //关闭链接
        MyConn.Close();
    }
}