轉出EXCEL 出現必須置於有 runat=server........－冠霖的部落格

在VB.NET用

Response.AddHeader("content-disposition", "attachment; filename=Examples.xls")
      Response.ContentType = "application/vnd.ms-excel"
      Dim tw As StringWriter = New System.IO.StringWriter()
      Dim hw As HtmlTextWriter = New HtmlTextWriter(tw)
      mygrid.RenderControl(hw)
      Response.Write(tw.ToString())
Response.End()

並未產生錯誤

在C#卻出現

'處理'GridView' 的控制項 'GridView' 必須置於有 runat=server 的表單標記之中

在拜過GOOGLE大神後跟查MSDN後

解法如下

C# 加上下面的CODE就OK了

public override void VerifyRenderingInServerForm(Control control)
{
}

再附一段別人的SAMPLE :P

<%@ Page language="C#" Debug="true" ResponseEncoding="utf-8" %>
<%@ Import Namespace="System.Drawing" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>

<script Language="C#" runat="server">
private void Button1_Click(object sender, System.EventArgs e)
{
//export to excel

Response.Clear();
Response.Buffer= true;
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "";
this.EnableViewState = false;

System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);

this.ClearControls(dg);
dg.RenderControl(oHtmlTextWriter);

Response.Write(oStringWriter.ToString());

Response.End();
}

private void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{

SqlConnection conn = new SqlConnection ("data source=(local);initial catalog=Northwind;Pwd=hpserver20030127;User ID=sa");
SqlCommand cmd = new SqlCommand ("Select LastName, FirstName, Title, TitleOfCourtesy, BirthDate, HireDate, Address, City, Region, PostalCode, Country from Employees", conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
dg.DataSource = ds.Tables[0];
dg.DataBind();
}

}

private void ClearControls(Control control)
{
for (int i=control.Controls.Count -1; i>=0; i--)
{
ClearControls(control.Controls[i]);
}

if (!(control is TableCell))
{
if (control.GetType().GetProperty("SelectedItem") != null)
{
LiteralControl literal = new LiteralControl();
control.Parent.Controls.Add(literal);
try
{
literal.Text = (string)control.GetType().GetProperty("SelectedItem").GetValue(control,null);
}
catch

{

}

control.Parent.Controls.Remove(control);
}

else

if (control.GetType().GetProperty("Text") != null)
{
LiteralControl literal = new LiteralControl();
control.Parent.Controls.Add(literal);
literal.Text = (string)control.GetType().GetProperty("Text").GetValue(control,null);
control.Parent.Controls.Remove(control);
}
}
return;
}
</script>
<html>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<form id="frm" runat="server">
<asp:Button id="Button1" runat="server" Text="Export to Excel"
OnClick="Button1_Click"></asp:Button><BR>
<asp:Datagrid id="dg" runat="server" AutoGenerateColumns="True"
AllowSorting="true" AllowPaging="true"
CellPadding="3" PageSize=3>
<columns>
<asp:TemplateColumn>
<ItemTemplate>
<asp:LinkButton runat="server" CommandName="Edit"
CausesValidation="false" ID="btnView"
Text="Edit"/>
</ItemTemplate>
</asp:TemplateColumn>

</columns>
</asp:datagrid>

<BR> </form>
</body>
</html>