Click here to Skip to main content
13,050,242 members (108,035 online)
Rate this:
Please Sign up or sign in to vote.
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
ryanb31 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
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.
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Rate this: bad
Please Sign up or sign in to vote.

Solution 2

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.

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 20 Feb 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100