连接数据库以后怎么返回聚合函数的值?
page_load{SqlConnection conn2 = new SqlConnection(ConfigurationManager.ConnectionStrings["MyRomeConnectionString"].ConnectionString);
conn.Open();
string sql2 = "select count(*) as count from Notice where NoticeTo='" + Session["membername"] + "'";
SqlCommand cmd2 = new SqlCommand(sql2, conn2);
cmd2.ExecuteNonQuery();
conn2.Close();
Label1.Text = count;
.......
}
我想把连接数据库以后得到的count返回到本页面中的label1中。 --------------------编程问答-------------------- SqlDataReader Or DataSet --------------------编程问答-------------------- 你只返回一行一列的话,用
string count = cmd2.ExecuteScalar();
conn2.Close();
Label1.Text = count.ToString();
补充:.NET技术 , ASP.NET