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

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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