What is the best recommended approach for Bulk Insert/Update in asp.net GridView?

Question

Please tell me the best recommended approach for Bulk Insert/Update in asp.net GridView.

I have a page where I am recording the order details and have grid to get line-of-items. Items are get added to a grid. I want to save this (order header details with many line of items) on clicking save.

Manikavelu Velayutham · Answer

If you work in sql server 2008 you can pass the entire details through the Table Datatype so that you could save the details in single parameter. Front end you will pass the value as datatable. Backend you will accept it as table datatype. http://www.builderau.com.au/program/sqlserver/soa/Passing-table-valued-parameters-in-SQL-Server-2008/033902845533928257700.htm it has various examples to demonstrate the usage.

Pradeep Chandraker · Answer

@Anil You have other option like BulkCopy and passing xml string to stored proc. But the option @Manikavelu suggested is better one. If you have specific question please let me know?

Anil Kumar · Answer

Is there any other way for the same?

Anil Kumar · Answer

hope to get more details on it.

Anil Kumar · Answer

need more detail plz

Manikavelu Velayutham · Answer

If you work in sql server 2008 you can pass the entire details through the Table Datatype so that you could save the details in single parameter. Front end you will pass the value as datatable. Backend you will accept it as table datatype. http://www.builderau.com.au/program/sqlserver/soa/Passing-table-valued-parameters-in-SQL-Server-2008/033902845533928257700.htm it has various examples to demonstrate the usage.