Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: ASP.NET XML SQL-Server
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
Comments
ryanb31 at 18-Feb-13 10:57am
   
How did the data get into the gridview? Is it not already in the database?
Muthuraja Irullandi at 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.
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

  Permalink  
Rate this: bad
good
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.
  Permalink  

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 718
1 OriginalGriff 420
2 CPallini 385
3 George Jonsson 231
4 Richard Deeming 145
0 OriginalGriff 5,450
1 CPallini 4,500
2 Sergey Alexandrovich Kryukov 4,272
3 George Jonsson 3,057
4 Gihan Liyanage 2,445


Advertise | Privacy | Mobile
Web02 | 2.8.140916.1 | Last Updated 20 Feb 2013
Copyright © CodeProject, 1999-2014
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