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 OriginalGriff 293
1 Sergey Alexandrovich Kryukov 281
2 RyanDev 65
3 nv3 60
4 Mehdi Gholam 45
0 Sergey Alexandrovich Kryukov 6,696
1 OriginalGriff 6,149
2 CPallini 2,473
3 Richard MacCutchan 1,697
4 Abhinav S 1,560


Advertise | Privacy | Mobile
Web01 | 2.8.140821.2 | 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