Re: Excel Conversion Error - ASP.NET Discussion Boards

Sapan Roy12-Jun-07 21:48

12-Jun-07 21:48

Hi,
All
Could any body help me out. I have a stored procedure in oracle which returns 4 sysrefcursor and on dot net side I mean asp.net using c#. I am not able to recieve the SysRefCursor. If any body has any clue please help me....

Thanks
Sapan

Spillting Headache

Excel Conversion Error

DKalepu12-Jun-07 20:46

DKalepu

12-Jun-07 20:46

Hi All,

I need some help. I'm trying to export Gridview into Excel. But i'm getting the following error!

"Control 'myGridView' of type 'GridView' must be placed inside a form tag with runat=server."

Here is my Code:

protected void BtnExport_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/ms-excel.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
myGridView.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
}

THIS IS THE GRIDVIEW THAT I'M USING::
<asp:gridview id="myGridView" runat="server" width="483px" cellpadding="4" forecolor="#333333" autogeneratecolumns="False" datasourceid="AccessDataSource1">
<columns>
<asp:boundfield datafield="Sno" headertext="SNo" sortexpression="Sno">
<asp:boundfield datafield="Partno" headertext="PartNo" sortexpression="Partno">
<asp:boundfield datafield="mfg" headertext="Manufacturer" sortexpression="mfg">
<asp:boundfield datafield="qty" headertext="Quantity" sortexpression="qty">
<asp:boundfield datafield="price" headertext="Price" sortexpression="price">

<footerstyle backcolor="#507CD1" font-bold="True" forecolor="White">
<rowstyle backcolor="#EFF3FB">
<editrowstyle backcolor="#2461BF">
<selectedrowstyle backcolor="#D1DDF1" font-bold="True" forecolor="#333333">
<pagerstyle backcolor="#2461BF" forecolor="White" horizontalalign="Center">
<headerstyle backcolor="#507CD1" font-bold="True" forecolor="White">
<alternatingrowstyle backcolor="White">

<asp:accessdatasource id="AccessDataSource1" runat="server" datafile="~/App_Data/db1.mdb"
="" selectcommand="SELECT [Sno], [Partno], [mfg], [qty], [price] FROM [RfqInfo]">

But my Gridview is already placed in the form only!!!! Cry | :((

could any one please help me on this issue???

Thanks in Advance.