这样就可以了: strSQL="SELECT SUM(Number) AS a1, COUNT(*) AS a2 FROM ..."; SqlCommand cm=new SqlCommand(strSQL,cn); cm.Connection.Open(); SqlDataReader dr = cm.ExecuteReader(); if (dr.Read()) { Textbox1.Text=dr["a1"].ToString().Trim(); Textbox2.Text=dr["a2"].ToString().Trim(); } cm.Connection.Close();
strSQL="SELECT SUM(Number) AS a1, COUNT(*) AS a2 FROM ...";
SqlCommand cm=new SqlCommand(strSQL,cn);
cm.Connection.Open();
SqlDataReader dr = cm.ExecuteReader();
if (dr.Read())
{
Textbox1.Text=dr["a1"].ToString().Trim();
Textbox2.Text=dr["a2"].ToString().Trim();
}
cm.Connection.Close();