Saving all data in gridview to sql database @ once

Hey,

Which technology are you targeting MVC or Web Forms?

Basically, we can have simple logic for inserting all data at a time

#1 we can create customized XML and can pass it to database side and in database, we can insert all data with single insert query

#2 We can create custom data type in database with table value from front end we can pass LIst or Datatable and in database, we can insert all data with single Insert query

If you are using MVC and Entity Framework then, please refer this solution:

http://programmingzest.blogspot.in/2017/07/access-stored-procedure-with-user.html

Hope this will help you and fulfill your requirements