Click here to Skip to main content
14,866,383 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
how to read a .csv file and store into sql database?
thanks
Posted
Comments
dev.pratik 8-Nov-11 2:41am
   
file is ";" delimited..

   
Comments
Mehdi Gholam 8-Nov-11 2:53am
   
5'ed
André Kraak 8-Nov-11 3:15am
   
Thanks.
dev.pratik 8-Nov-11 3:09am
   
please post code behind for console application..
thanks
   
Comments
dev.pratik 8-Nov-11 3:09am
   
please post code behind for console application..
thanks
Mehdi Gholam 8-Nov-11 3:55am
   
What do you mean?
dev.pratik 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 8-Nov-11 3:15am
   
My 5
Mehdi Gholam 8-Nov-11 3:54am
   
Cheers
C#
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();
  }
}
   
v6
Comments
dev.pratik 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)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900