Last post Jun 05, 2018 09:33 AM by Abraham Qian
Jun 04, 2018 04:34 AM|JagjitSingh|LINK
How to create Matrix Type Grid in Visual Studio 2008
Employee Location L1 Location L2 Location L3 Location L4
Jun 05, 2018 09:33 AM|Abraham Qian|LINK
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.
Please feel free to let me know if you still have any question.