DataTable versus SQLDataReader benefits on Grid
Posted on 2014-02-28
I was told in a previous post to populate a grid with DataTable instead of SQLDataReader.
I just ran a test of 30,000 records in the result set, but a pagesize of 100, and the page load was typically identical in both cases. I ran the test about 10 times for each scenario and they fluctuated within 3 seconds of each other, sometimes winning, sometimes losing. But nothing that would seem to be a clear winner ever.
What are the benefits again?