Forums Ultimate UI for Windows Forms
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
Close
Armando Falcon
80
Create Grid with Date Captions
posted

Hello,

I have a question which I am sure someone can tell me which way to go.   I have a table that has records with three columns which are name, date and value.  I would like to have my grid grab all the unique dates in my database and make them column captions and grab the unique names in my database and make them row captions then place the value in the appropriate row and column.  here is an example;

name 1/2/2008 1/3/2008 1/4/2008 1/5/2008 1/6/2008 1/7/2008
tom 5 3 9 4 5 0
john 7 8 6 1 2 3
marry 21 0 5 0 6 22
frank 6 4 4 5 6 7
 

Any help will be GREATLY appreciated!

Andrew

  • 920
    Offline posted

    I do not think that this is an Infragistics Grid issue.  It is a SQL Database pivot table query.  If you can construct the pivot query to get the results, then assign that result set as the DataSource to the grid.

     

    Norm