This article will help you to insert bulk data insertion into database using OPENXML.
Here, I will bind static data to a grid view for a demo but you may bind data to a grid view dynamically.Step 1: The Table
Create the table as in the following:
Step 2: Stored Procedure
Create the Stored Procedure as in the following:
Step 3: UI Design
Create the UI Design as in the following:
Check that the UI design looks as in the following:Step 4: Code Behind
Create the Code Behind as in the following:
Diving Into ASP.NET WebAPI