Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#4.0
How can i store datagridview data into sql table at run time.(c# in window application)
Note:
Table will be created automatically at run time in sql.
 
Thanks in Advance
Posted 17-Feb-13 22:22pm
Rekhash1.5K

1 solution

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

Solution 1

Hi,
 
check the below article.
Sending a DataTable to a Stored Procedure[^]
 
So, using this, you can pass the datasource of the gridview to strored procedure and that would create the table and insert the rows from the datatable to sql table.
 
hope it helps.
  Permalink  
Comments
Rekhash at 18-Feb-13 5:09am
   
Place a button "Export to SQL" when use clicks on this button the entire XML data should get stored in an database by creating new table and inserting values at runtime. @Karthik Harve

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

  Print Answers RSS
0 Schatak 394
1 OriginalGriff 300
2 Abhijit Ghosh (Subho) 125
3 Andreas Gieriet 120
4 _Amy 115
0 OriginalGriff 7,137
1 Sergey Alexandrovich Kryukov 5,628
2 Maciej Los 3,529
3 Peter Leow 3,373
4 DamithSL 2,505


Advertise | Privacy | Mobile
Web02 | 2.8.140721.1 | Last Updated 18 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