一个简单问题，在线等~~马上结贴！！

[mynewjob]

SqlCommand sqlcm = new SqlCommand("select cast(round(avg(cast(NO as numeric(8,1))),1) as numeric(8,1)) from tblFinish",sqlconn);

sqlconn.Open();
sqlcm.ExecuteNonQuery().ToString();

TextBox11.Text=（如何把获得的平均值赋给TextBox呀？？？）

sqlconn.Close();

[layeryli]

SqlCommand sqlcm = new SqlCommand("select cast(round(avg(cast(NO as numeric(8,1))),1) as numeric(8,1)) from tblFinish",sqlconn);

sqlconn.Open();
TextBox11.Text=sqlcm.ExecuteScalar().ToString();
sqlconn.Close();

[mynewjob]

可是在查询器里查到是2.8，但显示是-1呀

[mynewjob]

怎么没人回答呀？？

[bidisty]

sqlconn.Open();
TextBox11.Text=sqlcm.ExecuteScalar;
sqlconn.Close();

[bidisty]

TextBox11.Text=sqlcm.ExecuteScalar();