export gridview data to CSV file

[Praveen Kandari]

Not able to download gridview content. Downloaded CSV file is empty. my code on button click is:-

public override void VerifyRenderingInServerForm(Control control)
{
}
protected void btnCSV_Click(object sender, ImageClickEventArgs e)
{
Response.Content="";
Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "attachment.csv"));
Response.ContentType = "application/text";(also tried vnd.csv)
gv1.AllowPaging = false;
gv1.DataBind();
StringBuilder sb = new StringBuilder();
for (int i = 0; i < gv1.Columns.Count; i++)
{

sb.Append(gv1.Columns[i].HeaderText + ',');
}

sb.Append("\n");
for (int j = 0; j < gv1.Rows.Count; j++)
{
for (int k = 0; k < gv1.Columns.Count; k++)
{

sb.Append(gv1.Rows[j].Cells[k].Text + ',');
}

sb.Append("\n");
}
Response.Write(sb.ToString());
Response.End();
}

[ZurdoDev]

Debug it and make sure sb.ToString() actually has something.

There are only 10 types of people in the world, those who understand binary and those who don't.