SQL DBHelper

来源：互联网发布：java零基础骗局编辑：程序博客网时间：2024/06/04 00:48
[1]C#连接SQL Service 帮助类
 class DBhelps{          //获取配置文件（Web.config文件）中的连接字符串        private static readonly string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;        //执行update delete insert 操作        //ExecuteNonQuery()        public static int ExecuteNonQuery(string sql, CommandType cmdtype, params SqlParameter[] pms)        {            using (SqlConnection con = new SqlConnection(constr))            {                using (SqlCommand cmd = new SqlCommand(sql, con))                {                    cmd.CommandType = cmdtype;//设置执行的SQL语句的类型                    if (pms != null)                    {                        cmd.Parameters.AddRange(pms);                    }                    con.Open();                    return cmd.ExecuteNonQuery();                }            }        }        //执行返回一个值得select语句        //ExecuteSclare()        public static object ExectueScalar(string sql, CommandType cmdtype, params SqlParameter[] pms)        {            using (SqlConnection con = new SqlConnection(constr))            {                using (SqlCommand cmd = new SqlCommand(sql, con))                {                    cmd.CommandType = cmdtype;                    if (pms != null)                    {                        cmd.Parameters.AddRange(pms);                    }                    con.Open();                    return cmd.ExecuteScalar();                }            }        }        //执行返回多个值得select语句        //ExecuteReader()        public static SqlDataReader ExecuteReader(string sql, CommandType cmdtype, params SqlParameter[] pms)        {            SqlConnection con = new SqlConnection(constr);            using (SqlCommand cmd = new SqlCommand(sql, con))            {                cmd.CommandType = cmdtype;                if (pms != null)                {                    cmd.Parameters.AddRange(pms);                }                try                {                    con.Open();                    return cmd.ExecuteReader(CommandBehavior.CloseConnection);                }                catch                {                    con.Close();                    con.Dispose();                    throw;                }            }        }        //执行返回一张表        //ExeuteAapter()        public static DataTable SqlDataAdapter(string sql, CommandType cmdtype, params SqlParameter[] pms)        {            DataTable table = new DataTable();            using (SqlDataAdapter adapter = new SqlDataAdapter(sql, constr))            {                adapter.SelectCommand.CommandType = cmdtype;                if (pms != null)                {                    adapter.SelectCommand.Parameters.AddRange(pms);                }                adapter.Fill(table);            }            return table;        }    }
阅读全文
0 0