当datatable包含逗号时，在csv中导出时出现问题

问题描述

专家，

我是Uday Satardekar.

我正在从数据库中获取记录并将其存储为CSV格式.

以下是我的CSV方法，正在将数据表传递给它.

Hi Expert,

I am Uday Satardekar.

I am fetching records from database and storing it into CSV Format.

Following is my CSV Method and I am passing datatable to it.

public void CreateCSVFile(DataTable dt, string strFilePath)
       {

           StreamWriter sw = new StreamWriter(strFilePath, false);

           int iColCount = dt.Columns.Count;
           for (int i = 0; i < iColCount; i++)
           {
               sw.Write(dt.Columns[i]);
               if (i < iColCount - 1)
               {
                   sw.Write(",");
               }
           }

           sw.Write(sw.NewLine);

           foreach (DataRow dr in dt.Rows)
           {
               for (int i = 0; i < iColCount; i++)
               {
                   if (!Convert.IsDBNull(dr[i]))
                   {
                       sw.Write(dr[i].ToString());
                   }

                   if (i < iColCount - 1)
                   {
                       sw.Write(",");
                   }
               }
               sw.Write(sw.NewLine);
           }
           sw.Close();
           MessageBox.Show("Exporting Completed");

       }

   }

以上对我来说很好.

但是，假设我的数据表结果中有逗号，则此函数也包含该逗号.

我的数据表中有公司，contact_person之类的字段，其中可能包含逗号.然后上面的功能也包含该逗号.

请帮助我如何跳过该逗号.

在此先感谢.......

And Above working fine for me.

But suppose if there is comma in any my datatable result then this function include that comma also.

In my datatable there are company,contact_person like field which may contains comma. Then above function include that comma also.

Please help me how to skip that comma.

Thanks in advance................

推荐答案

using(var fileReader = New TextFieldParser("C:\ParserText.txt"))
{
   fileReader.TextFieldType = FieldType.Delimited;
   fileReader.SetDelimiters(",");
...
}

这篇关于当datatable包含逗号时，在csv中导出时出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！