Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
i want to Accept only .CSV files in front end (in file upload control) and if i click "Upload" button(button control) the uploaded CSV file will be saved in Database as created table with column's atomatically in Database. as

table_name=uploaded file_name
first row of the file= column's of the table in Database automatically.
 

please some one help me in this regard's. give full programming code as i am using Microsoft Visual Studio 2010 and SQL Server 2008.
Posted 2-Oct-12 20:36pm
Comments
DaveAuld at 3-Oct-12 2:42am
   
What have you tried. "Give full programming code" I think not, that is not how it works...

1 solution

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

Solution 1

Hi,
 
Please check into the below link.
 
http://amitpatriwala.wordpress.com/2008/08/27/upload-csv-file-and-read-using-aspnet/[^]
 
Here you just need to add some code to save data into database.
  Permalink  
v3

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

  Print Answers RSS
0 Maciej Los 655
1 OriginalGriff 453
2 CPallini 239
3 CHill60 180
4 Peter Leow 175
0 OriginalGriff 6,092
1 Sergey Alexandrovich Kryukov 4,898
2 Maciej Los 3,159
3 Peter Leow 3,129
4 DamithSL 2,490


Advertise | Privacy | Mobile
Web03 | 2.8.140721.1 | Last Updated 3 Oct 2012
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