export datagrid to Excel

F

Frank

Hello All,

I ham using VS.NET 2003.

Have followed instructions from
http://gridviewguy.com/ArticleDetails.aspx?articleID=26 along with several
other articles to no avail. I am pulling my hair out at this point. What I
have is this :

Members.aspx file:
<HTML>
<HEAD>
<title>members</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema"
content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<mz:Header_Admin id="Heading1" runat="server"></mz:Header_Admin>
<mz:Menu id="Menu1" runat="server"></mz:Menu>
<asp:HyperLink id="HyperLink1" style="Z-INDEX: 105; LEFT: 144px;
POSITION: absolute; TOP: 248px"
runat="server" ForeColor="#F2BD73"
NavigateUrl="members.aspx">Members</asp:HyperLink>
<asp:LinkButton id="LinkButton1" style="Z-INDEX: 101; LEFT:
152px; POSITION: absolute; TOP: 280px"
runat="server" ForeColor="#EA9919">Add</asp:LinkButton>
<asp:LinkButton id="LinkButton2" style="Z-INDEX: 104; LEFT:
152px; POSITION: absolute; TOP: 312px"
runat="server" ForeColor="#EA9919">Remove</asp:LinkButton>
<asp:LinkButton id="LinkButton3" style="Z-INDEX: 102; LEFT:
152px; POSITION: absolute; TOP: 344px"
onclick="LinkButton3_Click" runat="server"
ForeColor="#EA9919">View</asp:LinkButton>
<asp:HyperLink id="HyperLink2" style="Z-INDEX: 103; LEFT: 136px;
POSITION: absolute; TOP: 376px"
runat="server" ForeColor="#F2BD73"
NavigateUrl="#.aspx">Community</asp:HyperLink>
<asp:Button id="Button1" style="Z-INDEX: 106; LEFT: 504px;
POSITION: absolute; TOP: 320px" runat="server"
Text="Export to Excel"></asp:Button>
<BR>
<asp:Datagrid id="dg" runat="server" AutoGenerateColumns="True"
AllowSorting="true" AllowPaging="true"
CellPadding="3" PageSize="3" style="Z-INDEX: 107; LEFT:
464px; POSITION: absolute; TOP: 368px">
<columns>
<asp:TemplateColumn>
<ItemTemplate>
<asp:LinkButton runat="server" CommandName="Edit"
CausesValidation="false" ID="btnView" Text="Edit" />
</ItemTemplate>
</asp:TemplateColumn>
</columns>
</asp:Datagrid>
</form>
</body>
</HTML>



in code behind file:

namespace myComponent.mzControls
{

public class members : System.Web.UI.Page
{
protected System.Web.UI.WebControls.HyperLink HyperLink1;
protected System.Web.UI.WebControls.LinkButton LinkButton1;
protected System.Web.UI.WebControls.LinkButton LinkButton2;
protected System.Web.UI.WebControls.LinkButton LinkButton3;
protected System.Web.UI.WebControls.HyperLink HyperLink2;
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.DataGrid dg;
protected MZBusinessLayer bizObj;

private void Page_Load(object sender, System.EventArgs e)
{
if(!IsPostBack)
{
bizObj = new MZBusinessLayer();
dg.DataSource = bizObj.GetMembers();
DataBind();
}
}

#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}

/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.LinkButton3.Click += new
System.EventHandler(this.LinkButton3_Click);
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.dg.SelectedIndexChanged += new
System.EventHandler(this.dg_SelectedIndexChanged);
this.Load += new System.EventHandler(this.Page_Load);

}
#endregion

private void Button1_Click(object sender, System.EventArgs e)
{
Response.Clear();
Response.AddHeader("content-disposition",
"attachment;filename=FileName.xls");

Response.Charset = "";

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);

dg.RenderControl(htmlWrite);

Response.Write(stringWrite.ToString());

Response.End();

}

public void LinkButton3_Click(object sender, System.EventArgs e)
{

}

private void dg_SelectedIndexChanged(object sender, System.EventArgs e)
{

}
}
}


And the error message:

Control 'dg__ctl2__ctl0' of type 'DataGridLinkButton' must be placed inside
a form tag with runat=server.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Web.HttpException: Control 'dg__ctl2__ctl0' of
type 'DataGridLinkButton' must be placed inside a form tag with
runat=server.

Source Error:

An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.

Stack Trace:


[HttpException (0x80004005): Control 'dg__ctl2__ctl0' of type
'DataGridLinkButton' must be placed inside a form tag with runat=server.]
System.Web.UI.Page.VerifyRenderingInServerForm(Control control) +151
System.Web.UI.WebControls.LinkButton.AddAttributesToRender(HtmlTextWriter
writer) +38
System.Web.UI.WebControls.WebControl.RenderBeginTag(HtmlTextWriter
writer) +17
System.Web.UI.WebControls.DataGridLinkButton.Render(HtmlTextWriter
writer) +25
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +72
System.Web.UI.WebControls.TableCell.RenderContents(HtmlTextWriter writer)
+55
System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) +29
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +72
System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter
writer) +7
System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) +29
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
System.Web.UI.WebControls.Table.RenderContents(HtmlTextWriter writer) +99
System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) +29
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +72
System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter
writer) +7
System.Web.UI.WebControls.BaseDataList.Render(HtmlTextWriter writer) +27
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
MarketZar.mzControls.members.Button1_Click(Object sender, EventArgs e)
+186
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET
Version:1.1.4322.2032



I don't have any controls outside of the form. What the heck is going on
here?
 
G

Guest

To get around this same exception, I had to hide the link button column when
rendering the datagrid to Excel. In my case, the link button column was the
last column so I used this code:

UserList_dg.Columns[UserList_dg.Columns.Count-1].Visible = false;

I only run that code when the datagrid was being rendered to Excel.

In another instance, where the link button text was data that needed to be
seen in Excel, I handled the ItemDatabound event and, in the event handler,
manually generated the content for the column as a link button when rendering
to a page and as text when rendering to Excel.

HTH
--
Dale Preston
MCAD C#
MCSE, MCDBA


Frank said:
Hello All,

I ham using VS.NET 2003.

Have followed instructions from
http://gridviewguy.com/ArticleDetails.aspx?articleID=26 along with several
other articles to no avail. I am pulling my hair out at this point. What I
have is this :

Members.aspx file:
<HTML>
<HEAD>
<title>members</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema"
content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<mz:Header_Admin id="Heading1" runat="server"></mz:Header_Admin>
<mz:Menu id="Menu1" runat="server"></mz:Menu>
<asp:HyperLink id="HyperLink1" style="Z-INDEX: 105; LEFT: 144px;
POSITION: absolute; TOP: 248px"
runat="server" ForeColor="#F2BD73"
NavigateUrl="members.aspx">Members</asp:HyperLink>
<asp:LinkButton id="LinkButton1" style="Z-INDEX: 101; LEFT:
152px; POSITION: absolute; TOP: 280px"
runat="server" ForeColor="#EA9919">Add</asp:LinkButton>
<asp:LinkButton id="LinkButton2" style="Z-INDEX: 104; LEFT:
152px; POSITION: absolute; TOP: 312px"
runat="server" ForeColor="#EA9919">Remove</asp:LinkButton>
<asp:LinkButton id="LinkButton3" style="Z-INDEX: 102; LEFT:
152px; POSITION: absolute; TOP: 344px"
onclick="LinkButton3_Click" runat="server"
ForeColor="#EA9919">View</asp:LinkButton>
<asp:HyperLink id="HyperLink2" style="Z-INDEX: 103; LEFT: 136px;
POSITION: absolute; TOP: 376px"
runat="server" ForeColor="#F2BD73"
NavigateUrl="#.aspx">Community</asp:HyperLink>
<asp:Button id="Button1" style="Z-INDEX: 106; LEFT: 504px;
POSITION: absolute; TOP: 320px" runat="server"
Text="Export to Excel"></asp:Button>
<BR>
<asp:Datagrid id="dg" runat="server" AutoGenerateColumns="True"
AllowSorting="true" AllowPaging="true"
CellPadding="3" PageSize="3" style="Z-INDEX: 107; LEFT:
464px; POSITION: absolute; TOP: 368px">
<columns>
<asp:TemplateColumn>
<ItemTemplate>
<asp:LinkButton runat="server" CommandName="Edit"
CausesValidation="false" ID="btnView" Text="Edit" />
</ItemTemplate>
</asp:TemplateColumn>
</columns>
</asp:Datagrid>
</form>
</body>
</HTML>



in code behind file:

namespace myComponent.mzControls
{

public class members : System.Web.UI.Page
{
protected System.Web.UI.WebControls.HyperLink HyperLink1;
protected System.Web.UI.WebControls.LinkButton LinkButton1;
protected System.Web.UI.WebControls.LinkButton LinkButton2;
protected System.Web.UI.WebControls.LinkButton LinkButton3;
protected System.Web.UI.WebControls.HyperLink HyperLink2;
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.DataGrid dg;
protected MZBusinessLayer bizObj;

private void Page_Load(object sender, System.EventArgs e)
{
if(!IsPostBack)
{
bizObj = new MZBusinessLayer();
dg.DataSource = bizObj.GetMembers();
DataBind();
}
}

#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}

/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.LinkButton3.Click += new
System.EventHandler(this.LinkButton3_Click);
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.dg.SelectedIndexChanged += new
System.EventHandler(this.dg_SelectedIndexChanged);
this.Load += new System.EventHandler(this.Page_Load);

}
#endregion

private void Button1_Click(object sender, System.EventArgs e)
{
Response.Clear();
Response.AddHeader("content-disposition",
"attachment;filename=FileName.xls");

Response.Charset = "";

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);

dg.RenderControl(htmlWrite);

Response.Write(stringWrite.ToString());

Response.End();

}

public void LinkButton3_Click(object sender, System.EventArgs e)
{

}

private void dg_SelectedIndexChanged(object sender, System.EventArgs e)
{

}
}
}


And the error message:

Control 'dg__ctl2__ctl0' of type 'DataGridLinkButton' must be placed inside
a form tag with runat=server.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Web.HttpException: Control 'dg__ctl2__ctl0' of
type 'DataGridLinkButton' must be placed inside a form tag with
runat=server.

Source Error:

An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.

Stack Trace:


[HttpException (0x80004005): Control 'dg__ctl2__ctl0' of type
'DataGridLinkButton' must be placed inside a form tag with runat=server.]
System.Web.UI.Page.VerifyRenderingInServerForm(Control control) +151
System.Web.UI.WebControls.LinkButton.AddAttributesToRender(HtmlTextWriter
writer) +38
System.Web.UI.WebControls.WebControl.RenderBeginTag(HtmlTextWriter
writer) +17
System.Web.UI.WebControls.DataGridLinkButton.Render(HtmlTextWriter
writer) +25
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +72
System.Web.UI.WebControls.TableCell.RenderContents(HtmlTextWriter writer)
+55
System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) +29
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +72
System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter
writer) +7
System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) +29
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
System.Web.UI.WebControls.Table.RenderContents(HtmlTextWriter writer) +99
System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) +29
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +72
System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter
writer) +7
System.Web.UI.WebControls.BaseDataList.Render(HtmlTextWriter writer) +27
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
MarketZar.mzControls.members.Button1_Click(Object sender, EventArgs e)
+186
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET
Version:1.1.4322.2032



I don't have any controls outside of the form. What the heck is going on
here?
Click to expand...
 
G

greyhound

Thanks for your excellent reply. I searched the Web for a day and a
half trying to solve this issue. Others may have given good advice but
yours was the post that made the most sense and easy to implement.
To get around this same exception, I had to hide the link button column when
rendering the datagrid to Excel. In my case, the link button column was the
last column so I used this code:

UserList_dg.Columns[UserList_dg.Columns.Count-1].Visible = false;

I only run that code when the datagrid was being rendered to Excel.

In another instance, where the link button text was data that needed to be
seen in Excel, I handled the ItemDatabound event and, in the event handler,
manually generated the content for the column as a link button when rendering
to a page and as text when rendering to Excel.

HTH
--
Dale Preston
MCAD C#
MCSE, MCDBA


Frank said:
Hello All,

I ham using VS.NET 2003.

Have followed instructions from
http://gridviewguy.com/ArticleDetails.aspx?articleID=26 along with several
other articles to no avail. I am pulling my hair out at this point. What I
have is this :

Members.aspx file:
<HTML>
<HEAD>
<title>members</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema"
content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<mz:Header_Admin id="Heading1" runat="server"></mz:Header_Admin>
<mz:Menu id="Menu1" runat="server"></mz:Menu>
<asp:HyperLink id="HyperLink1" style="Z-INDEX: 105; LEFT: 144px;
POSITION: absolute; TOP: 248px"
runat="server" ForeColor="#F2BD73"
NavigateUrl="members.aspx">Members</asp:HyperLink>
<asp:LinkButton id="LinkButton1" style="Z-INDEX: 101; LEFT:
152px; POSITION: absolute; TOP: 280px"
runat="server" ForeColor="#EA9919">Add</asp:LinkButton>
<asp:LinkButton id="LinkButton2" style="Z-INDEX: 104; LEFT:
152px; POSITION: absolute; TOP: 312px"
runat="server" ForeColor="#EA9919">Remove</asp:LinkButton>
<asp:LinkButton id="LinkButton3" style="Z-INDEX: 102; LEFT:
152px; POSITION: absolute; TOP: 344px"
onclick="LinkButton3_Click" runat="server"
ForeColor="#EA9919">View</asp:LinkButton>
<asp:HyperLink id="HyperLink2" style="Z-INDEX: 103; LEFT: 136px;
POSITION: absolute; TOP: 376px"
runat="server" ForeColor="#F2BD73"
NavigateUrl="#.aspx">Community</asp:HyperLink>
<asp:Button id="Button1" style="Z-INDEX: 106; LEFT: 504px;
POSITION: absolute; TOP: 320px" runat="server"
Text="Export to Excel"></asp:Button>
<BR>
<asp:Datagrid id="dg" runat="server" AutoGenerateColumns="True"
AllowSorting="true" AllowPaging="true"
CellPadding="3" PageSize="3" style="Z-INDEX: 107; LEFT:
464px; POSITION: absolute; TOP: 368px">
<columns>
<asp:TemplateColumn>
<ItemTemplate>
<asp:LinkButton runat="server" CommandName="Edit"
CausesValidation="false" ID="btnView" Text="Edit" />
</ItemTemplate>
</asp:TemplateColumn>
</columns>
</asp:Datagrid>
</form>
</body>
</HTML>



in code behind file:

namespace myComponent.mzControls
{

public class members : System.Web.UI.Page
{
protected System.Web.UI.WebControls.HyperLink HyperLink1;
protected System.Web.UI.WebControls.LinkButton LinkButton1;
protected System.Web.UI.WebControls.LinkButton LinkButton2;
protected System.Web.UI.WebControls.LinkButton LinkButton3;
protected System.Web.UI.WebControls.HyperLink HyperLink2;
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.DataGrid dg;
protected MZBusinessLayer bizObj;

private void Page_Load(object sender, System.EventArgs e)
{
if(!IsPostBack)
{
bizObj = new MZBusinessLayer();
dg.DataSource = bizObj.GetMembers();
DataBind();
}
}

#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}

/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.LinkButton3.Click += new
System.EventHandler(this.LinkButton3_Click);
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.dg.SelectedIndexChanged += new
System.EventHandler(this.dg_SelectedIndexChanged);
this.Load += new System.EventHandler(this.Page_Load);

}
#endregion

private void Button1_Click(object sender, System.EventArgs e)
{
Response.Clear();
Response.AddHeader("content-disposition",
"attachment;filename=FileName.xls");

Response.Charset = "";

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);

dg.RenderControl(htmlWrite);

Response.Write(stringWrite.ToString());

Response.End();

}

public void LinkButton3_Click(object sender, System.EventArgs e)
{

}

private void dg_SelectedIndexChanged(object sender, System.EventArgs e)
{

}
}
}


And the error message:

Control 'dg__ctl2__ctl0' of type 'DataGridLinkButton' must be placed inside
a form tag with runat=server.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Web.HttpException: Control 'dg__ctl2__ctl0' of
type 'DataGridLinkButton' must be placed inside a form tag with
runat=server.

Source Error:

An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.

Stack Trace:


[HttpException (0x80004005): Control 'dg__ctl2__ctl0' of type
'DataGridLinkButton' must be placed inside a form tag with runat=server.]
System.Web.UI.Page.VerifyRenderingInServerForm(Control control) +151
System.Web.UI.WebControls.LinkButton.AddAttributesToRender(HtmlTextWriter
writer) +38
System.Web.UI.WebControls.WebControl.RenderBeginTag(HtmlTextWriter
writer) +17
System.Web.UI.WebControls.DataGridLinkButton.Render(HtmlTextWriter
writer) +25
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +72
System.Web.UI.WebControls.TableCell.RenderContents(HtmlTextWriter writer)
+55
System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) +29
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +72
System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter
writer) +7
System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) +29
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
System.Web.UI.WebControls.Table.RenderContents(HtmlTextWriter writer) +99
System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) +29
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +72
System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter
writer) +7
System.Web.UI.WebControls.BaseDataList.Render(HtmlTextWriter writer) +27
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
MarketZar.mzControls.members.Button1_Click(Object sender, EventArgs e)
+186
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET
Version:1.1.4322.2032



I don't have any controls outside of the form. What the heck is going on
here?
Click to expand...
Click to expand...
 
G

Guest

I'm glad I was able to help!
--
Dale Preston
MCAD C#
MCSE, MCDBA


greyhound said:
Thanks for your excellent reply. I searched the Web for a day and a
half trying to solve this issue. Others may have given good advice but
yours was the post that made the most sense and easy to implement.
To get around this same exception, I had to hide the link button column when
rendering the datagrid to Excel. In my case, the link button column was the
last column so I used this code:

UserList_dg.Columns[UserList_dg.Columns.Count-1].Visible = false;

I only run that code when the datagrid was being rendered to Excel.

In another instance, where the link button text was data that needed to be
seen in Excel, I handled the ItemDatabound event and, in the event handler,
manually generated the content for the column as a link button when rendering
to a page and as text when rendering to Excel.

HTH
--
Dale Preston
MCAD C#
MCSE, MCDBA


Frank said:
Hello All,

I ham using VS.NET 2003.

Have followed instructions from
http://gridviewguy.com/ArticleDetails.aspx?articleID=26 along with several
other articles to no avail. I am pulling my hair out at this point. What I
have is this :

Members.aspx file:
<HTML>
<HEAD>
<title>members</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema"
content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<mz:Header_Admin id="Heading1" runat="server"></mz:Header_Admin>
<mz:Menu id="Menu1" runat="server"></mz:Menu>
<asp:HyperLink id="HyperLink1" style="Z-INDEX: 105; LEFT: 144px;
POSITION: absolute; TOP: 248px"
runat="server" ForeColor="#F2BD73"
NavigateUrl="members.aspx">Members</asp:HyperLink>
<asp:LinkButton id="LinkButton1" style="Z-INDEX: 101; LEFT:
152px; POSITION: absolute; TOP: 280px"
runat="server" ForeColor="#EA9919">Add</asp:LinkButton>
<asp:LinkButton id="LinkButton2" style="Z-INDEX: 104; LEFT:
152px; POSITION: absolute; TOP: 312px"
runat="server" ForeColor="#EA9919">Remove</asp:LinkButton>
<asp:LinkButton id="LinkButton3" style="Z-INDEX: 102; LEFT:
152px; POSITION: absolute; TOP: 344px"
onclick="LinkButton3_Click" runat="server"
ForeColor="#EA9919">View</asp:LinkButton>
<asp:HyperLink id="HyperLink2" style="Z-INDEX: 103; LEFT: 136px;
POSITION: absolute; TOP: 376px"
runat="server" ForeColor="#F2BD73"
NavigateUrl="#.aspx">Community</asp:HyperLink>
<asp:Button id="Button1" style="Z-INDEX: 106; LEFT: 504px;
POSITION: absolute; TOP: 320px" runat="server"
Text="Export to Excel"></asp:Button>
<BR>
<asp:Datagrid id="dg" runat="server" AutoGenerateColumns="True"
AllowSorting="true" AllowPaging="true"
CellPadding="3" PageSize="3" style="Z-INDEX: 107; LEFT:
464px; POSITION: absolute; TOP: 368px">
<columns>
<asp:TemplateColumn>
<ItemTemplate>
<asp:LinkButton runat="server" CommandName="Edit"
CausesValidation="false" ID="btnView" Text="Edit" />
</ItemTemplate>
</asp:TemplateColumn>
</columns>
</asp:Datagrid>
</form>
</body>
</HTML>



in code behind file:

namespace myComponent.mzControls
{

public class members : System.Web.UI.Page
{
protected System.Web.UI.WebControls.HyperLink HyperLink1;
protected System.Web.UI.WebControls.LinkButton LinkButton1;
protected System.Web.UI.WebControls.LinkButton LinkButton2;
protected System.Web.UI.WebControls.LinkButton LinkButton3;
protected System.Web.UI.WebControls.HyperLink HyperLink2;
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.DataGrid dg;
protected MZBusinessLayer bizObj;

private void Page_Load(object sender, System.EventArgs e)
{
if(!IsPostBack)
{
bizObj = new MZBusinessLayer();
dg.DataSource = bizObj.GetMembers();
DataBind();
}
}

#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}

/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.LinkButton3.Click += new
System.EventHandler(this.LinkButton3_Click);
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.dg.SelectedIndexChanged += new
System.EventHandler(this.dg_SelectedIndexChanged);
this.Load += new System.EventHandler(this.Page_Load);

}
#endregion

private void Button1_Click(object sender, System.EventArgs e)
{
Response.Clear();
Response.AddHeader("content-disposition",
"attachment;filename=FileName.xls");

Response.Charset = "";

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);

dg.RenderControl(htmlWrite);

Response.Write(stringWrite.ToString());

Response.End();

}

public void LinkButton3_Click(object sender, System.EventArgs e)
{

}

private void dg_SelectedIndexChanged(object sender, System.EventArgs e)
{

}
}
}


And the error message:

Control 'dg__ctl2__ctl0' of type 'DataGridLinkButton' must be placed inside
a form tag with runat=server.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Web.HttpException: Control 'dg__ctl2__ctl0' of
type 'DataGridLinkButton' must be placed inside a form tag with
runat=server.

Source Error:

An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.

Stack Trace:


[HttpException (0x80004005): Control 'dg__ctl2__ctl0' of type
'DataGridLinkButton' must be placed inside a form tag with runat=server.]
System.Web.UI.Page.VerifyRenderingInServerForm(Control control) +151
System.Web.UI.WebControls.LinkButton.AddAttributesToRender(HtmlTextWriter
writer) +38
System.Web.UI.WebControls.WebControl.RenderBeginTag(HtmlTextWriter
writer) +17
System.Web.UI.WebControls.DataGridLinkButton.Render(HtmlTextWriter
writer) +25
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +72
System.Web.UI.WebControls.TableCell.RenderContents(HtmlTextWriter writer)
+55
System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) +29
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +72
System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter
writer) +7
System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) +29
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
System.Web.UI.WebControls.Table.RenderContents(HtmlTextWriter writer) +99
System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) +29
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +72
System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter
writer) +7
System.Web.UI.WebControls.BaseDataList.Render(HtmlTextWriter writer) +27
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
MarketZar.mzControls.members.Button1_Click(Object sender, EventArgs e)
+186
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET
Version:1.1.4322.2032



I don't have any controls outside of the form. What the heck is going on
here?
Click to expand...
Click to expand...
Click to expand...
 
G

Guest

Gents,

I have been able to generate the Excel document with no problems. Except
one thing that, of course, our users complain about.

The process seems to automatically insert a blank row at the top of the
Excel document. Or, in other words, it starts the output on Row 2.

Is there a way to prevent this and start at Row 1?

Thanx,

Shawn K Haase

===============================================

Dale said:
I'm glad I was able to help!
--
Dale Preston
MCAD C#
MCSE, MCDBA


greyhound said:
Thanks for your excellent reply. I searched the Web for a day and a
half trying to solve this issue. Others may have given good advice but
yours was the post that made the most sense and easy to implement.
To get around this same exception, I had to hide the link button column when
rendering the datagrid to Excel. In my case, the link button column was the
last column so I used this code:

UserList_dg.Columns[UserList_dg.Columns.Count-1].Visible = false;

I only run that code when the datagrid was being rendered to Excel.

In another instance, where the link button text was data that needed to be
seen in Excel, I handled the ItemDatabound event and, in the event handler,
manually generated the content for the column as a link button when rendering
to a page and as text when rendering to Excel.

HTH
--
Dale Preston
MCAD C#
MCSE, MCDBA


:

Hello All,

I ham using VS.NET 2003.

Have followed instructions from
http://gridviewguy.com/ArticleDetails.aspx?articleID=26 along with several
other articles to no avail. I am pulling my hair out at this point. What I
have is this :

Members.aspx file:
<HTML>
<HEAD>
<title>members</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema"
content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<mz:Header_Admin id="Heading1" runat="server"></mz:Header_Admin>
<mz:Menu id="Menu1" runat="server"></mz:Menu>
<asp:HyperLink id="HyperLink1" style="Z-INDEX: 105; LEFT: 144px;
POSITION: absolute; TOP: 248px"
runat="server" ForeColor="#F2BD73"
NavigateUrl="members.aspx">Members</asp:HyperLink>
<asp:LinkButton id="LinkButton1" style="Z-INDEX: 101; LEFT:
152px; POSITION: absolute; TOP: 280px"
runat="server" ForeColor="#EA9919">Add</asp:LinkButton>
<asp:LinkButton id="LinkButton2" style="Z-INDEX: 104; LEFT:
152px; POSITION: absolute; TOP: 312px"
runat="server" ForeColor="#EA9919">Remove</asp:LinkButton>
<asp:LinkButton id="LinkButton3" style="Z-INDEX: 102; LEFT:
152px; POSITION: absolute; TOP: 344px"
onclick="LinkButton3_Click" runat="server"
ForeColor="#EA9919">View</asp:LinkButton>
<asp:HyperLink id="HyperLink2" style="Z-INDEX: 103; LEFT: 136px;
POSITION: absolute; TOP: 376px"
runat="server" ForeColor="#F2BD73"
NavigateUrl="#.aspx">Community</asp:HyperLink>
<asp:Button id="Button1" style="Z-INDEX: 106; LEFT: 504px;
POSITION: absolute; TOP: 320px" runat="server"
Text="Export to Excel"></asp:Button>
<BR>
<asp:Datagrid id="dg" runat="server" AutoGenerateColumns="True"
AllowSorting="true" AllowPaging="true"
CellPadding="3" PageSize="3" style="Z-INDEX: 107; LEFT:
464px; POSITION: absolute; TOP: 368px">
<columns>
<asp:TemplateColumn>
<ItemTemplate>
<asp:LinkButton runat="server" CommandName="Edit"
CausesValidation="false" ID="btnView" Text="Edit" />
</ItemTemplate>
</asp:TemplateColumn>
</columns>
</asp:Datagrid>
</form>
</body>
</HTML>



in code behind file:

namespace myComponent.mzControls
{

public class members : System.Web.UI.Page
{
protected System.Web.UI.WebControls.HyperLink HyperLink1;
protected System.Web.UI.WebControls.LinkButton LinkButton1;
protected System.Web.UI.WebControls.LinkButton LinkButton2;
protected System.Web.UI.WebControls.LinkButton LinkButton3;
protected System.Web.UI.WebControls.HyperLink HyperLink2;
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.DataGrid dg;
protected MZBusinessLayer bizObj;

private void Page_Load(object sender, System.EventArgs e)
{
if(!IsPostBack)
{
bizObj = new MZBusinessLayer();
dg.DataSource = bizObj.GetMembers();
DataBind();
}
}

#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}

/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.LinkButton3.Click += new
System.EventHandler(this.LinkButton3_Click);
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.dg.SelectedIndexChanged += new
System.EventHandler(this.dg_SelectedIndexChanged);
this.Load += new System.EventHandler(this.Page_Load);

}
#endregion

private void Button1_Click(object sender, System.EventArgs e)
{
Response.Clear();
Response.AddHeader("content-disposition",
"attachment;filename=FileName.xls");

Response.Charset = "";

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);

dg.RenderControl(htmlWrite);

Response.Write(stringWrite.ToString());

Response.End();

}

public void LinkButton3_Click(object sender, System.EventArgs e)
{

}

private void dg_SelectedIndexChanged(object sender, System.EventArgs e)
{

}
}
}


And the error message:

Control 'dg__ctl2__ctl0' of type 'DataGridLinkButton' must be placed inside
a form tag with runat=server.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Web.HttpException: Control 'dg__ctl2__ctl0' of
type 'DataGridLinkButton' must be placed inside a form tag with
runat=server.

Source Error:

An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.

Stack Trace:


[HttpException (0x80004005): Control 'dg__ctl2__ctl0' of type
'DataGridLinkButton' must be placed inside a form tag with runat=server.]
System.Web.UI.Page.VerifyRenderingInServerForm(Control control) +151
System.Web.UI.WebControls.LinkButton.AddAttributesToRender(HtmlTextWriter
writer) +38
System.Web.UI.WebControls.WebControl.RenderBeginTag(HtmlTextWriter
writer) +17
System.Web.UI.WebControls.DataGridLinkButton.Render(HtmlTextWriter
writer) +25
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +72
System.Web.UI.WebControls.TableCell.RenderContents(HtmlTextWriter writer)
+55
System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) +29
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +72
System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter
writer) +7
System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) +29
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
System.Web.UI.WebControls.Table.RenderContents(HtmlTextWriter writer) +99
System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) +29
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +72
System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter
writer) +7
System.Web.UI.WebControls.BaseDataList.Render(HtmlTextWriter writer) +27
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
MarketZar.mzControls.members.Button1_Click(Object sender, EventArgs e)
+186
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET
Version:1.1.4322.2032



I don't have any controls outside of the form. What the heck is going on
here?
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using template columns 1
sometimes we get Object reference to NULL error 6
this.Controls.Add(ImageButton[i]) exception 2
Newbie:Simple 'textbox' causing this error ? 3
Create a textbox dynamically and add it to the controls collection? 1
Newbie: capturing changed value of text field instead of default 2
CompareValidator problem 4
eventvalidation razzle dazzle 1

Top