sqlhelp类

namespace _11-27Asp.lianxi
{
    public class SqlHelper
    {
        //注册
       public  static String connStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
        public static int ExecuteNoQuery(string sql,params SqlParameter [] parameters)
        {
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = sql;
                   foreach (SqlParameter parameter in parameters )
                   {
                       cmd.Parameters.Add(parameter);
                   }
                  return  cmd.ExecuteNonQuery();
                }

            }
        }
        //登陆
        public static object ExecuteScalar(string sql, params SqlParameter[] parameters)
        {
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = sql;
                    foreach (SqlParameter parameter in parameters)
                    {
                        cmd.Parameters.Add(parameter);
                    }
                    return cmd.ExecuteScalar();
                }

            }
       
       
       
        }
        //读
        public static SqlDataReader ExecuteReader(string sql, params SqlParameter[] parameters)
        {
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = sql;

                    foreach (SqlParameter parameter in parameters)
                    {
                        cmd.Parameters.Add(parameter);
                    }

                    return cmd.ExecuteReader();
                }

            }
        }
       
        public static DataTable ExecuteDataTable(string sql, params SqlParameter[] parameters)
        {
            using(SqlConnection conn=new SqlConnection(connStr))
         {
         conn.Open();
                using(SqlCommand cmd=conn.CreateCommand())
             {
                    cmd.CommandText = sql;
                    foreach (SqlParameter parameter in parameters)
                    {
                        cmd.Parameters.Add(parameter);
                   
                    }
                    DataSet dataset = new DataSet();
                    SqlDataAdapter adapter = new SqlDataAdapter(cmd);
                    adapter.Fill(dataset);
                    return dataset.Tables[0];
             }
         }
       
        }
    }
}