Hi, I've a database table contains survey questions and answers. But the problem is both 'question' and 'answer' are saved in the same column(like below).
2010-02-15 14:53:59.657 ***What's your pet's name?*** Lili ***Tell us about yourself*** I'm a teacher
2010-02-15 14:53:59.657 ***What's your pet's name?*** Lucy ***Tell us about yourself*** I'm a five star cook
I'd like to use a simple datagrid to display the survey result, but I need to separate the submission column into multiple columns ('question' as column name, 'answer' as data)
the number of questions or questions being asked are different for each survey so they are not fixed.
Is it even possible to get something like this below in a gridview?
View Complete Post