数据库操作类

最新推荐文章于 2019-06-20 19:26:16 发布

Mondevideo

最新推荐文章于 2019-06-20 19:26:16 发布

阅读量681

点赞数

文章标签：数据库 string dataset cmd null

本文链接：https://blog.csdn.net/Mondevideo/article/details/1857341

版权

public static SqlConnection ReturnCon()
        {
            string strCon=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
            SqlConnection con=new SqlConnection(strCon);
            if(con.State.Equals(ConnectionState.Closed))
           {
                con.Open();
            }
            return con;
         }

public static SqlCommand Creatcmd(string procname,SqlParameter[] prams)
        {
            SqlConnection con = ReturnCon();
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = procname;
            cmd.CommandType = CommandType.StoredProcedure;
            if(prams!=null)
            {
                foreach(SqlParameter parameter in prams)
                {
                    if(parameter!=null)
                    {
                        cmd.Parameters.Add(parameter);
                    }
                }
            }
            return cmd;
        }

public static int RunExecute(string procname,SqlParameter[] prams)
      {
            SqlConnection con=ReturnCon();
            SqlCommand cmd=Creatcmd(procname,prams,con);
            int intResult=Convert.ToInt32(cmd.ExecuteNonQuery());
            con.Close();
            return intResult;
        }

public static int RunExecuteScalar(string procname,SqlParameter[] prams)
      {
            SqlConnection con=ReturnCon();
            SqlCommand cmd=Creatcmd(procname,prams,con);
            int intResult=Convert.ToInt32(cmd.ExecuteScalar());
            con.Close();
            return intResult;
        }

  public static SqlDataReader RunProGetReader(string procname,SqlParameter[] prams)
        {
            SqlCommand cmd=Creatcmd(procname,prams);
            SqlDataReader sdr=cmd.ExecuteReader(CommandBehavior.CloseConnection);
            return sdr;
        }

  public static DataTable RunProGetTable(string procname,SqlParameter[] prams)
        {
            SqlCommand cmd=Creatcmd(procname,prams);
            SqlDataAdapter sda=new SqlDataAdapter();
            DataSet ds=new DataSet();
            sda.SelectCommand=cmd;
            sda.Fill(ds);
            DataTable dt=ds.Tables[0];
            con.Close();
            return dt;
        }