Posted on: 5/27/2013 8:59:35 PM | Views : 324

Hello everyone,
I need some guidence. I have 3 tables; table one is filled with a personName (varchar), and a personID (uniqueidentifier); table two has two columns: TrainingName and LevelNeeded. In my 3rd table I have a 4 colums: personID (uniqueidentifier), TrainingName (varchar), CurrentLevel (int) and LevelNeeded (int). I need to display in a gridview, or in a table something like a matrix. Based on a query, I get a list of names. For those names I need to create a table to look like this:
Person Name | Training 1 | Training 2 | ... | Training n xxxxxxxx         |              x |                | ... | x             |
I don't need to display all the existing training, only the trainings that applies to the selected names. My first attempt was to create a DataTable with only one column called "Name". Then in ...

Go to the complete details ...