CSV file having multiple comma's in single column

Question

how to create CSV file having multiple comma's in single column? e.g. iddescription 101abcdef 102ghj

Saber Shaikh · Answer

only set the Sql Query youcan Get Out put Like SELECT column1  column2 +''+ column3 As Desc FROM Tbl_Name 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

Harminder Singh · Answer

just tell me how to replace space  from string builder that i earlier replace with

Harminder Singh · Answer

check this

Saber Shaikh · Answer

give me screen shot of excel sheet what you want to Id des 1 abc 2 def

Saber Shaikh · Answer

if (dataTable.Columns.Count != 0) { sbldr.Append(string.Join(  dataTable.Columns.OfType ())); sbldr.Append(
); for (int i = 0; i { sbldr.Append(string.Join(  dataTable.Rows.OfType ().Select(r => r[i].ToString()))); sbldr.Append(
); } } Use this

Manoj Bhoir · Answer

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); } } } }

Harminder Singh · Answer

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(
); foreach (DataRow row1 in dt.Rows) { foreach (DataColumn column in dt.Columns) { sbldr.Append(row1[column].ToString().Replace(''' ') + ''); } sbldr.Append(
); } } Response.Output.Write(sbldr.ToString()); Response.Flush(); Response.End();

Saber Shaikh · Answer

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 onetwothree onetwothree My blog