I wrote a query that will return a large amount of records. When I run the query it fill a datatable then show it in a datagridview, but I am only getting 80290 rows. There is more than that. Any idea of what is causing this?


This is not really an answer but some advice, why would you need to display 80000 or more rows in a datagridview, that is too much information. Maybe you need to rethink your design to either fetch the data in blocks or refine the data shown.

Just my two cents