Radgrid VS Gridview - Compare SQL Queries

I ran the same code for RadGrid and Gridview and the result is the same for both. However, when I look at the SQL profiler, I see that RadGrid is calling the query 3 times. On the other hand, the Gridview only calls it once. I'm wondering why. I have looked at many sources but couldn't find anything. If you guys don't know why this is, please let me know - see the attached file for a screenshot of the code and SQL Profiler.

http://tinypic.com/r/116ul39/6

+3


source to share


1 answer


I think I have found the reason that is causing this plural class. When I use RadGrid it does this

  • It calls all data to display the field
  • He calls him again to find out the amount of swap, then
  • He calls him again for filtering and such


on the other hand, when I use the GridView and pass the datasource, I can make one DB call to get the same result.

Greetings,

0


source







All Articles