export gridview to csv

• Wednesday, May 02, 2012 11:19 AM

   

   
  

  0

  plz help me how can handle and correct my code.

  im using that code its working fine but problem is that.

  my database table like that

  name     address        description

  jhon       rbnr,rrn         test,check,d

  when we export to csv file the description cloumn and address column show like that in excel

  excel sheet.

  description column in excel like that divided in 3 column

  tes                                                check              d

  and

  address column divided 2 column in excel

            

  DataSet ds = check.GetInstance().GetcheckReport(pocheck);

                  Response.Clear();

              Response.Buffer =true;

              Response.AddHeader("content-disposition","attachment;filename=GridViewExport.csv");

              Response.Charset ="";

              Response.ContentType ="application/text";

             

              DGResult.DataSource = ds.Tables[0];

              DGResult.DataBind();

           StringBuilder sb =newStringBuilder();

            for (int k = 0; k < DGPOResult.Columns.Count; k++)

              {

               //add separator

                  sb.Append(DGPOResult.Columns[k].HeaderText +',').Replace("&nbsp;",string.Empty);

              }

             //append new line

  sb.Append("\r\n");

             for (int i = 0; i < DGPOResult.Rows.Count; i++)

              {

                for (int k = 0; k < DGPOResult.Columns.Count; k++)

                  {

                    //add separator

  sb.Append(DGResult.Rows[i].Cells[k].Text +',').Replace("&nbsp;",string.Empty);

                  }

                //append new line

  sb.Append("\r\n");

              }

              Response.Output.Write(sb.ToString());

              Response.Flush();

              Response.End();

  plz help ev1

  • Moved by Jason Dot WangMicrosoft Contingent Staff Thursday, May 03, 2012 4:58 AM This topic is about ASP.NET (From:Visual C# General)
  •  
  • Reply
  • Quote