CSV file having multiple comma's in single column

only set the Sql Query youcan Get Out put 

Like


then use this Code only datatable Export 

http://www.aspsnippets.com/Articles/Export-data-from-SQL-Server-to-Excel-in-ASPNet-using-C-and-VBNet.aspx

check this

give me screen shot of excel sheet what you want to 

Id	des
1	abc
2	def

Hi,

Check this sample code :

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            using (StreamWriter sw = File.CreateText("d:\\TestCSV.csv"))
            {
                sw.WriteLine("1, 2, 3");
                sw.WriteLine("4, 5, 6");
                sw.WriteLine("\"7, 8\", 9 , 10");
            }   
        }
    }
}

But i am using string builder... then how to do??? my code is given below
Response.Clear();
Response.Buffer = true; 
Response.AddHeader("content-disposition", "attachment;filename=DATA.csv");
Response.Charset = ""; 
Response.ContentType = "application/text"; 
StringBuilder sbldr = new StringBuilder();
if (dt.Columns.Count != 0) 
{
foreach (DataColumn col in dt.Columns)
{ 
sbldr.Append(col.ColumnName + ',');
} 
sbldr.Append("\r\n"); 
foreach (DataRow row1 in dt.Rows) 
{ 
foreach (DataColumn column in dt.Columns) 
{ 
sbldr.Append(row1[column].ToString().Replace(',',' ') + ',');
} 
sbldr.Append("\r\n"); 
}
} 
Response.Output.Write(sbldr.ToString());
Response.Flush();
Response.End();

use with your logic 


string[] arr = { "one", "two", "three" }; // "string" can be lowercase.

Console.WriteLine(string.Join(",", arr)); // ... "String" can be uppercase.

Console.WriteLine(String.Join(",", arr));



Output

one,two,three

one,two,three

My blog