ASP.NET

GaryWoodfine 10-Dec-06 22:39

GaryWoodfine

10-Dec-06 22:39

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.

Kind Regards,
Gary

My Website || My Blog

scorpvg10-Dec-06 23:50

scorpvg

10-Dec-06 23:50

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.

GaryWoodfine 11-Dec-06 0:40

GaryWoodfine

11-Dec-06 0:40

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

Kind Regards,
Gary

My Website || My Blog

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=895858&SiteID=1[^]

Vasudevan Deepak Kumar11-Dec-06 4:32

Vasudevan Deepak Kumar

11-Dec-06 4:32

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Asp.net - newbie problem :)

g01dHaCkEr7-Jul-11 19:45

g01dHaCkEr

7-Jul-11 19:45

In case anyone still looks at this old page trying to resolve why they can't quit excel properly, the following StackOverflow question and accepted answer are invaluable in identifying how to properly deal with COM objects:

http://stackoverflow.com/questions/158706/how-to-properly-clean-up-excel-interop-objects-in-c[^]

sub-folders?

il_manti10-Dec-06 22:21

il_manti

10-Dec-06 22:21

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

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

form methods

RoswellNX11-Dec-06 0:10

RoswellNX

11-Dec-06 0:10

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

john3410-Dec-06 21:07

john34

10-Dec-06 21:07

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 Frown | :(

everything just goes in a line and I am not able to drag it. It behaves more like word than a UI designer Frown | :(

Any help would be most appreciated !!! Smile | :)

Thanks Again
John

RoswellNX10-Dec-06 21:23

RoswellNX

10-Dec-06 21:23

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

il_manti10-Dec-06 22:11

il_manti

10-Dec-06 22:11

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

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)

ed^nrgc11-Dec-06 3:25

11-Dec-06 3:25

Choose GridLayout

5150.Net11-Dec-06 9:03

5150.Net

11-Dec-06 9:03

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.

ed^nrgc11-Dec-06 9:08

11-Dec-06 9:08

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.

Re: Server Execution failed

5150.Net11-Dec-06 9:51

5150.Net

11-Dec-06 9:51

yup. I forgot to mention that css is created in the background. Good call!

Andy

Server Execution failed

jhe_boy10-Dec-06 19:16

jhe_boy

10-Dec-06 19:16

what are the causes of these error... Smile | :)

Guffa10-Dec-06 20:22

Guffa

10-Dec-06 20:22

That could be just about anything. What does the rest of the error message say?

---
b { font-weight: normal; }

Re: Server Execution failed

ed^nrgc11-Dec-06 3:18

Server cannot found, DNS error

11-Dec-06 3:18

With the extreme details of your description, it narrowed it down to the point I'm tossing between 2 causes. Sigh | :sigh:

Reg : OLE

venkatasivaramaprasad10-Dec-06 19:15

venkatasivaramaprasad

10-Dec-06 19:15

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

jhe_boy10-Dec-06 19:15

jhe_boy

10-Dec-06 19:15

here is my code at the button click event

System.Threading.Thread.Sleep(3600000)
response.redirect("Somepage.aspx")

Re: Server cannot found, DNS error

ed^nrgc11-Dec-06 3:23