using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data.SqlClient;using System.Data;namespace 網吧計費系統 class SqlHelper static string connStr = server=.;database=netBarDb;uid=sa;pwd=123456; /增刪改 #region / / 執行增刪改語句 / / insert/delelt/update語句 / 參數的數組 / public static int ExecuteNonQuery(string sql, params SqlParameter parameters) /創建連接對象 SqlConnection conn = new SqlConnection(connStr); conn.Open(); /創建命令對象 SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddRange(parameters); /返還受影響的行數 int row = cmd.ExecuteNonQuery(); conn.Close(); return row; #endregion /單行單列查詢 #region / / 單行單列查詢 / / select語句 / 參數數組 / 第一列第一行的內容 public static object ExecuteScalar(string sql, params SqlParameter parameters) /創建連接對象 /SqlConnection conn = new SqlConnection(connStr); /conn.Open(); /創建命令對象 /SqlCommand cmd = new SqlCommand(sql, conn); /cmd.Parameters.AddRange(parameters); /object obj = cmd.ExecuteScalar(); /conn.Close(); /return obj; 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(); #endregion /多行多列查詢 #region / / 多行多列連接查詢 / / select語句 / 參數數組 / SqlDataReader讀取器 public static SqlDataReader ExecuteReader(string sql, params SqlParameter parameters) SqlConnection conn = new SqlConnection(connStr); conn.Open(); /創建連接對象 SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddRange(parameters); SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); return reader; #endregion /斷開式查詢 #region / / 斷開式查詢 / / select語句 / 參數的數組 / 數據集 public static DataSet ExecuteDataSet(string sql, params SqlParameter parameters) /創建連接對象 SqlConnection conn = new SqlConnection(connStr); conn.Open(); SqlCommand cmd = new SqlCommand(sql,conn); cmd.Parameters.AddRange(parameters); /創建數據適配器 SqlDataAdapter adapter = new SqlDataAdapte