รบกวนพี่ๆเรื่องการคั่นคอลั่มจาก (,) เป็น (|) ใน .csv ไฟล์ด้วยครับ

    //*** Convert CSV to DataTable ***//
    protected DataTable CsvCreateDataTable(String strPath, String strFilesName)
    {
        OleDbConnection objConn = new OleDbConnection();
        OleDbDataAdapter dtAdapter;
        DataTable dt = new DataTable();


        String strConnString;
        strConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + strPath +
            ";Extended Properties=\"TEXT;HDR=No;FMT=Delimited;Format=Delimited(|)\";";

        objConn = new OleDbConnection(strConnString);
        objConn.Open();

        String strSQL;
        strSQL = "SELECT * FROM " + strFilesName;

        dtAdapter = new OleDbDataAdapter(strSQL, objConn);
        dtAdapter.Fill(dt);

        dtAdapter = null;

        objConn.Close();
        objConn = null;

        return dt; //*** Return DataTable ***//
    }

protected void ExportToCSV(DataTable dt)
    {

        System.Data.OleDb.OleDbConnection objConn;
        System.Data.OleDb.OleDbCommand objCmd;
        String strConnString, strSQL;
        int i;
        //String strPath = "csv/";
        String strPath = @"E:\PTTPMCRMDATA\CRM_SIEBEL\EXPORT\";
        String strFileName = "ComplaintAttachment_SAGE.csv";



        //*** Create Text Files (Columns Default ***// ***//
        StreamWriter StrWer;
        StrWer = File.CreateText(strPath + strFileName);
        //StrWer = File.CreateText(Server.MapPath(strPath) + strFileName);
        StrWer.Write("H,Complaint_No,VC,File_Name,File_Ext");
        StrWer.Close();

        //*** Connect to CSV ***//
        strConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + strPath +
        ";Extended Properties='TEXT;HDR=Yes;FMT=Delimited;Format=Delimited(|)'";
        objConn = new System.Data.OleDb.OleDbConnection(strConnString);
        objConn.Open();

        try
        {
            //*** Loop Write CSV ***//
            for (i = 0; i <= dt.Rows.Count - 1; i++)
            {
                string OldComplaint_No = dt.Rows[i]["case_ComplaintNo"].ToString();
                string[] arrbkComplaint_No = OldComplaint_No.Split(' ');
                string case_ComplaintNo = arrbkComplaint_No[0];

                string OldFileName = dt.Rows[i]["Libr_FileName"].ToString();
                string[] arrbkFileName = OldFileName.Split('.');
                string FileName = arrbkFileName[0];
                string ext = arrbkFileName[1];
                strSQL = "INSERT INTO " + strFileName + " (H,Complaint_No,VC,File_Name,File_Ext) " +
                "VALUES ('D','" + case_ComplaintNo + "','Polymer','" + FileName + "'" +
                " ,'" + ext + "')";
                objCmd = new System.Data.OleDb.OleDbCommand();
                objCmd.Connection = objConn;
                objCmd.CommandType = CommandType.Text;
                objCmd.CommandText = strSQL;

                objCmd.ExecuteNonQuery();
            }
            Label1.Text = this.Label1.Text + "Export CSV :  " + strFileName + " <B>Successfully</B> <br>";
        }
        catch (Exception err)
        {
            Label1.Text = this.Label1.Text + "Export CSV :  " + strFileName + " <B>Can't Copy</B> <br>";
        }

        //Label1.Text = this.Label1.Text + "Export Successfully <a href=" + strPath + strFileName + ">Click here</a> <br>";

        objCmd = null;
        objConn.Close();
        objConn = null;

    }