110,533
社区成员
发帖
与我相关
我的任务
分享
string strSql = "SELECT COUNT(*) FROM ABC;
using (SqlConnection sqlCnn = GetSqlConnection())
{
SqlCommand sqlCmm = new SqlCommand(strSql, sqlCnn);
int num=sqlCmm.ExecuteScalar();
response.write(“你有“+num.ToString()+”篇日志”);}
string strSql = "SELECT COUNT(*) FROM ABC;
return Reslut = PublicClass.GetFirstData(strSql);//这不就得到结果了?
public static string GetFirstData(string strSql)
{
try
{
using (SqlConnection sqlCnn = GetSqlConnection())
{
SqlCommand sqlCmm = new SqlCommand(strSql, sqlCnn);
return sqlCmm.ExecuteScalar().ToString().Trim();
}
}
catch
{
return "";
}
}