WriteToCSVFile

using System;
using System.Data;
using System.IO;
using System.Text;

namespace WDC_Portal.Components.Common
{
 /// <summary>
 /// CSVHelper 的摘要说明。
 /// </summary>
 public class CSVHelper
 {
  public CSVHelper(){}

  #region public static void WriteToExcel( System.Data.DataTable dataTable, string excelFileName )
  /// <summary>
  ///
  /// </summary>
  /// <param name="dataTable"></param>
  /// <param name="csvFileName"></param>
  public static void WriteToCSVFile( System.Data.DataTable dataTable, string csvFileName )
  {
   csvFileName = csvFileName.Replace( "/", "//" );
   string strDoc = csvFileName.Substring( 0, csvFileName.LastIndexOf( "//" ) );
   if( !Directory.Exists( strDoc ) )
    Directory.CreateDirectory( strDoc );
   if( File.Exists( csvFileName ) )
    File.Delete( csvFileName );
　　        int rowCount = 1;
   StringBuilder sb = new StringBuilder();
   foreach( DataRow row in dataTable.Rows )
   {
    for( int i = 0; i < dataTable.Columns.Count; i++  )
    {
     sb.Append( row[ i ].ToString() );
     if( i != dataTable.Columns.Count - 1 )
      sb.Append( "," );
    }
    sb.Append( Environment.NewLine );
    rowCount++;
   }
   using( StreamWriter streamWriter = new StreamWriter( csvFileName, false, Encoding.Default ) )
   {
    streamWriter.WriteLine( sb.ToString() );
    //把缓冲区的信息写入到文件中
    streamWriter.Flush();
    //关闭streamWriter
    streamWriter.Close();
   }
  }
  #endregion
 }
}