Hi,
I Have a radgrid with master and detail table.
Each table has sqldatasource populating data from stored procedure.
A note with sqlprofiler that when I expand first time 1 row from master table
the stored procedure that populate details grid is called n times that n is number of rows in master table.
After that everything is OK. When I expand one row, stored procedure is called once. The master and details grid has 1 column with Aggregate="Sum".
My question is how can i prevent this first load time madness?
I Have a radgrid with master and detail table.
Each table has sqldatasource populating data from stored procedure.
A note with sqlprofiler that when I expand first time 1 row from master table
the stored procedure that populate details grid is called n times that n is number of rows in master table.
After that everything is OK. When I expand one row, stored procedure is called once. The master and details grid has 1 column with Aggregate="Sum".
My question is how can i prevent this first load time madness?