Question

请教在ASP.NET怎么输出SQL查询语句的值

Answer 1

SqlConnection conn=....
SqlCommand com=new SqlCommand( "select sum(空位数量) as total from House1 ",conn);
Lable1.Text=com.ExecuteScalar().ToString();