C# 查询ACCESS问题

显示全部楼层 · 2008-5-24 02:04:29

str = "SELECT [number] FROM [store]"; OleDbCommand MyComm3 = new OleDbCommand(str, MyConn); OleDbDataReader dr = MyComm3.ExecuteReader();int i = 0;int k = 0;while(dr.Read()){
i = dr["number"];//将"number"列的值给i;
if(k < i)
//当K<i的时候，进行交换，将大的值给k;
{
k = i;
}}//经过冒泡，得到的K值为最大的int a = k;//注意number列的类型，如果不为整型还需转换写完之后想到的，为此再补充上些也可以在SQL语句中进行比较，str = "SELECT [number] FROM [store] order by [number]"; OleDbCommand MyComm3 = new OleDbCommand(str, MyConn); OleDbDataReader dr = MyComm3.ExecuteReader(); while(dr.Read()) { int a = dr["number"];return;}

千问 · 2008-5-24 02:04:29

搞个datatable d = new datatable();把取到的值放到datatable里面.然后.int i=int.Parse(d.rows[0]["number"]);

千问 · 2008-5-24 02:04:29

其他方式参考：str = "SELECT MAX(number) FROM store"; OleDbCommand MyComm3 = new OleDbCommand(str, MyConn); int a;object b=MyComm3.ExecuteScalar();if(b!=null){a=(int) a;}