|
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
|
|
|
|
|
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!!!!
could any one please help me on this issue???
Thanks in Advance.
|
|
|
|
|
Your gridview is a server control and that control have to inside the form with runat=server tag. Add runat=server to your form tag.
Apurva Kaushal
|
|
|
|
|
Please add the Runat= server tag in your Grid view and run ur application.
Regards,
Satips.
|
|
|
|
|
I think runat=server has to be added in form control not in gridview.
Apurva Kaushal
|
|
|
|
|
Yes. Runat=server has to be added in the form Control.
Regards,
Satips.
|
|
|
|
|
Thank you all for the quick response!!!
my Form tag & Gridview both contains "runat=server" tag in it! ~!!! but no use!
grrrrrrr!
|
|
|
|
|
I think there would be some mismatch can you show us the form tag code?
Apurva Kaushal
|
|
|
|
|
yes, here is my form tag code:
<form id="form1" runat="server" style="width: 100%; height: 75%;">
<div>
<table border="0" width="100%">
<tr>
<td style="width: 5%"></td>
<td valign="top" style="width:20%;"><font face="Verdana" size="2">
<asp:Label ID="lblCompany" Width="100%" runat="server">Company</asp:Label></font></td>
<td valign="top" width="70%">
<asp:Label ID="lblCompany1" runat="server"></asp:Label></td>
<td width="5%"></td>
</tr>
<tr>
<td style="width: 5%"></td>
<td valign="top" style="width:20%;"><font face="Verdana" size="2">
<asp:Label ID="lblAddress" Width="100%" runat="server">Address</asp:Label></font></td>
<td valign="top" width="70%">
<asp:Label ID="lblAddress1" runat="server" TextMode="MultiLine"></asp:Label></td>
<td width="5%"></td>
</tr>
<tr>
<td style="width: 5%"></td>
<td valign="top" style="width:20%;"><font face="Verdana" size="2">
<asp:Label ID="lblTelephone" Width="100%" runat="server">Telephone</asp:Label></font></td>
<td valign="top" width="70%">
<asp:Label ID="lblTelephone1" runat="server"></asp:Label></td>
<td width="5%"></td>
</tr>
<tr>
<td style="width: 5%"></td>
<td valign="top" style="width:20%;"><font face="Verdana" size="2">
<asp:Label ID="lblFax" Width="100%" runat="server">Fax</asp:Label></font></td>
<td valign="top" width="70%">
<asp:Label ID="lblFax1" runat="server"></asp:Label></td>
<td width="5%"></td>
</tr>
<tr>
<td style="width: 5%"></td>
<td valign="top" style="width:20%;"><font face="Verdana" size="2">
<asp:Label ID="lblEmail" Width="100%" runat="server">Email</asp:Label></font></td>
<td valign="top" width="70%">
<asp:Label ID="lblEmail1" runat="server"></asp:Label></td>
<td width="5%"></td>
</tr>
</table>
<br /><br />
<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" />
</Columns>
<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:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/db1.mdb"
SelectCommand="SELECT [Sno], [Partno], [mfg], [qty], [price] FROM [RfqInfo]"></asp:AccessDataSource>
<br />
<br />
<table border="0" style="width: 100%">
<tr>
<td style="width: 5%"></td>
<td valign="top" style="width:20%;"><font face="Verdana" size="2">
<asp:Label ID="lblComments" Width="100%" runat="server">Comments</asp:Label></font></td>
<td valign="top" width="70%">
<asp:Label ID="lblComments1" runat="server" TextMode="MultiLine"></asp:Label></td>
<td width="5%"></td>
</tr>
<tr>
<td style="width: 5%; height: 26px;"></td>
<td valign="top" style="width:10%; height: 26px;"><font face="Verdana" size="2">
<asp:Button ID="btnSubmit" Width="100%" runat="server" Text="submit" OnClick="btnSubmit_Click"></asp:Button></font></td>
<td width="5%" style="height: 26px"></td>
</tr>
</table>
<asp:Button ID="BtnExport" runat="server" OnClick="BtnExport_Click"
Text="Export to Excel" />
</div>
</form>
|
|
|
|
|
This peace of code works fine for me. I executed that one and is performing well.
Apurva Kaushal
|
|
|
|
|
hmm...but whats wrong from my side:
I executed it again but still the same error persists
here is the error::
Control 'myGridView' of type 'GridView' 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 'myGridView' of type 'GridView' must be placed inside a form tag with runat=server.
Source Error:
Line 63: System.IO.StringWriter stringWrite = new System.IO.StringWriter();
Line 64: System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
Line 65: myGridView.RenderControl(htmlWrite);
Line 66: Response.Write(stringWrite.ToString());
Line 67: Response.End();
|
|
|
|
|
its showing the error at Line 65.
|
|
|
|
|
In order to overcome the error, We have to override the below function.
public override void VerifyRenderingInServerForm(Control control)
{
}
Regards,
Jay
|
|
|
|
|
Cool stuff man... I will rate this...
|
|
|
|
|
Thanks (For Nellai Website Too)
-- modified at 5:45 Wednesday 13th June, 2007
Regards,
Jay
|
|
|
|
|
DKalepu wrote: myGridView.RenderControl(htmlWrite);
You cannot render the GridView Control into HTML directly. Use DataGrid.
May be Jay_se is correct. But I haven't tried that before. We also had this issue before and we solve that using DataGrid. We can used JavaScript get the HTML String of the GridView and do the same.
|
|
|
|
|
Hi,
Venkatesh MookkanYou cannot render the GridView Control into HTML directly.
We Can do Vankat. It works fine too.
Regards,
Jay
|
|
|
|
|
If it works fine, then no problem for me man..
Thanks...
|
|
|
|
|
Hi, Thank you very much for the help Jay..
That piece of code solved my problem.....
Thank you so much once again to all of you for helping on my problem/
|
|
|
|
|
Asp.net
=======
I have master page.
when i redirect to different pages in master page, page refeshes.
is there any why i could do
--> page is redirected.
--> client doesnot feel refresh effect
server.transfer ("filename") gives error
Thank you
vijaya
vijaya
|
|
|
|
|
How to call login page on session timeout,pls send me code for this.
Thank you.
|
|
|
|
|
Redirect the user to the login page using response.redirect method.
Apurva Kaushal
|
|
|
|
|
This is ok,but on which event should i write this code pls reply.
|
|
|
|
|
In the load event of the page you can check for the session and then if it is not available then user should be redirected to login page.
Apurva Kaushal
|
|
|
|
|
Hi,
if(session["LoginName"] == null)
{
response.redirect("Loginpage.aspx");
}
I hope this will help you.
Thanks and Regards,
Chetan Ranpariya
|
|
|
|