Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: WPF Silverlight NET
how to read a .csv file and store into sql database?
thanks
Posted 7-Nov-11 21:37pm
Comments
Member 8382015 at 8-Nov-11 2:41am
   
file is ";" delimited..
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

  Permalink  
Comments
Mehdi Gholam at 8-Nov-11 2:53am
   
5'ed
André Kraak at 8-Nov-11 3:15am
   
Thanks.
Member 8382015 at 8-Nov-11 3:09am
   
please post code behind for console application..
thanks
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

  Permalink  
Comments
Member 8382015 at 8-Nov-11 3:09am
   
please post code behind for console application..
thanks
Mehdi Gholam at 8-Nov-11 3:55am
   
What do you mean?
Member 8382015 at 8-Nov-11 4:50am
   
i have to create a console application for it....so is there any dll that can help me??
thanks
André Kraak at 8-Nov-11 3:15am
   
My 5
Mehdi Gholam at 8-Nov-11 3:54am
   
Cheers
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

using System.IO;
..
 
List<string[]> parsedData = new List<string[]>();
string path = ConfigurationManager.AppSettings["FullPath"];  //Path of folder of .csv file
string filename = "myCsv.csv";  //  Name of .csv file you want to  process
string fullpath = path + filename;                
                
using (StreamReader readFile = new StreamReader(fullpath))
{
  string line;
  string[] row;
  while ((line = readFile.ReadLine()) != null)
  {
    row = line.Split(';');
    parsedData.Add(row);
  }
}
 
if(parsedData.Count >= 1)
{
  DataClasses1DataContext _db = new DataClasses1DataContext();  //LinqToSql object
  temp_table wm = new temp_table();
  wm.FileName = filename;
  _db.wms.InsertOnSubmit(wm);
  _db.SubmitChanges();
 
  for (int counter = 1; counter <= parsedData.Count; counter++)
  {
    temp_detail_table wd = new temp_detail_table();
    wd.col1= (parsedData[counter][1];
    wd.col2= (parsedData[counter][2];
    ..
    _db.wds.InsertOnSubmit(wd);
    _db.SubmitChanges();
  }
}
  Permalink  
v6
Comments
dev.pratik at 23-Nov-11 1:59am
   
for getting files from directory see :
http://www.csharp-examples.net/get-files-from-directory/

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

  Print Answers RSS
0 George Jonsson 175
1 Kornfeld Eliyahu Peter 169
2 Zoltán Zörgő 139
3 PIEBALDconsult 130
4 OriginalGriff 120
0 OriginalGriff 6,165
1 DamithSL 4,658
2 Maciej Los 4,107
3 Kornfeld Eliyahu Peter 3,649
4 Sergey Alexandrovich Kryukov 3,342


Advertise | Privacy | Mobile
Web04 | 2.8.141220.1 | Last Updated 7 Nov 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