|
hi all,
I'm using Microsoft Excel Object library 11.0 to create an Excel sheet, write some values and read it to send it to the client side. I'm closing the Excel application using Excel.Quit(), but it still resides in the TaskManager, occupying 7000K+ memory. For each request, more such objects are created, and doesn't terminate. Anybody got some suggestions??
Important
|
|
|
|
|
This is a known issue, this is why using Office automation on the server is not recommended. check out this link.
http://support.microsoft.com/kb/257757
You may have to write a little utility that will go an clear up the Excel objects, or alternatively you can take a look at Office 2007, that I believe will be able to be used in automation on the server.
|
|
|
|
|
Hi Gary,
Thank you for your valuable reply. I tried to clear up the excel objects after closing them, but nothing seems to work. I used system.Runtime.InteropServices.Marshal.ReleaseComObject(<excelobject>) for this, but no use. Could you please give me any hints on clearing up these resident objects? That would be of immense help to me..
Regards,
Vigith.
|
|
|
|
|
Unfortunately I have nothing to hand at the minute, and my laptop is in London at the moment and I am in Dublin, so I won't be able to get my code till about 2 weeks.
Sorry for this, but I will try rack my memory for something for you.
Regards,
Gary
|
|
|
|
|
|
|
hi.
i am a web development student and would like to put some of what i have learnt to good use. i'm thinking a photography portfolio on the lines of http://www.deviantart.com (i'm not looking to compete but to practice). now i find it easy to code this using queries in the address bar (such as: www.someip.com/view.aspx?user=manti in order to view the user page of "manti") but i would like something more challenging... something like www.someip.com/manti -- thinking along the lines of myspace here.
but i have no idea how i should go around this! what i have thought about was:
a. user registers with username "manti"
b. new sub-folder in the web's directory called "manti" (this can be accessed through the web using www.someip.com/manti)
c. copy a default default.aspx page which is filled at runtime by the server with code-behind to show all required information (such as gallery or whatever) into the new subfolder
is this a good way of doing it? any better ones? i'm open to suggestions.
PS: my biggest problem here is: the code behind will still need what username i am viewing in order to retrieve the data from the database (something like getImageList(username)). how can i read the username with my method -- or yours  -- since it's not in the address bar as a query?
Thanks a lot for your time,
m4nti
==========
In life truth does not matter. What really matters is what others believe to be the truth. (The Up and Comer - Book)
|
|
|
|
|
il_manti wrote: PS: my biggest problem here is: the code behind will still need what username i am viewing in order to retrieve the data from the database (something like getImageList(username)). how can i read the username with my method -- or yours -- since it's not in the address bar as a query?
The form method you are familiar with is called "get", where the browser passes the variable data along by appending a '?' followed by the variable name, an '=' and the variable data to the target url. Multiple variables are seperated by an ampersand (&).
i.e. user_reply.asp?forumid=12076&main=/script/comments/forums.asp&select=1798826
It's a quick way to pass information and the model also allows you to create dynamic links (which you will no doubt need in your project).
Another method you might remember or have seen at least once is "post". Post is often used to transmit more sensitive information such as login names and passwords, birthdates and credit card information which should not be visible to the user. It is adviseable to use this method when working with a secure connection, or when transmitting a large string such as this paragraph. It may also help prevent SQL injection.
A variable passed using "post" is not displayed in the url, but may be used in much the same way. If you are looking for a cleaner look you may use this method, but you should also consider the fact that you must balance functionality and SEO. Search engines might not be able to effectively crawl a site that uses a "post" form method as a means of navigation, unless you include an xml sitemap that is constantly updated as new directories are created.
Roswell
"Angelinos -- excuse me. There will be civility today."
Antonio VillaRaigosa
City Mayor, Los Angeles, CA
|
|
|
|
|
Hi all,
Just wondering if you could help me with a newbie problem !
I have opened up asp.net 2.0 found the design screen and added a button – so far so good !
However I cannot position the button where I want it  everything just goes in a line and I am not able to drag it. It behaves more like word than a UI designer
Any help would be most appreciated !!! 
Thanks Again
John
|
|
|
|
|
if you are building a web application the solution would be to create a table for all your elements, so the placement would be handled by html, or a less newbie-friendly solution would be CSS...
so basically it's like
<table>
<tr>
<td>
<asp:button id="ButtonID" runat="server" Text="ButtonText"></asp:button>
</td>
</tr>
</table>
Roswell
"Angelinos -- excuse me. There will be civility today."Antonio VillaRaigosa City Mayor, Los Angeles, CA
|
|
|
|
|
this is how things actually work in web design. you are seeing it strange because you've probably been accustomed to the "grid-like" structure of UI design. in HTML if you're going to put something it's going to find itself on the top right corner of the screen. simple. this is how it's supposed to work. the first time i saw it i was just like you ... "wdf is going on?! this is stupid...". but then, you know, it's how it's always been in html!
of course you can go about this in different ways:
a. create a table as described above and set everything up in different cells (kinda recommended).
b. css. and divs. very powerful. you can give absolute positioning in x,y co-ordinates (but not recommended) or you can set them up with padding percentages, margins, etc (highly recommended). look it up 
c. you could choose the "page layout" property and change it to "GridLayout" instead of "FlowLayout" (but... i still recommend the divs together with css if you're really into good and clean web design)
>>>>>
In life truth does not matter. What really matters is what others believe to be the truth. (The Up and Comer - Book)
|
|
|
|
|
|
In asp.net 1.1, you could actually position things around the form just like a windows form. I think that's removed with 2.0 though.
I personally use css for all my presentation stuff but for newbs ( and a lot of pro's ), table layout is just as good. I'd say use tables for your layout until you get a handle of the behavior of html. Then, pick up a book by Eric Miers ( Css something ). He's a GREAT author on css.
Good luck with it all!
Thanks for firing me Darrell Eaker of Ringgold Telephone Company. I TRIPLED my salary and don't have to deal with douchebags like you.
|
|
|
|
|
I agree that book is great. For the record, it's still there in 2.0. Just not as obvious as it was. In fact, grid layout is just an automated way of creating CSS.
|
|
|
|
|
yup. I forgot to mention that css is created in the background. Good call!
Andy
|
|
|
|
|
what are the causes of these error...
|
|
|
|
|
That could be just about anything. What does the rest of the error message say?
---
b { font-weight: normal; }
|
|
|
|
|
With the extreme details of your description, it narrowed it down to the point I'm tossing between 2 causes. 
|
|
|
|
|
Hi,
I dont know whether it is a right forum to discuss. But please give me some note on it.
How can we achieve OLE (Obect Linking and Embedding) Concept in .Net.
If any body having idea please let me know. Thanks in advance
Thanks and Regards
Venkat
|
|
|
|
|
here is my code at the button click event
System.Threading.Thread.Sleep(3600000)
response.redirect("Somepage.aspx")
|
|
|
|
|
So, you expect to not get an error after a few hours?
|
|
|
|
|
how to embed a flash (myFile.swf) into my ASP.net Web page
|
|
|
|
|
You'll probably want to further customize it:
<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,0,0" width="640" height="640" id="myFile" align="left">
<param name="allowScriptAccess" value="sameDomain" />
<param name="movie" value="myFile.swf" />
<param name="loop" value="false" />
<param name="quality" value="best" />
<param name="bgcolor" value="#ffffff" />
<embed src="myFile.swf" quality="best" bgcolor="#ffffff" width="640" height="640" name="myFile" align="left" allowScriptAccess="sameDomain" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" />
|
|
|
|
|
|
hi friends
i have problem in c#.
my code is.
if (e.Row.RowType == ListItemType.Item || e.Row.RowType == ListItemType.AlternatingItem)<br />
{<br />
}
proble is
CS0019: Operator '==' cannot be applied to operands of type 'System.Web.UI.WebControls.DataControlRowType' and 'System.Web.UI.WebControls.ListItemType'
Pathan
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
