急急急急急急急急急急急急，不行啊

Question

public static object ExecuteScalar(string sql, SqlParameter[] parameters)
{
if (parameters != null)
{
foreach (SqlParameter p in parameters)
{
if (p.Value == null)// || p.Value.ToString().Trim() == "System.Byte[]")
p.Value = DBNull.Value;
}
}
using (SqlConnection con = new SqlConnection(ConnectionString))
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
if (parameters != null)
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddRange(parameters);
}
else
{
cmd.CommandType = CommandType.Text;
}
cmd.CommandText = sql;
try
{
con.Open();
return cmd.ExecuteScalar();
}
catch
{
return string.Empty;
}
}
}
}

Answer 1

你具体是什么问题，这代码用来执行一个sql返回第一行第一列