我正在尝试显示数据库中的表计数。我有一个返回行数的函数。我是C#的新手,我不确定如何在html中调用该函数,以便它显示返回的值。
这是我从How to count the number of rows from sql table in c#?获得的c#函数:
public int Get_Count(object sender, EventArgs e)
{
{
string stmt = "SELECT COUNT(*) FROM dbo.listing";
int count = 0;
using (SqlConnection thisConnection = new SqlConnection("Data Source=DATASOURCE"))
{
using (SqlCommand cmdCount = new SqlCommand(stmt, thisConnection))
{
thisConnection.Open();
count = (int)cmdCount.ExecuteScalar();
}
}
return count;
}
}
这是我想显示返回计数的HTML行:
Get_Count() results found
参考方案
页面加载事件
protected void Page_Load(object sender, EventArgs e