Click here to Skip to main content
16,010,553 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..

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();
  }
}
 
Share this answer
 
v6
Comments
dev.pratik 23-Nov-11 1:59am    
for getting files from directory see :
http://www.csharp-examples.net/get-files-from-directory/
 
Share this answer
 
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
 
Share this answer
 
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

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