Okay, I am using VS .NET 2005 and SQL Server 2005. I need to build either a winform or an .aspx page that will hold an updateable gridview. My problem is I have to Crosstab my underlying table to make the data readable for the end user. Can I bind the gridview that is crosstabbed from a stored procedure and allow the user to update that gridview but write the data back in the original table. Here is what my original table looks like:

RCount DT DOUNum Stmt Score
1 10/18/2008 14255 3917 5
1 10/18/2008 14255 3922 4
1 10/18/2008 14255 3924 5
2 10/19/2008 898 3917 5
2 10/19/2008 898 3922 4
2 10/19/2008 898 3924 5
3 10/20/2008 16723 3917 5
3 10/20/2008 16723 3922 3
3 10/20/2008 16723 3924 3

This is what the crosstab gridview looks like:

RCount DT DOUNum 3917 3922 3924
1 10/18/2008 14255 5 4 5
2 10/19/2008 898 5 4 5
3 10/20/2008 16723 5 3 3

RCount, DT and DOUNum fields are static. The values in the Stmt field are always different. This is survey data so the survey questions are different and could be in a different order for another survey.