Currently I am using a repeater control with paging that I implemented myself. Because the result set can be somewhat large and I'm storing the entire result in view state, the paging is going extremely slow.
My basic need is a control that displays records in the format below, but also has some kind of paging. I have thought about the datagrid but I don't know if this is within its ability.
Col 1 | Col 2 | Col 3
data data data
Message data that spans all columns
Field data that spans all columns
Value data that spans all columns
I have this effect achieved with the Repeater, but as I said, it's slow. The important factors in this scenerio are that the four rows displayed above represent a single record from the database. Another factor is that, there are some cases where I don't want the Message, Field, and Value rows to be displayed at all, but rather I want them to be hidden.
I would prefer to use the datagrid because it has its own paging; however, I haven't seen any examples for something like this with the datagrid.
My current plan is to shift from storing things in viewstate to the session so the server can handle it and I'll just have to force the session to clear manually.
I'm out of idea's here and anything any of you can think of will really help. Thanks!