下面我們直接用可變長度參數的方式寫一個完整的SqlHelper增刪改public static int ExecuteNonQuery(string sql,params Parameter[] parameters){ using(SqlConnection conn = new SqlConnection(conStr)) { conn.Open(); using(SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText=sql; cmd.Parameters.AddRange(parameters); return cmd.ExecuteNonQuery(); } }}查public static object ExecuteScalar(string sql,params Parameter[] parameters){ using(SqlConnection conn = new SqlConnection(conStr)) { conn.Open(); using(SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText=sql; cmd.Parameters.AddRange(parameters); SqlDataAdapter adpter = new SqlDataAdapter(cmd); DataSet data = new DataSet(); adapter.Fill(data); return data; } }}新聞熱點
疑難解答