Hi, I got huge problem with trasformining rows from one table in DataBase into Colums in program(dataset). To make my self clear, I will illustrate situation on example:
First table:
File_ID fild_type_ID value
00001 1 Peter
00001 3 M
00002 1 Jane
00002 3 F
….
Result table:

name sex …
Peter M
Jane F
….

I was traing to do many dataadapters and join into one dataset, but i couldn't, because error occured: "Can't create multiple table set with contains tables with same name"! I can't change structure of database!!

Please help!!

PS I use VS .NET 2003 and Ms SQL Server 2000