ADO.net公共增删改查

public class DBhelper
    {
        public static SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=库名;User ID=密码");

        //查询
        public SqlDataReader select(string sql)
        {
            SqlDataReader reader = null;
            conn.Open();
            SqlCommand comm = new SqlCommand(sql, conn);
            reader = comm.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
            return reader;
        }
        //删除、添加、更改
        public static int ExecuteUpdate(string sql)
        {
            int result = 0;
            conn.Open();
            SqlCommand comm = new SqlCommand(sql, conn);
            result = comm.ExecuteNonQuery();
            conn.Close();
            return result;
        }
        //单条数据的查询
        public static Object ExecteOnlyOneVaule(string sql)
        {
            Object obj = null;
            conn.Open();
            SqlCommand comm = new SqlCommand(sql, conn);
            obj = comm.ExecuteScalar();
            conn.Close();
            return obj;
        }
    }

　　

转载于:https://www.cnblogs.com/Douglass/p/3653372.html