各位大虾：帮忙看一下！

Question

"select count(xh) as x from basic";

Answer 1

strsql="select count(xh) as x from basic";
OleDbCommand objCommand= new OleDbCommand(strsql,myconn)
OleDbDataReader objDataReader=null;
objDataReader=objCommand.ExecuteReader();
x_count=objDataReader["x"];或是：
"select count(xh) as x from basic";
OleDbDataAdapter objCmd = new OleDbDataAdapter(strsql,myconn);
DataSet objDataSet = new DataSet();
objCmd = new OleDbDataAdapter(strsql,myconn);
objCmd.Fill(objDataSet,"MyDataSet");
DataRow myrow=objDataSet.Tables["MyDataSet"].Rows[0];
DataTable objTable=new DataTable();
objTable=objDataSet.Tables["MyDataSet"];
x_count=myrow[objTable.Columns["x"]].ToString();

Answer 2

要读x的值，最简单的用（如果x是int型）
x = (int)objCommand.ExecuteScalar()，就行了

Answer 3

oleDbDataAdapter1.SelectCommand.CommandText="select count(xh) as te from basic";
   OleDbDataReader objDataReader=null;
   oleDbConnection1.Open();
   objDataReader=oleDbDataAdapter1.SelectCommand.ExecuteReader();
           objDataReader.Read();
   Label1.Text=objDataReader.GetInt32(0).ToString();