|
Hi guys, recently we have migrated our server to use IIS 6.0 and ASP.NET 2.0
After running the web application, I found that after I have downloaded a report in Excel, the
macro attached to it no longer exists- as if it has not been attached to the Excel file.
Can you help me find the cause and solution to this issue?
Here is the code:
private void GetReport(IList regionList, IList subregionList, IList plantList, IList categoryList, IList platformList, IList measureList)<br />
{<br />
string VirtualPath = Request.Path.Substring(0,Request.Path.LastIndexOf("/")+1 );<br />
<br />
Response.Charset = string.Empty; <br />
StringWriter tw = new StringWriter();<br />
HtmlTextWriter hw = new HtmlTextWriter(tw);<br />
Response.ContentType = "application/vnd.ms-excel";<br />
Response.AddHeader("Content-Disposition", "attachment;filename=" + "report.xls");<br />
<br />
hw.Write("<html xmlns:x=\"urn:schemas-microsoft-com:office:excel\"><head>");<br />
hw.Write("<meta http-equiv=Content-Type content=\"text/html;charset=windows-1252\">");<br />
hw.Write("<meta name=ProgId content=Excel.Sheet>");<br />
hw.Write("<meta name=Generator content=\"Microsoft Excel 10\">");<br />
if(ddlYear.SelectedValue != "2006")<br />
hw.Write("<link rel=Edit-Time-Data href=\"http://" + Request.Url.Host + VirtualPath +"macros/macro.mso\">");<br />
else<br />
hw.Write("<link rel=Edit-Time-Data href=\"http://" + Request.Url.Host + VirtualPath +"macros/macro_2006.mso\">");<br />
hw.Write(GetStyles());<br />
hw.Write("</head><body>");<br />
GetTable(regionList, subregionList, plantList, categoryList, platformList, measureList).RenderControl(hw);<br />
hw.Write("</body></html>");<br />
Response.Write(tw.ToString());<br />
<br />
hw.Close();<br />
tw.Close();<br />
<br />
Response.End();<br />
}
Notes:
I displayed the path of the macros in the web page and it is correct.
So there is nothing wrong with the path.
I figured it must be something with ASP.NET 2.0. Maybe it does not recognize
the script for attaching macros to Excel anymore?
|
|
|
|
|
Need help on this:
I just formatted my pc and installed all needed to run an intranet. But when I started to setup my old intranet site, and run the default page, appeared on my default page. It's a redirection to another page but the default page was totally blank and an error appeared on the bottom left corner saying "Error: Expected ';'" but the line errors are not found on the code: The code of the default page is below: I hate this because i really don't do coding on the format.
<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="iso-8859-1" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDb" %>
<script runat="server">
Sub Page_Load(Sender as Object, E as EventArgs)
response.Redirect("pages/default.aspx")
End Sub
Need help please..
-bryan
--- If the facts don't fit the Theory, change the facts...
|
|
|
|
|
try it  might work
<div class="ForumSig"><font color=gray >Thanks and Regards</font>
<b> Sandeep </b>
<font color=blue style="font-style:italic;" >If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
</font>
</div>
|
|
|
|
|
Hi Sandeep,
The error sign disappeared but it did not redirect to the default page inside the "pages" folder.
regards
bryan
--- If the facts don't fit the Theory, change the facts...
|
|
|
|
|
try this
Response.redirect("../pages/Default.aspx");
check the caps of url
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
try this...it may work...
Response.Redirect("/pages/default.aspx")
Regards
J O H N ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
"Even eagles need a push." David McNally
|
|
|
|
|
hi John,
It doesn't work either... i really hate doing this code without using codebehind... i'm just debugging this intranet...
regards
bryan
--- If the facts don't fit the Theory, change the facts...
|
|
|
|
|
Is the address in your browser address window that of the this page or the one redirected to?
There is no reason, as far as your ocde is concerned, why it shouldn't redirect (though the imports are unnecessary, as are the ContentType and ResponseEncoding attributes in the page directive, but never mind...) so the error must lie elsewhere...
Fred
|
|
|
|
|
the address was on the page where it is blank. http://localhost/sitename/default.aspx <--- this one. It should redirect to this page http://localhost/sitename/pages/default.aspx
yeah.. i'm really pissed off looking where would the error be... it should redirect on the first place. During the installation, I installed the .Net Framework first than the IIS? does it makes sense that it IIS should have been installed first than the Framework?
regards,
bryan
--- If the facts don't fit the Theory, change the facts...
|
|
|
|
|
|
i have designed one Web user control say there is button1 and button2(both button1 and button2 are visible true here).I also have taken two Web Forms say Form1 and Form. In these both forms, i want to use the Web user control i have mentioned above.But in form1, i want button1 visible true and button2 visible false.Similary in form2, i want button1 visible false and button2 visible true. Is it possible to do that using one web user control ? Or should i have to take seperate web user control ?? Currently i am using Dot Net 2005.
suchitamanandhar@hotmail.com
|
|
|
|
|
Yes you can have single form for the both depending on requirement you change the Page Rules.
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
If I understand your question correctly, the answer is yes, you can implement that in a single webusercontrol. On your webusercontrol (the one that contains button1 and button2), you need to provide a public property to get/set the Visible property of the buttons. For example to have a publicly-accessible Visible property of button1, you may provide this code in your webusercontrol's codebehind:
<br />
public bool ButtonOneVisible<br />
{<br />
get{return button1.Visible;}<br />
set{button1.Visible = value;}<br />
}<br />
You can provide similar approach for button2.
Now, on Form1's codebehind, you only need to set the value of this property to true/false depending on your need. For example, on the codebehind of Form1.aspx:
<br />
protected void Page_Load(object sender, EventArgs e)<br />
{<br />
if (!IsPostBack)<br />
{<br />
WebUserControl1.ButtonOneVisible = true;<br />
WebUserControl1.ButtonTwoVisible = false;<br />
}<br />
}
[http://www.theunix.info/sheijin]
Remember, your work is not yours alone. Somewhere, there are some codes written by others amongst us that depends on your work. By failing to see that you are part of their ecosystem, you are bound to break their code.
|
|
|
|
|
"Randz" answered what i was gng to write.
Thats the best way for doing the required job.
BUt i hope u understand the consequence of making a control's (visible=false), setting this property to false "stops" a control being rendered. That is, it wont be available to client side (javascript also).
|
|
|
|
|
that is true. thanks for the emphasis.
[http://www.theunix.info/sheijin]
Remember, your work is not yours alone. Somewhere, there are some codes written by others amongst us that depends on your work. By failing to see that you are part of their ecosystem, you are bound to break their code.
|
|
|
|
|
Hello friends I want to embed a datalist inside other.I want to fill first datalist by category id and fill another datalist by productid for that particular category id.First datalist is filled correctly by category id. But how to assign datasource to second datalist depending upon category id.
|
|
|
|
|
Hi
You have to write a function and under which u have to find the nested
datalist using find method then u can use datasource property of second
datalist like.
Sub NestedBind(ByVal sender As System.Object, ByVal e As DataGridItemEventArgs)<br />
If (e.Item.ItemType = ListItemType.Item Or e.Item.ItemType = ListItemType.AlternatingItem) Then<br />
CType(e.Item.FindControl("dgridTopic"), DataGrid).DataSource = CType(e.Item.DataItem, DataRowView).CreateChildView("DPItem1")<br />
CType(e.Item.FindControl("dgridTopic"), DataGrid).DataBind()<br />
<br />
End If<br />
<br />
End Sub
and u have to call this procedure on itembound event of first datalist.
Rahul
|
|
|
|
|
Thank u Rahul Its working ........
|
|
|
|
|
|
Hi i need tool tip for each items in combobox(HTML Control)...,
Urgent need...,
Plz help me,
Regards,
Magi
|
|
|
|
|
Hello..
I understand that u need a tooltipe for "each" item in the comboBox.
Thats not possible dear, u may do it by some work around like placing a with multiple textbox, one for each item. and making div behave as comboBox.
Even i required the same functionality, but cudnt find any way out. Please post me updated if you get some better answer/solution.
Regards.
|
|
|
|
|
Hi all,
I need to Update and delete a row in datagrid control. Can anyone tell me how do to this.
I just need to show all the records from Database in the GridView and when
I say edit it should show the edited record in GridView but should not be updated in database.
Please help me with this.
Thanks in advance.
|
|
|
|
|
What class you have written for that editing and updating the records.
SSK.
|
|
|
|
|
Check this url here you will have all the articles related to Gridview
http://gridviewguy.com/CategoryDetails.aspx?categoryID=7[^]
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
I dont have any idea in Asp.Net 2.0.
But in Asp.Net 1.1 in the grid you have to add the button column where Update and Delete button will be available and you can add textboxes to the appropriate column which should be updated.
VanithaVasu
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
