public static object ExecuteScalar(string sql, params SqlParameter[] ps) { using (SqlConnection connection = new SqlConnection(connStr)) { SqlCommand command = new SqlCommand(sql, connection); command.Parameters.AddRange(ps); connection.Open(); return command.ExecuteScalar(); } }
public static DataTable GetList(string sql, params SqlParameter[] ps) { using (SqlConnection connection = new SqlConnection(connStr)) { SqlDataAdapter adapter = new SqlDataAdapter(sql, connection); if (ps.Length > 0) { adapter.SelectCommand.Parameters.AddRange(ps); } DataTable dataTable = new DataTable(); adapter.Fill(dataTable); return dataTable; } }
public static int ExecuteNonQuery(string sql, CommandType ct, params SqlParameter[] ps) { using (SqlConnection connection = new SqlConnection(connStr)) { SqlCommand command = new SqlCommand(sql, connection); if ((ps != null) && (ps.Length > 0)) { command.Parameters.AddRange(ps); } command.CommandType = ct; connection.Open(); return command.ExecuteNonQuery(); } }