locked
Matrix GridView RRS feed

  • Question

  • User-1499457942 posted

    Hi

      How to create Matrix Type Grid in Visual Studio 2008

    Employee     Location L1            Location L2           Location L3         Location L4

     E01                  L1

     E02                                                L2

    Thanks

    Monday, June 4, 2018 4:34 AM

All replies

  • User-330142929 posted

    Hi JagjitSingh,

     

    According to your description, I'd like to give you two possible ways.

    First, I think you could structure your SQL Query to return formatted data. You may need to create a view or temp table with columns called: Location L1,Location L2,Location L3,Location L4, etc.

    The second way is to create a dataset or datatable, Add columns to the table (location L1, location L2,location l3 , etc).  Loop and add rows, one by one.  Then bind the dataset to the grid.

    Here are some links, may be useful to you.

    https://www.codeproject.com/Articles/194742/SQL-PIVOT-Table-Using-OPENXML-Query-in-ASP-NET

    Please feel free to let me know if you still have any question.

     

    Best Regards,

    Abraham

    Tuesday, June 5, 2018 9:33 AM