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

Anil Kumar

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.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manikavelu Velayutham15y ago
Accepted 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/0,339028455,339282577,00.htm

it has various examples to demonstrate the usage.
0
Pradeep Chandraker15y ago
@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?
0
Anil Kumar15y ago
Is there any other way for the same?
0
Anil Kumar15y ago
hope to get more details on it.
0
Anil Kumar15y ago
need more detail plz
0
Manikavelu Velayutham15y ago
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/0,339028455,339282577,00.htm

it has various examples to demonstrate the usage.
0