C# label 怎么样挷定dataset的数据

【转自】 http://hi.baidu.com/starwfx/blog/item/57680ac4df6e99af8226acc1.html

 

public void sumstudent()
{
SqlConnection conn = new SqlConnection(@"Data Source=CAIMAOYUE;Initial Catalog=stuDB;Integrated Security=True");
conn.Open();
SqlCommand cmd = new SqlCommand("select count(stuName) as sumstudent from (select stuName from sumstudent group by stuName,stuSex,stuAge) as temp", conn);

SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
this.label1.Text = ds.ToString();
conn.Close();

}