Click here to Skip to main content
11,706,728 members (31,932 online)
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 20: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 OriginalGriff 146
1 Sergey Alexandrovich Kryukov 140
2 chainerlt 110
3 Mika Wendelius 80
4 ppolymorphe 71
0 OriginalGriff 9,190
1 Sergey Alexandrovich Kryukov 8,407
2 CPallini 5,189
3 Maciej Los 4,756
4 Mika Wendelius 3,686


Advertise | Privacy | Mobile
Web02 | 2.8.150819.1 | Last Updated 7 Nov 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