datagrid count

[arno]

Hello,

With a datagrid (asp.net 2), how do I do to have a query's total.
When I use GridView1.rows.count, I had the total for a page but not for all
pages.
(I don't wish to use a second query : "select count(*) from ...)"

Thanks by advance

arno

 

[Grant Merwitz]

Not certain about in 2.0

But you could either check in the datasource your binding to the drig

so if:
GridView1.DataSource = MyDataTable;

you could check
MyDataTable.Rows.Count

Alternately, the other way you could take it out of the datasource

int MyCount = ((DataTable)GridView1.DataSource).Rows.Count;
or
int MyCount = ((DataSet)GridView1.DataSource).Tables[0].Rows.Count;


HTH

 

[arno]

Not certain about in 2.0

But you could either check in the datasource your binding to the drig

so if:
GridView1.DataSource = MyDataTable;

you could check
MyDataTable.Rows.Count

Alternately, the other way you could take it out of the datasource

int MyCount = ((DataTable)GridView1.DataSource).Rows.Count;
or
int MyCount = ((DataSet)GridView1.DataSource).Tables[0].Rows.Count;


HTH

Hello,

With a datagrid (asp.net 2), how do I do to have a query's total.
When I use GridView1.rows.count, I had the total for a page but not for
all pages.
(I don't wish to use a second query : "select count(*) from ...)"

Thanks by advance

arno

It isn't ok in asp.net 2.

have you an another solution ?