Click here to Skip to main content
Search within:



Next

Insert Data from Gridview to DB
Sign Up to vote bad
good
See more: ASP.NETXMLSQL-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:46
Arunprasath Natarajan2.6K
Add a Solution

Comments
ryanb31 - 18 Feb '13 - 10:57
How did the data get into the gridview? Is it not already in the database?
Muthuraja Irullandi - 18 Feb '13 - 11:15
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

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  
Posted 20 Feb '13 - 0:25
Khorshed Alam, Dhaka2.1K
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.
  Permalink  
Posted 18 Feb '13 - 5:41
Sandeep Mewara473K
Add a Solution

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

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Sergey Alexandrovich Kryukov 428
1 OriginalGriff 291
2 Mayur_Panchal 153
3 Mohammed Hameed 145
4 Dave Kreskowiak 125
0 Sergey Alexandrovich Kryukov 8,146
1 OriginalGriff 6,236
2 CPallini 3,482
3 Rohan Leuva 2,703
4 Maciej Los 2,234


Advertise | Privacy | Mobile
Web03 | 2.6.130516.1 | Last Updated 20 Feb 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid