Eksport til EXCEL

Her lige prøvet med dette:

protected void Button1_Click(object sender, EventArgs e)
    {

      Response.Clear();
      Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");
      Response.Charset = "";
   
      // If you want the option to open the Excel file without saving then
      // comment out the line below
      // Response.Cache.SetCacheability(HttpCacheability.NoCache);
      Response.ContentType = "application/vnd.xls";
      System.IO.StringWriter stringWrite = new System.IO.StringWriter();
      System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
      GridView1.RenderControl(htmlWrite);
      Response.Write(stringWrite.ToString());
      Response.End();
    }

Men så kommer den op og siger følgende:

Kontrolelementet 'ctl00_ContentPlaceHolder1_GridView1' af typen 'GridView' skal placeres i en formularkode med runat=server.

Men GridView er allerede erklæret således:

<asp:GridView ID="GridView1" runat="server" ...

Såå det passer da ikke helt det den brokker sig over? eller hvad?

haha...man skal blot tilføje en ekstra metode for ikke at den brokker sig...

public override void VerifyRenderingInServerForm(Control control)
{
  /* Confirms that an HtmlForm control is rendered for the specified ASP.NET
    server control at run time. */
}

Tjek evt.
http://aspalliance.com/771