適用於 COUNT(*)、MAX(id) 等返回單值的查詢。
public static string GetSqlAsString(string sqlText, SqlParameter[] parameters, string connStr)
{
string result = "";
using (SqlConnection conn = new SqlConnection(connStr))
using (SqlCommand cmd = new SqlCommand(sqlText, conn))
{
if (parameters != null) cmd.Parameters.AddRange(parameters);
conn.Open();
object obj = cmd.ExecuteScalar();
if (obj != null && obj != DBNull.Value)
result = obj.ToString();
}
return result;
}
string count = GetSqlAsString(
"SELECT COUNT(*) FROM Users WHERE Status = @status",
new SqlParameter[] { new SqlParameter("@status", 1) },
connStr);