Dear,
The above solution(by @Chill60) will solve your question. So follow the steps what he suggest.
--------------
If there will be more data in gridview then, for every row it will call the stored procedure which may cause of performance issue.
From the below link you can get the idea how you can pass whole grdview data to the stored procedure in one go with out calling stored procedure for each row.
Sending a DataTable to a Stored Procedure[
^]
Passing a datatable to a Stored Procedure in SQL Server 2008[
^]
Refer these link it may give ideas.