＋设为首页 ＋添加到收藏夹
oleDbDataAdapter1.SelectCommand.CommandText="select count(xh) from basic";
我如何把上面取的值“count(xh)”放到一个变量里去！
"select count(xh) as x from basic";
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();
要读x的值，最简单的用
x = (int)objCommand.ExecuteScalar()，就行了
