K Data Grid

How to insert multiple rows of display data grid in C #. NET database at a time or click on a button?

I have a vision of the grid in project.In windows of an application of the grid I can add multiple data in multiple rows.I just want to save multiple lines with lots of data to a single table in the unique identification.

you can use a foreach loop or loops to browse for all lines of your GridView and then insert all the rows in your table you want with a simple SQL Insert statement, even if you can all this for loop within a transaction. I mean, you must define a new transaction and then assign this task to your connection object and then use to start the transaction before taking any action to insert data into database, and after that, when all the process is completed, you can use validation of the transaction to apply these changes to the database or rollback to undo all your actions and database will remain as before …

ASP.NET Grid – Data Sorting Basics