datagridview matrix

[hobgoblinvasya]

Hi all,

here i am again asking for you assistance. what im trying to acheive is a datagriview that behaves like a matrix.

ie. i have the following table

ProductName, ProductRegion, ProductType
Test1, RegionTest1, TypeTest1
Test2, RegionTest1, TypeTest2
Test3, RegionTest1, TypeTest3
Test4, RegionTest2, TypeTest1
Test5, RegionTest2, TypeTest2

what i need in output is something like the following:

<...........> RegionTest1 RegionTest2
TypeTest1 Test1 Test4
TypeTest2 Test2 Test5
TypeTest3 Test3

thanks !

p.s. i would also need to be able to save it back to the database

 

[hobgoblinvasya]

guys am i asking something very complex or is it simply impossible to achieve? this is the 2nd thread in a row that i have ZERO replies to