string sql = "select count(*) from table";//可以加where条件
int value=ExecuteScalar(sql);
}
public static int ExecuteScalar(string cmdtext)
{
SqlConnection conn = new SqlConnection();
SqlCommand cmd = conn.CreateCommand();
conn.Open();
conn.ConnectionString = "链接字符串";
int value;
try
{
cmd = new SqlCommand(cmdtext, conn);
value = Convert.ToInt32(cmd.ExecuteScalar());
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return value;
获取数据库的条目
最新推荐文章于 2022-09-10 12:01:44 发布