Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
export gridview to csv RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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 Wang Thursday, May 3, 2012 4:58 AM This topic is about ASP.NET (From:Visual C# General)
    Wednesday, May 2, 2012 11:19 AM

Answers

All replies