Q
Quentin Huo
Hi:
I want to retrieve a set of records from the query like:
"SELECT * FROM tVisitors WHERE vTime>'1/1/2004'"
And then I will put a part of records into a DataSet by:
DataSet ds = new DataSet();
myAdapter.Fill( ds , startrecordnumber , pagesize , "tVisitors");
But I still need the total number to do something else, I don't think it's a
good idea to query again like:
Select Count(*) from tVisitor where vTime>'1/1/2004'
But any better idea?
Thanks
Q.
I want to retrieve a set of records from the query like:
"SELECT * FROM tVisitors WHERE vTime>'1/1/2004'"
And then I will put a part of records into a DataSet by:
DataSet ds = new DataSet();
myAdapter.Fill( ds , startrecordnumber , pagesize , "tVisitors");
But I still need the total number to do something else, I don't think it's a
good idea to query again like:
Select Count(*) from tVisitor where vTime>'1/1/2004'
But any better idea?
Thanks
Q.