I am trying to loop through a gridview and insert the selected value of a dropdown list and textbox from each row into another table. I was finally able to get the insert statment to work but it only inserts the value from the last row in the GridView.

Here is the code I am using to pass the values to my insert statment.

Protected Sub Picks_Inserting (ByVal sender As Object, ByVal e As ObjectDataSourc eMethodEventArg s)...