C#

private void toolStripButton2_Click(object sender, EventArgs e)
{

    //Write Header Record
    StreamWriter sw = new StreamWriter(@"C:\file1.csv", false);
    DataTable dt = m_dtCC;
    int iColCount = dt.Columns.Count;
    for (int i = 0; i < iColCount; i++)
    {
        /*Ensure all Fields are wrapped in Quotes
          else you get errors when opening file
          in Excel.
        */
        sw.Write(@"""{0}""", dt.Columns[i]);
        if (i < iColCount - 1)
        {
            sw.Write(",");
        }
    }
    sw.Write(sw.NewLine);

    //Write all records in the DB
    foreach (DataRow dr in dt.Rows)
    {
        //Search for all Records with value 0
        if (dr["Exported"].ToString() == "0")
        {
            for (int i = 0; i < iColCount; i++)
            {
                if (!Convert.IsDBNull(dr[i]))
                {
                    sw.Write(@"""{0}""", dr[i].ToString());
                }
                if (i < iColCount - 1)
                {
                    sw.Write(",");
                }
            }
            sw.Write(sw.NewLine);
        }
    }

    sw.Close();