Insert Data from Gridview to DB

Question

0.00/5 (No votes)

See more:

Dear Friends,

I have doubt. Kindly guide me on this.

I have few records in Gridview and I want it to insert to DB.
Now weather I can directly insert from Gridview or Shall I convert to XML format and then I can insert to DB.
Which way is correct?

The Gridview has more than 200 rows.

Posted 18-Feb-13 4:46am

Arunprasath Natarajan

Add a Solution

Comments

ZurdoDev 18-Feb-13 10:57am

How did the data get into the gridview? Is it not already in the database?

Muthuraja Irullandi 18-Feb-13 11:15am

Hi,
Bind the datatable into the grid, so that the datatable will have all you records. Then you can read the data from datatable and insert into database.

2 solutions

Solution 1

Are these articles helpful:
MSDN: GridView Examples for ASP.NET 2.0: Editing the Underlying Data in a GridView[^]
Select, Update, and Delete Data in a ASP.NET GridView Control.[^]

Try out. Post specific issue if you face any.

Posted 18-Feb-13 5:41am

Sandeep Mewara

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)

Khorshed Alam, Dhaka · Accepted Answer · 2013-02-20T00:25:00

1. If you have only 200 rows and there is less possibility to increase the number of rows in future then you can loop through the data-grid view and make INSERT statements in a string variable at a time and execute the statements using sqlCommand object.

2. If you need to insert large volume of data then I prefer to prepare a DataTable using the data of the grid-view and use SqlBulkCopy to load the rows to database.