How to Save All Row values of a gridview at single click in ASP [Resolved]

Posted by Pallubhosale under ASP.NET on 12/17/2014 | Points: 10 | Views : 1317 | Status : [Member] | Replies : 2
In a gridview i have two columns PersonID, SuprviserID.
In SupervisorID coloumn Have drop down for selecting supervisor.
How I can save superviserId for all PersonID in just one save button click outside gridView.

Pallavi


Responses

Posted by: vishalneeraj-24503 on: 12/23/2014 [Member] [MVP] Platinum | Points: 50

Up
0
Down

Resolved
Yes you can use Sql Bulk Copy Sql Server in-build functionality.
For More info:-
http://www.codeproject.com/Articles/16922/SQL-Bulk-Copy-with-C-Net
https://www.youtube.com/watch?v=cG4IR7ah08E
http://www.dotnetcurry.com/showarticle.aspx?ID=323

Pallubhosale, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Khargesh on: 12/18/2014 [Member] Starter | Points: 25

Up
0
Down
use sqlbulk insert

khargesh

Pallubhosale, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response