Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
180
Switching multilpe bands
posted

Hi there, we have a requirement where our grid is showing multiple bands -- lets say customer is one band and items ordered is another.  Now, can I swap it programmatically so that I can see which customers have ordered a given product. 

 An example would be to go from :

customer_1
   product_1
   product_2
customer_2
   product_2
   product_3

TO


product_1
   customer_1
product_2
   customer_1
   customer_2
product_3
   customer_3

 

  • 3707
    posted

    I'm taking a stab at this one without testing first, but here's my idea.

    1. Edit the dataset and give each of those tables a relationship to the other (I'm assuming one exists). By doing this you can be sure no matter what table is binded to the grid the child band will always be other table.
    2. To programmatically flip the two just change the datasource or datamember value of the WinGrid and rebind in some event of a button or menu.

    Does something like that work for you?