SQLHelper, sqlhelper class

SQLHelper, sqlhelper class

/// <Summary> /// obtain the connection string /// </summary> private static readonly string constr = ConfigurationManager. connectionStrings ["dbUser"]. connectionString; // <summary> // returns the number of affected rows (non-query statement) /// </summary> /// <param name = "SQL"> SQL statement </param> /// <param name = "parameters"> parameterized query </param >/// <returns> </returns> public static int ExecuteNonQuery (string SQL, params SqlParameter [] parameters) {using (SqlConnection conn = new SqlConnection (constr) {conn. open (); using (SqlCommand cmd = conn. createCommand () {cmd. commandText = SQL; cmd. parameters. addRange (parameters); return cmd. executeNonQuery ();}}} /// <summary> /// return the first column of the First row in the query result set /// </summary> /// <param name = "SQL"> SQL statement </param> /// <param name = "parameters"> parameterized query </param> /// <returns> </returns> public static object ExecuteScalar (string SQL, params SqlParameter [] parameters) {using (SqlConnection conn = new SqlConnection (constr) {conn. open (); using (SqlCommand cmd = conn. createCommand () {cmd. commandText = SQL; cmd. parameters. addRange (parameters); return cmd. executeScalar () ;}}/// <summary> /// the returned query result contains multiple data records, store data in the database /// </summary> /// <param name = "SQL"> SQL statement </param> /// <param name = "parameters"> parameterization query </param> /// <returns> </returns> public static SqlDataReader ExecuteReader (string SQL, params SqlParameter [] parameters) {using (SqlConnection conn = new SqlConnection () {conn. open (); using (SqlCommand cmd = conn. createCommand () {cmd. commandText = SQL; cmd. parameters. addRange (parameters); return cmd. executeReader () ;}}/// <summary> /// the returned query result contains multiple data records, store data in the local cache /// </summary> /// <param name = "SQL"> SQL statement </param> /// <param name = "parameters"> parameterized query </param> /// <returns> </returns> public static DataTable ExecuteDataSet (string SQL, params SqlParameter [] parameters) {using (SqlConnection conn = new SqlConnection (constr )){
Conn. open () using (SqlCommand cmd = conn. createCommand () {cmd. commandText = SQL; cmd. parameters. addRange (parameters); DataSet dataset = new DataSet (); SqlDataAdapter adapter = new SqlDataAdapter (cmd); adapter. fill (dataset); return dataset. tables [0] ;}} /// <summary> /// convert Null in the database to null // </summary> /// <param name = "value"> </param> // /<returns> </returns> public static object OutputNull (object value) {if (value = DBNull. value) return null; else return value ;} /// <summary> /// convert the null value of the input data to Null in the database // </summary> /// <param name = "value"> </param >/// <returns> </returns> public static object InputNull (object value) {if (value = null) return DBNull. value; else return value ;}}