using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
using (SqlCommand cmd = con.CreateCommand())
{
try{
cmd.CommandText = sql;
cmd.Parameters.AddRange(parameters);
return Convert.ToInt32( cmd.ExecuteScalar());
}
catch(Exception ex)
{
throw new Exception(ex.Message);
}
}
}
else
{
return -1;
}
}
/// <summary>
/// 主要执行查询操作
/// </summary>
/// <param name="sql">执行的sql语句</param>
/// <param name="parameters">参数数组</param>
/// <returns></returns>
publicstatic DataTable ExecuteDataTable(string sql, params SqlParameter[] parameters)
{
if (string.IsNullOrEmpty(sql))
{
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
using (SqlCommand cmd = con.CreateCommand())
{
本文来自电脑杂谈,转载请注明本文网址:
http://www.pc-fly.com/a/jisuanjixue/article-28238-4.html
真买挣了买豪门的