Saving all data in gridview to sql database @ once

Question

Hi Guys Am Designing a Project(Online BookShop) have designed the shopping cart with gridview which is working fine for the user but don't know how to save all product selected by he user so that admin can see it. Thanks Programmer!

Mitesh Gadhiya · Answer

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