Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#4.0
i want upload only .csv format files in my web page and as soon as i click on Update button it will automatically create table with columns
here
file name= table name and
first row of the file (headings)= columns of the table

how to write the code for it in MS SQL server. .
Posted 1-Oct-12 3:11am

1 solution

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

Solution 1

First you need to know how to execute SQL code.
 
The following describes that how to execute SQL statements from c#.
 
http://msdn.microsoft.com/en-US/library/0k7hxwz6(v=vs.80).aspx[^]
 
Then you need to read in the CSV to get the structure of the file. One such reader is available on CodeProject Smile | :)
 
A Fast CSV Reader[^]
 
Next you need to construct an SQL statement which creates the table. The following explains the CREATE TABLE command is SQL.
 
http://www.w3schools.com/sql/sql_create_table.asp[^]
 
Then you need to execute this command against SQL.
 
Then you need to read the data in with your CSV reader and insert into the new table.
 
The following is information on the INSERT command.
 
http://www.w3schools.com/sql/sql_insert.asp[^]
  Permalink  

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 510
1 CPallini 330
2 OriginalGriff 215
3 George Jonsson 120
4 ChauhanAjay 104
0 OriginalGriff 6,464
1 Sergey Alexandrovich Kryukov 5,915
2 CPallini 5,175
3 George Jonsson 3,559
4 Gihan Liyanage 2,522


Advertise | Privacy | Mobile
Web02 | 2.8.140916.1 | Last Updated 2 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