How to get the total number of queried records?

[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.

[Marina]

Just see how many rows are in your datatable.

"Quentin Huo" <q.***@manyworlds.com> wrote in message
news:u3**************@tk2msftngp13.phx.gbl...

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.

[Curt_C [MVP]]

Rows.Count

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Quentin Huo" <q.***@manyworlds.com> wrote in message
news:u3**************@tk2msftngp13.phx.gbl...

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.

[Quentin Huo]

Hi, thanks

using row.count doesn't work!

if there may be100 records retrieved from the sql script, but there are 20
records, for example only the records from 10th to 29th are Filled into the
table of the DataSet by

myAdapter.Fill( ds , 10, 20, "tVisitors");

so rows.count will only return 20, but not 100.

Q.
"Marina" <so*****@nospam.com> wrote in message
news:um**************@TK2MSFTNGP11.phx.gbl...

Just see how many rows are in your datatable.

"Quentin Huo" <q.***@manyworlds.com> wrote in message
news:u3**************@tk2msftngp13.phx.gbl...

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.

[Marina]

Then you're pretty much stuck with doing a count(*), as far as i know.

"Quentin Huo" <q.***@manyworlds.com> wrote in message
news:u1**************@TK2MSFTNGP12.phx.gbl...

Hi, thanks

using row.count doesn't work!

if there may be100 records retrieved from the sql script, but there are 20
records, for example only the records from 10th to 29th are Filled into the table of the DataSet by

myAdapter.Fill( ds , 10, 20, "tVisitors");

so rows.count will only return 20, but not 100.

Q.
"Marina" <so*****@nospam.com> wrote in message
news:um**************@TK2MSFTNGP11.phx.gbl...

Just see how many rows are in your datatable.

"Quentin Huo" <q.***@manyworlds.com> wrote in message
news:u3**************@tk2msftngp13.phx.gbl...

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.

[Matt Hamilton]

I would populate the entire dataset, then use the default veiw to filter
rows. Then you can use rows.count and get the best of both worlds.

"Quentin Huo" wrote:

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.