如何读取这种格式的csv文件数据?

如何读取这种格式的csv文件数据?

问题描述:

这里是我想要阅读的文件,但没有输出来为什么它没有得到任何结果



这里是我的代码:



here is the file which i want to read but no output comes why it is not getting any result

here is my code:

public void ImportAllFilesOfFolder()//function declares methods to import//
       {
           try
           {
               //con.Open();
               string sourceDir = txtsend.Text;
               var IcsvFile = Directory.EnumerateFiles(sourceDir, "*.csv");

               foreach (string currentFile in IcsvFile)
               {
                   StreamReader sr = new StreamReader(@"C:\Users\Send\BED01.csv");
                   string line = sr.ReadLine();
                   string[] value = line.Split(',');
                   DataTable dt = new DataTable();
                   DataRow row;

                   foreach (string dc in value)
                   {
                       dt.Columns.Add(new DataColumn(dc));
                   }

                   while (!sr.EndOfStream)
                   {
                       value = sr.ReadLine().Split(',');
                       if (value.Length == dt.Columns.Count)
                       {
                           row = dt.NewRow();
                           row.ItemArray = value;
                           dt.Rows.Add(row);
                       }
                   }
                   con.Open();
                   SqlBulkCopy bc = new SqlBulkCopy(con.ConnectionString, SqlBulkCopyOptions.TableLock);
                   bc.DestinationTableName = "PatientView";
                   bc.BatchSize = dt.Rows.Count;
                   bc.WriteToServer(dt);
                   bc.Close();
               }
           }

           catch(System.ArithmeticException e)
           {
               MessageBox.Show(e.Message);
           }
           finally { con.Close(); }
       }



这里是csv文件结构:





PTNAME,REGNO / ID,BLOOD GRP,WARD NAME,DOC NAME,XRAY,PATHO,MEDICATION,BLOOD GIVEN

Mr.MISHRA SABHAPRASAD RAMNARESH,SH1312 / 00804 ,, SEMI DELUXE 05,SHELKE SAMEER,X射线左侧髋关节AP / LAT - 接受原位植入,伴有髋臼杯关节改变2 D ECHO-MILD CONC LVH GOOD LV舒缓功能改变LV舒缓功能LVEF 55%MRI脑 - 少数老年人双侧脑白质中的缺血性脑脊髓MRI筛查整个脊柱-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血型组-B RH阳性PT INR-15/15/1 HIV和HBSAG-阴性,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


and here is csv file structure:


PTNAME,REGNO/ID,BLOOD GRP,WARD NAME,DOC NAME,XRAY,PATHO,MEDICATION,BLOOD GIVEN
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

从这里开始:

用C#读取和写入CSV文件 [ ^ ]


这段代码不支持我很难了解cn任何人都给我简单的代码链接
this code not support me it is quite difficult to understand cn anyone give me simple code link