How can i insert multiple records of Gridview to database in Batch

Question

0.00/5 (No votes)

See more:

hi,

i have gridview contains 10 records and one button name save when i click on save button all five records must be save in database at a time means batch mode.

please give me a solution.

Posted 29-Mar-12 1:50am

Madhugundi

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Thilina Chandima · Answer 1 · 2012-03-29T02:02:00

Solution 1

you can loop through grid view recodes and call insert quarry inside the loop.

you can use foreach loop like this

C#

foreach (DataGridViewRow row  in dataGridView1.Rows)
{
    //do your insert inside this block.
}

Posted 29-Mar-12 2:02am

Thilina Chandima

Updated 29-Mar-12 2:06am

v2

Peace ON · Answer 2 · 2012-03-29T02:04:00

Solution 2

An efficient way to do batch insert is prepare xml from datagrid and then pass xml to stored procedure. Extract data from xml into stored procedure and insert data to database from stored procedure itself.

Hope this help!

Posted 29-Mar-12 2:04am

Peace ON

Comments

Madhugundi 29-Mar-12 8:11am

plz give me one example

Madhugundi 31-Mar-12 5:08am

give me one example

How can i insert multiple records of Gridview to database in Batch

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

How can i insert multiple records of Gridview to database in Batch

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us