How to call an update SQL Stored procedure from aspButton click and without postbacks
Posted on 2013-02-06
i have a asp grid view in my webForm and in it I have a ItemTemplate of a checkBox.
if user select lets say Row 1, 6, 7 and 10. then presses a asp:button (that is not in the grid, its rght up front of it) I need to call a UPDATE SQL stored proc but my problem is I know the OnClick will do a postback and all my dropDown in my webForm will reset and user will need to get back to values he wanted.
actually, those dropdowns are search options and when click search, it populates the grid based on down selectedValues you know.
how can I do? or maybe I need to save all selcetedvalues somewhere then do the onClick with a postback and call another function that refill everyhing?
I dont know im lost.. any ideas with examples?