Is anyone can tell me how many records can be displayed in one page? Without time-out or out-of-memory.
That's impossible to say, since it's completely dependent on your webserver. I generally like to hold my grids to no more than 100 rows by 10 columns, unless you're going to use Paging or Virtual Scrolling.
I've done some tests with the WebDataGrid bound to a sql table with 1,000,000, using a page size of 50 records and 30 columns, and the performance was spectacular (<1 second response on local machine). Your best bet is to fill it with the data you're expecting to use and perform some tests (you can use the Visual Studio 2008 Load Tests) to see how much data your server can handle.
Hope this helps,
-Tony
Hi Tony! First of all, sory by my english.
Do you have some examples of this case, when you say that load 1,000,000 using page size of 50 records and 30 columns, because with can't have that performance.
thanks for all.
Sebastian