 |
 |
Index ‹ Web Programming ‹ Frontpage Client
|
- Previous
- 1
- 2
- ASP.Net >> ASP.NET: Can't Kill EXCEL.exe with Office PIAI have been trying to use the Office PIA's to write an ASP.NEt page to:
1. Open a template workbook
2. Populate some data
3. Save the file back to the server
4. Quit Excel and free up Memory
I have been able to do all of the above steps except #4. Each time
Excel.exe persists in memory. I have already referred to Q317109 "Office
application does not quit after automation from Visual Studio .NET client"
without much luck.
I've tried stripping down the Office code to see where this hang is coming
from exactly and found the following:
WORKS: The following DID release Excel.exe:
Dim xlApp As New Microsoft.Office.Interop.Excel.Application
xlApp.Quit()
System.Runtime.InteropServices.Marshal.ReleaseComObject(xlApp)
xlApp = Nothing
ERROR: When I augment it to the following however, Excel.exe continues to
hang:
Dim xlApp As New Microsoft.Office.Interop.Excel.Application
Dim wkBook As Workbook = xlApp.Workbooks.Open("C:\test.xls")
xlApp.Workbooks.Close()
System.Runtime.InteropServices.Marshal.ReleaseComObject(wkBook)
wkBook = Nothing
xlApp.Quit()
System.Runtime.InteropServices.Marshal.ReleaseComObject(xlApp)
xlApp = Nothing
If anyone could explain why this might be happening, it would be greatly
appreciated. It seems as if as soon as I get into working with a workbook,
Excel.exe is stuck in memory. Rather than a specific fix for the above, I'm
just looking to better understand the dynamics/rules here for avoiding this
problem.
Thanks in advance,
Chris Frohlich
- 3
- IIS >> Can IIS 5 be installed on Win2K3Can anyone tell me if there is a way to install IIS 5 on a Windows Server
2003 edition. We are running Crystal Enterprise 9.0 and they do nto support
IIS 6.
- 4
- ASP.Net >> Label OnDataBindingConsider the following code:
<script runat="server">
Sub ShowData(obj As Object, ea As EventArgs)
lblDate.Text = DateTime.Now.ToString("d")
lblDate.DataBind()
End Sub
</script>
<form runat="server">
<asp:Label ID="lblDate" OnDataBinding="ShowData" runat="server"/>
</form>
But the Label doesn't display the current date. Why?
If I replace the OnDataBinding event with OnInit or OnLoad or
OnPreRender in the Label control, then the Label displays the current
date.
Actually the Form has a DataList as well after the Label control.
Records from a SQL Server 2005 DB table are displayed in the DataList
using SqlDataReader. One of the columns in the DB table is named
'OrderDate' which gets populated with the date (along with the time) on
which a user has placed an order.
I want to display the date on which the order was placed by a
particular customer in the Label control while the DataList should
display the rest of the records existing in the other DB table columns.
To render the order date in the Label, I can use
While (sqlReader.Read)
lblDate.Text = "Your order was placed on " &
sqlReader.GetDateTime(5).ToString("d")
End While
But since SqlDataReader is read-only, even if I do something like this
after the While (SqlReader.Read) code snippet
DataList1.DataSource = sqlReader
DataList1.DataBind()
the DataList won't display the rest of the records. I need to first
display the order date in the Label followed by the rest of the records
in the DataList. How do I accomplish this?
Please note that I want to do this using SqlDataReader only (not
SqlDataAdapter or any other object).
- 5
- ASP.Net >> Cannot migrate Anonymous to registered userHi All,
I have an application which is using memship and profile functions. It works
well in my develop machine which is using SQL Express Edition Server as the
provider.
When I move this application to the hosting server. It works well when the
user is anonymous. But after user logins, the Profile_MigrateAnonymous event
in Global.asax is called when user browses every pages. So even I change the
value in Profile, it keeps getting back the value from the one in anonymous
status.
Can you tell me why it happens? And how can I fix it?
Thanks in advance
-Vincent
- 6
- ASP.Net >> upload word doc in asp.netAs all my users are intranet-based and have the Office package
installed.
I have decided to stream a server-stored document into a web browser,
so that the user can use Microsoft Word to modify the document. (I
don't care if this opens it in the browser or in word itself out of
the browser, as I have seen it depends on a activeX setting).
Now, my problem is to upload the document in the server without too
much hassle for the user (i.e.: he saves it locally, switches to the
web form, clicks on an upload button...)
How can I do that?
- 7
- ASP.Net >> Max. number od users in SQL serverHow many users can access to SQL server at the same time with web aplication
written in C# 2005? What if my database is 1GB and 1000 people access at 1
second - some simple query. My web hosting acc will be
http://www.webhost4life.com or something simmilar!
- 8
- Frontpage Programming >> handling database errors returned to screenWhen using frontpage to query a database and the code comes back in error
(indicating that something was wrong), is there anyway to get around the
result being just the ugly yellow box spelling out the problem in the
database results region of the responding webpage? I'd like to be able to
trap this error and present a page spelling out exactly what occurred versus
this.
Is there a way to do this?
I'm using Frontpage 2002, Windows XP, SQL Server 7.0 as the backend. Just
want this to look much more professional.
Thanks if you can help!
Bob L.
- 9
- ASP.Net >> injecting javascript fails all the time?I have the following code inside of a Wizard_Finish_Button_Click event:
NewsDB NewsHelper = new NewsDB();
if(NewsHelper.AddNews(DateTime.Now, SubjectTextBox.Text, BodyTextBox.Text))
{
StringBuilder PopUp = new StringBuilder();
PopUp.Append("<script language = 'javascript'>");
PopUp.Append("alert('Your news article was added successfully!');<");
PopUp.Append("/script>");
ClientScript.RegisterClientScriptBlock(GetType(), "PopupScript",
PopUp.ToString());
Server.Transfer("index.aspx");
}
else {
StringBuilder PopUp = new StringBuilder();
PopUp.Append("<script language = 'javascript'>");
PopUp.Append("alert('Warning! Couldn't add your news article for some
reason!');<");
PopUp.Append("/script>");
ClientScript.RegisterClientScriptBlock(GetType(), "PopupScript",
PopUp.ToString());
AddNewsWizard.ActiveStepIndex=0; //if adding failed, reset and start over...
}
When the event runs, everything works/fails like expected except for the
javascript part. For some reason it gets ignored. Any way to fix this? I got
my example from
http://dotnetslackers.com/articles/aspnet/JavaScript_with_ASP_NET_2_0_Pages_Part1.aspx
The whole idea was to show a popup saying the add worked if it worked and
show one saying it failed if it failed.
- 10
- ASP.Net >> Event handler not fired after using browser back button bug??? ...or What!!!When I display a page with imagebuttons, clicking on a link fires the event
associated with that link and takes me to the correct page. When I use the
browser back button to go back to the origonal imagebutton page, and press a
different imagebutton, no event is fired and the page for the first
imagebutton loads.
See the problem at:
http://www.site2020.com/PhotoBrowserApp/default.aspx?MediaPath=%2fBy+Event%2f
If I use the "Thumbnail View" button to go back, everything works fine.
If refreash the page after using the browser back button, everything works
fine.
Thanks for your help
Earl
- 11
- ASP/Active Server Pages >> changing a Form VariableThis may sound like a simple question but I really dont' know how to do
this.
I know you can call a Form Variable in a VBscript using
Request.Form("FieldName") and make equal a local variable like:
str = Request.Form("FieldName")
Now if do this:
str = "This is the new value"
How do you make FieldName equal str. So In a sense I want this to happen
FieldName = str
I need this so that when FieldName gets posted to the DB the new value get
sent.
Any ideas?
- 12
- ASP.Net >> Object loaded in Page & UserControl... not sure if i"m doing this right...This is a multi-part message in MIME format.
------=_NextPart_000_0008_01C3F715.6CCB69F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I have a page class that inherits the System.Web.UI.Page class. =
Essentially what it does is load a user profile from a session (if it =
isn't loaded, it loads it into the session) and exposes it via a public =
property. This works just fine.
I have user controls that require the profile as well and I was coding =
it to work in the same way (created a class that inherits the =
System.Web.UI.UserControl class. It does the exact same thing as the =
page class I created.
My question is I'm wondering if I'm doing more owrk than is necessary. =
Can the UserControl see the page object? If it can, what's the =
execution order (would the control execute before the page so the user =
control wouldn't have access to the profile)?
Thanks in advance.
------=_NextPart_000_0008_01C3F715.6CCB69F0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#000080 size=3D2><FONT size=3D2>
<P>I have a page class that inherits the System.Web.UI.Page class. =
Essentially what it does is load a user profile from a session (if it =
isn't=20
loaded, it loads it into the session) and exposes it via a public=20
property. This works just fine.</P>
<P>I have user controls that require the profile as well and I was =
coding it to=20
work in the same way (created a class that inherits the=20
System.Web.UI.UserControl class. It does the exact same thing as =
the page=20
class I created.</P>
<P>My question is I'm wondering if I'm doing more owrk than is =
necessary. =20
Can the UserControl see the page object? If it can, what's the =
execution=20
order (would the control execute before the page so the user control =
wouldn't=20
have access to the profile)?</P>
<P>Thanks in advance.</P></FONT></FONT></DIV></BODY></HTML>
------=_NextPart_000_0008_01C3F715.6CCB69F0--
- 13
- 14
- IIS >> Event Id 7031I am getting the following errors in the system log:
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7031
Date: 6/28/2003
Time: 12:32:43 PM
User: N/A
Computer: MTFREXCH
Description:
The IIS Admin Service service terminated unexpectedly. It
has done this 10 time(s). The following corrective action
will be taken in 0 milliseconds: No action.
I can't find any answers or solutions to this, I have to
restart the IIS services all the time. Please help
- 15
- ASP.Net >> 2.0: enableviewstateHere is an interesting one. If I disable viewstate in the web.config file,
but enable it on a specific page, it doesnt save the viewstate on postbacks.
I have to actually enable it in web.config.
Thanks!
|
| Author |
Message |
afortn

|
Frontpage Client >> Subdomain in Frontpage
I am in the process of buying a SSL certificate and I thought that having an
address like https://secure.mysite.com would look more safe for customers. So
I created the secure.mysite.com subdomain on the web server. I opened it in
Frontpage. But now the navigation structure and bar in www.mysite.com don't
exist anymore in secure.mysite.com . I guess it would be better to recreate
it, how can I do that?
Web Programming45
|
| |
|
| |
 |
| |
 |
Index ‹ Web Programming ‹ Frontpage Client |
- Next
- 1
- Frontpage Client >> No thumbnail view when inserting picture?Hello, Please excuse me for I don't use FP often enough to be sure of this
but I could bet that when I went to "insert picture" before and scrolled
through my jpgs that I was able to get "thumbnail" view. Now all I have is
details, preview, large icon, small icon. If I go to windows explorer alone I
can have any view including thumbnail. Is there something suddenly wrong
with my Front Page program (FP2002) thanks, Catt
- 2
- Frontpage Client >> HELPA lady designed our layout for us and so the images I need to link are part
of the background.. How can I link them? you can view our site here..
www.columbusscrappers.org
- 3
- ASP/Active Server Pages >> Problem generating MD5 hash from asp classic like .NETI need to generate an MD5 hash in ASP, not ASP.NET, and have that hash be
the same as what is produced by the .NET MD5CryptoServiceProvider.
This is the vb.net code I am using...
Function GenerateMD5Hash(ByVal SourceText As String) As String
'Create an encoding object to ensure the encoding standard for the
source text
Dim Ue As New UnicodeEncoding
'Retrieve a byte array based on the source text
Dim ByteSourceText() As Byte = Ue.GetBytes(SourceText)
'Instantiate an MD5 Provider object
Dim Md5 As New MD5CryptoServiceProvider
'Compute the hash value from the source
Dim ByteHash() As Byte = Md5.ComputeHash(ByteSourceText)
'And convert it to String format for return
MsgBox(System.Text.ASCIIEncoding.ASCII.GetString(ByteHash))
Return Convert.ToBase64String(ByteHash)
End Function
Thanks in advance!
William Showers
- 4
- ASP.Net >> How is web.config cached, to memory or disk?MS docs say that the web.config information is cached? Where?...to memory or
disk or both as part of LRU? Is this cache mechanism controllable...e.g. if
it is part of a least recently used algorithm and then it is written to disk
can this be overridden? Any article links would be appreciated.
Thanks,
Gery
--
Gery D. Dorazio
Development Engineer
EnQue Corporation
1334 Queens Road
Charlotte, NC 28207
(704) 377-3327
- 5
- IIS >> Reverse Proxy?I have an inhouse web application listening on port 8081 and I'd like to
have this made available to the public (i.e. users outside my firewall) but
I don't want it to be accessed directly. If possible, I'd like IIS (that I
use to serve other content to the public - corporate website etc) to act as
a sort of "reverse proxy" so as the users don't actually access this my web
application on port 8081 directly.
A simple redirect in IIS won't work because the URL gets changed.
I know that Apache can do this very easily, but is it possible to do this
sort of thing with IIS or do I need to use something else?
thanks if you can help.
--
- 6
- ASP/Active Server Pages >> ASP circular dependencyOn a server W2K, IIS5, I have many messages from ASP :
cirdular dependency between types/modules. Which can be
the origin of the problem?
Example :
Event Type: Warning
Event Source: Active Server Pages
Event Category: None
Event ID: 9
Date: 09/07/2004
Time: 09:29:25
User: N/A
Computer: xxxxx
Description:
Warning: File /Include/Connexion/OuvreConnexion.asp Line 3
Circular dependency between types/modules.
. .
For additional information specific to this message please
visit the Microsoft Online Support site located at:
http://www.microsoft.com/contentredirect.asp.
Event Type: Warning
Event Source: Active Server Pages
Event Category: None
Event ID: 9
Date: 09/07/2004
Time: 09:29:08
User: N/A
Computer: xxxxx
Description:
Warning: File
d:\yyyy\INFODOC\CONSULTATION\ACCUEIL\../Include/Connexion/O
uvreConnexion.asp Line 3 Circular dependency between
types/modules.
. .
For additional information specific to this message please
visit the Microsoft Online Support site located at:
http://www.microsoft.com/contentredirect.asp.
- 7
- Frontpage Client >> Pub data from Access or Excel via FP?I use FP 2003 to publish a uncomplicated, modest sized web site on Comcast
here in the S.F. Bay Area based around my SCUBA diving and UW Photography
hobbies. Comcast provides limited FP extension support but no CGI.
I used to use an early version of NetObjects Fusion when I had the site
hosted with Compuserve years ago. Fusion allowed me to create simple flat
file databases (6 or 7 fields per record) and use them to publish my dive
logs to the site so a visitor could go to one page and flip through the
details of each dive quite elegantly.
I see no way, save hosting on a CGI supported site and me learning LOTS more
about web publishing than I have time for, to duplicate this capability.
Can anyone suggest a way I could either use Excel or Access data accessed by
FP to do this or some other technique to simulate this? If you'd like to see
the data you can go to:
http://home.comcast.net/~tb0yd/lc_2003.htm
... and see where I've typed in the log data in a long text page. Yes, it
works but is not as nice as the 'clink to go to the next dive' arrangement
I'd had previously.
Thanks for any suggestions,
Tim
- 8
- 9
- 10
- ASP.Net >> Different MD5 hashes in .NET and Classic ASPI am running a system that has both Classic ASP applications and a
smattering of ASP.NET applications. We want to store passwords on a SQL
Server table as their MD5 hashes.
What is the safest way to get this hash value, and be able to verify it
against user logins in both Classic ASP and ASP.NET?
We have been working with the system.security.cryptopgraphy MD5
functions in .NET, and the functions here for Classic ASP
http://rossm.net/Electronics/Computers/Software/ASP/MD5.htm
We cannot seem to get the hashes to match up between platforms, even
after taking other forum posts into consideration, such as making sure
we are using UTF-8 encoding and such.
Would it be possible to create a web service in .NET that would return
the correct hashes on both platforms? We're new to .NET, so any sample
code or links to something similar in action would be great! Thank you.
- 11
- Frontpage Client >> how do I add google analytics code to my web pages?I'm trying to use google analytics with my frontpage site. Googles
instructions are to add the code right before the </body> tag. On my
template.dwt, I created an "editable region" right before the closing body
tag, and inserted the analytics code there.
I keep getting an error message saying something (the code) on the web page
couldn't be parsed, and the code is not showing up when I check in "View
Source"
Any ideas or suggestions?
Thank you
- 12
- ASP.Net >> Silly question about XHTMLI think I'm having a dim day and should just go back to bed, but alas, I cant
do that....
I'm writing a peice of code to create XHTML compliant documents using
System.IO, there's probably an easier way but anyway... my code works fine,
and it saves a file as an XML file. If I load this in IE, I get the xml
code!! (rather than the page it should generate). If I rename the file to
.xhtml, IE wont load it and I get the "choose program/service" dialog.
What am I doing wrong!?
Cheers, Dan.
Here's the generated xhtml..
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>Test XHTML Page</title>
<link rel="stylesheet" type="text/css" href="test.css" />
</head>
</html>
---------------------------------------------
- 13
- Frontpage Client >> select all help with DRWHi
I have a search form created by the DRW with a text boxes and drop down
boxes in the drop boxes when I want to include all in the search I put %
in the first value field. but the text box has this in the value field
<%=Server.HtmlEncode(Request("Project_ID"))%>
how do I fix it so that if I put nothing in project ID field it ignores it
and moves on to the next field
At the moment I get a database error untill a value is typed into the text
box
Thanks
Paul M
- 14
- ASP/Active Server Pages >> Handling checkboxes, a question of style?Hi all,
I have an edit form for records that belong to numerous categories. Records
are joined to categories with a join table in a many-to-many relationship.
When displaying a record for editing I loop through the category recordset,
looping through the entire join-table recordset for each category, to tick
(or not) each checkbox as it's displayed.
This seems like a costly way of populating checkboxes.
Is there a more elegant solution?
--
Sean.
- 15
- ASP.Net >> html email with embedded imagesHi,
I know how to send emails from the .Net environment, even html mails.
But, what is the best way to add images to the html?
A URL to an image somewhere on some server is usually blocked nowadays,
so you need to send the image as attachment. I had some success when I
used the filename (without path) of the attachment as img-src.
Is that the only way or are there better methods?
A related question: some of these images might be stored in the database
or generated "on the fly", but the MailAttachment class uses filenames.
Is there any way to attach some document *without* storing it first?
If not, can I safely delete that temporary file directly after I send the
email to the server?
Hans Kesting
|
|
|