Click here to Skip to main content
11,629,614 members (81,561 online)
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


Advertise | Privacy | Mobile
Web03 | 2.8.150723.1 | Last Updated 3 Oct 2012
Copyright © CodeProject, 1999-2015
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