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();
}
}
