Formatting issues while exporting dataset to csv

See more:

C#

ASP.NET

Hi all,

I have one simple formatting issue which i couldnt resolve.

I am trying to export a dataset to csv in asp.net.The issue is data in column1 is changing to scientific notations..

for example value 32E0 is getting converted to 3.20E+02.

I am using the below code to export the data to csv.

Can we able to format a column after exporting to csv.

Please help.

public static void CreateCSVFile(DataSet myData, string strFileName, string strReportTitle)
        {
            HttpContext.Current.Response.Clear();
 
            HttpContext.Current.Response.Buffer = true;
            HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + strFileName + ".csv");
            HttpContext.Current.Response.Charset = string.Empty;
            HttpContext.Current.Response.ContentType = "application/text";
            
            StringBuilder sb = new StringBuilder();
 
            DataTable dt = myData.Tables[0];
 
            for (int k = 0; k < dt.Columns.Count; k++)
            {
                sb.Append(dt.Columns[k].ColumnName + ',');
            }
 
            sb.Append("\r\n");
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                for (int k = 0; k < dt.Columns.Count; k++)
                {
                    sb.Append(dt.Rows[i][k].ToString().Replace(",", ";") + ',');
                }
 
                sb.Append("\r\n");                
 
            }
 
            HttpContext.Current.Response.Output.Write(sb.ToString());
            HttpContext.Current.Response.Flush();
            HttpContext.Current.Response.End();           
 
        }