By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,950 Members | 1,005 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,950 IT Pros & Developers. It's quick & easy.

How to read csv file containing many special characters?

P: 2
here is the csv file::::::

Expand|Select|Wrap|Line Numbers
  1. PTNAME,REGNO/ID,BLOOD GRP,WARD NAME,DOC NAME,XRAY,PATHO,MEDICATION,BLOOD GIVEN
  2. Mr.MISHRA SABHAPRASAD RAMNARESH,SH1312/00804,,SEMI DELUXE 05,SHELKE SAMEER,"X RAY LEFT HIP WITH THIGH AP/LAT --ACCEPTABLE WITH IMPLANT IN SITU WITH ACETABULAR CUP ARTHRITIC CHANGES 2 D ECHO-MILD CONC LVH GOOD LV DIASTOLIC FUNCTION ALTERED LV DIASTOLIC FUNCTION LVEF 55 % MRI BRAIN- FEW OLD ISCHEMIC CHNGES IN BILATERAL CEREBRAL WHITE MATTER MRI L-S SPINE WITH SCREENING OF WHOLE SPINE- PID-L3-4,L5-S1 PID C3- 4TO C6-7 ",HB- 11.4 BSL -206.4 SR CREAT-1.7 T3-0.74 T4-11.0 TSH-1.79 SR UREA-23 BLOOD GROUP- B RH POSITIVE PT INR-15/15/1 HIV AND HBSAG - NEGATIVE, IV DICLOGESIC RR DRIP 1-0-1 TAB TACIL 1-0-1 TAB ARCOPAN D 1-0-1 CAP GEMCAL PLUS 1 -0-1 TAB ANXIT 0.5 MG 0-0-1 ARCIZEN GEL LA 1-1-1-1 ,I POINT PCV GIVEN ON 6/4/2015 B RH POSITIVE
in this file from PTNAME to BLOOD GIVEN is headers and file is in proper format. i want to read this file and save in sql server database table. my simple import method doesnt work for this file i need to add some lines in my code bt im confused how to do that .

here is my simple import method if anyone can just edit my method and write code to read and save data in table.

Expand|Select|Wrap|Line Numbers
  1. public void ImportAllFilesOfFolder()//function declares methods to import//
  2. {
  3. try
  4. {
  5. SqlConnection=new SqlConnection(Properties.Settings.Default.HospitalProjectConnectionString);
  6. con.Open();
  7. string sourceDir = txtsend.Text;
  8. var IcsvFile = Directory.EnumerateFiles(sourceDir, "*.csv");
  9.  
  10. foreach (string currentFile in IcsvFile)
  11. {
  12. StreamReader sr = new StreamReader(currentFile);
  13. string line = sr.ReadLine();
  14. string[] value = line.Split(',');
  15. DataTable dt = new DataTable();
  16. DataRow row;
  17.  
  18. foreach (string dc in value)
  19. {
  20. dt.Columns.Add(new DataColumn(dc));
  21. }
  22.  
  23. while (!sr.EndOfStream)
  24. {
  25. value = sr.ReadLine().Split(',');
  26. if (value.Length == dt.Columns.Count)
  27. {
  28. row = dt.NewRow();
  29. row.ItemArray = value;
  30. dt.Rows.Add(row);
  31. }
  32. }
  33.  
  34. SqlBulkCopy bc = new SqlBulkCopy(con.ConnectionString, SqlBulkCopyOptions.TableLock);
  35. bc.DestinationTableName = "New";
  36. bc.BatchSize = dt.Rows.Count;
  37. bc.WriteToServer(dt);
  38. bc.Close();
  39. }
  40. }
  41.  
  42. catch
  43. {
  44.  
  45. }
  46. finally { con.Close(); }
  47. }
Apr 21 '15 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.