Databases
StackOverflow2013
Postsdbo
POGrouped Gridview With Expandable Groups
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POGrouped Gridview With Expandable Groups
    primarykey
    data
    text
    <p>There are a number of questions around the topic of nesting gridviews or having sub-gridviews. I have considered this approach but it is too much for my purposes. The closest existing question I could find was this one: <a href="https://stackoverflow.com/questions/1804282/grouped-gridview">Grouped Gridview</a></p> <p>Unfortunately although this has some advice for how to create grouping rows it doesn't go into making them collapsible.</p> <p>My requirement is that I wish the user to see the gridview with separating rows e.g.</p> <blockquote> <p><strong>- GROUP 1</strong><br /> Data 1 | Data 2 | Data 3<br /> Data 1 | Data 2 | Data 3<br /> Data 1 | Data 2 | Data 3<br /> <strong>- GROUP 2</strong><br /> Data 1 | Data 2 | Data 3<br /> Data 1 | Data 2 | Data 3<br /> <strong>- GROUP 3</strong><br /> Data 1 | Data 2 | Data 3<br /> Data 1 | Data 2 | Data 3<br /> Data 1 | Data 2 | Data 3<br /> Data 1 | Data 2 | Data 3<br /></p> </blockquote> <p>So that a user could, if they wished view like this:</p> <blockquote> <p><strong>+ GROUP 1</strong><br /> <strong>- GROUP 2</strong><br /> Data 1 | Data 2 | Data 3<br /> Data 1 | Data 2 | Data 3<br /> <strong>- GROUP 3</strong><br /> Data 1 | Data 2 | Data 3<br /> Data 1 | Data 2 | Data 3<br /> Data 1 | Data 2 | Data 3<br /> Data 1 | Data 2 | Data 3<br /></p> </blockquote> <p>Or this:</p> <blockquote> <p><strong>+ GROUP 1</strong><br /> <strong>+ GROUP 2</strong><br /> <strong>+ GROUP 3</strong><br /></p> </blockquote> <p>Essentially all the grouping rows have in them is the title of the group. They're not even really proper Gridview rows. The actual rows are the gridview proper and don't neeed any further drill down capability.</p> <p>I would like my solution to be workable clientside, I have constraints which are that I can use javascript or jQuery (including jQuery-ui 1.8.8) but cannot arbitrarily expand the number of AJAX toolkits I'm using. I would prefer not to have to manage the state of the page constantly through multiple group expanding postbacks.</p> <p>Is this something that can be achieved? Could anyone point me in the direction of a resource which might give me a nudge?</p> <p>EDIT: Oh, yes, and I forgot to mention. The rows of the base gridview occasionally have controls in them including, but potentially not limited to: buttons, textboxes, checkboxes and dropdowns.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USOne Monkey
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POGrouped Gridview With Expandable Groups
      1. USIcarus
      1. VTFavorite
    2. VO
      singulars
      1. POGrouped Gridview With Expandable Groups
      1. USsantosh singh
      1. VTFavorite
    3. VO
      singulars
      1. POGrouped Gridview With Expandable Groups
      1. USDidier Ghys
      1. VTFavorite
    1. COIf you willing to use 3rd party component, it will be a easy task. Anyway, also have a look at jQuery DataTables which might have something similar
      singulars
      1. POGrouped Gridview With Expandable Groups
      1. UShuMpty duMpty
    2. COI'm willing, but not able. It's not an app I have the control to dump new 3rd party stuff into.
      singulars
      1. POGrouped Gridview With Expandable Groups
      1. USOne Monkey
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload