Counting records of a subquery result 1

[ayanroy]

Hi all,

I have a search query which joins two tables to return a set of records. I am displaying the records in a Paged DataGrid . I want to show the total number of records returned in that query.

I am using DataGrid.Items.Count , but that is returning the no. of records in the current page.

Please help me out..



Ayan Kumar Roy
India

 

[RTomes]

Don't you bind this somewhere in your code? Go to that spot and get the rows count.
Options:

table1.rows.count
dtagrid1.datasource=table1

dataview1.table.rows.count
dtagrid1.datasource=dataview1

Or

ctype(DataGrid.DataSource,datatable).rows.count
ctype(DataGrid.DataSource,dataview).table.rows.count