I have a report which can be viewed by multiple users.To display the report I have taken a datagrid.I am binding the dataset to the datagrid.Now the problem is that dataset has lakhs of records more than 3lakhs.I need to view all the 3lakhs records at one time.So it is taking so much of time render to the datagrid.so wht is the best way to do this.How to handle this type of scenarios?

I have sql query which returns dataset.This dataset will contain lakhs of record.

Thanks
Lily

lily611:
It is difficult to say due to not enough information, need to view your SELECT statement and a definition of "lakhs" record types.



========================
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.