This is a migrated thread and some comments may be shown as answers.

RadGrid and requesting data while using NestedViewTemplate

2 Answers 58 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Chase Florell
Top achievements
Rank 1
Chase Florell asked on 15 Aug 2008, 10:55 PM
Ok so I am wondering about efficency here.

I have a DB with over 60 Fields... I need to be able to view ALL of those fields in the NestedViewTemplate, however I am only displaying 4 (four) of those fields in the actual grid.

Since I need ALL of those records, I am currently binding my grid to a StoredProcedure where I am using "Select *"

My problem is that I don't know how effecient it is going to be when I have to call 10,000 records.

Is there a way to only call the "select * from table where ID = @ID " when the "Details" button is called?

2 Answers, 1 is accepted

Sort by
0
Chase Florell
Top achievements
Rank 1
answered on 16 Aug 2008, 01:05 AM
Also I would like to note that I prefer to not use a DataSource in my ASPX page but rather handle it all in my code behind.
0
Missing User
answered on 19 Aug 2008, 12:41 PM
Hi Chase,

You can use serverondemand load mode for the hierarchy. In ServerOnDemand mode - Roundtrip to the database when grid is bound and when item is expanded. ViewState holds data for only visible Items (smallest possible). Only detail table-views of the expanded items are rendered. Postback to the server to expand an item.


Regards,
Plamen
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Tags
Grid
Asked by
Chase Florell
Top achievements
Rank 1
Answers by
Chase Florell
Top achievements
Rank 1
Missing User
Share this question
or