ASP.NET Gridview: How to Display Results from One Stored Procedure and Call Another Stored Procedure to Insert Data?

I have an ASP.NET 4.0 application that handles survey responses. I want to dynamic开发者_开发知识库ally serve the survey questions in a gridview control, and use the same gridview to permit the user to record their response. Responses are saved in a separate table from the questions.

In essence, the gridview needs to pull the questions from one stored procedure and insert the responses entered in the gridview using another stored procedure. How can this be accomplished?

you didnt write how you are accesing database, is that any datasource control, linq ? i assume you would like to edit multiple rows, and then update the survey with one button

here you will find an answer