Cannot access file after writing it!

[David Lozzi]

Howdy,

I am using ASP.Net 2.0 and Crystal Reports in VS 2005. I am taking a report,
converting it to PDF then writing it out to a folder. Then I attach this
file to an email and send it off. Once it's sent, I then want to delete the
file from the folder, and here lies the issue. When i try to delete it I get
an error stating the file is being used by another process.

Here's the code to create the file

Dim strStream As New
System.IO.BinaryReader(crReport.ExportToStream(Cry stalDecisions.[Shared].ExportFormatType.PortableDocFormat))

Dim fileName As String = "WO-" & Request("woid") & ".pdf"
Dim fs As FileStream = File.Create("c:\temp\" & fileName,
strStream.BaseStream.Length)

Dim writer As New IO.BinaryWriter(fs)
writer.Write(strStream.ReadBytes(strStream.BaseStr eam.Length))
writer.Flush()
writer.Close()

fs.Dispose()
fs.Close()
strStream.Close()
crReport.Close()

and to delete I simply

File.Delete(filePath)
Thanks a million!
David Lozzi

[Alex Meleta]

Hi David,

Then I attach this file to an email and send it off.

As suggestion: try to obtain what locks your file (e.g. by using process
explorer http://www.sysinternals.com/ntw2k/fr...procexp.shtml). May be
mailer has not been freeing it.

Regards, Alex Meleta
[TechBlog] http://devkids.blogspot.com

[Alex Meleta]

Hi David,

PS. Also it's a good way to use "using statement" for disposable objects
to be sure that object will be freed.

Using cn As Dim fs As FileStream = File.Create
// do something
End Using

Regards, Alex Meleta
[TechBlog] http://devkids.blogspot.com

DLHowdy,
DL>
DLI am using ASP.Net 2.0 and Crystal Reports in VS 2005. I am taking a
DLreport, converting it to PDF then writing it out to a folder. Then I
DLattach this file to an email and send it off. Once it's sent, I then
DLwant to delete the file from the folder, and here lies the issue.
DLWhen i try to delete it I get an error stating the file is being
DLused by another process.
DL>
DLHere's the code to create the file
DL>
DLDim strStream As New
DLSystem.IO.BinaryReader(crReport.ExportToStream(C rystalDecisions.[Sha
DLred].ExportFormatType.PortableDocFormat))
DL>
DLDim fileName As String = "WO-" & Request("woid") &
DL".pdf"
DLDim fs As FileStream = File.Create("c:\temp\" &
DLfileName,
DLstrStream.BaseStream.Length)
DLDim writer As New IO.BinaryWriter(fs)
DL>
DLwriter.Write(strStream.ReadBytes(strStream.BaseS tream.Length))
DLwriter.Flush()
DLwriter.Close()
DLfs.Dispose()
DLfs.Close()
DLstrStream.Close()
DLcrReport.Close()
DLand to delete I simply
DL>
DLFile.Delete(filePath)
DL>
DLThanks a million!
DLDavid Lozzi

[vMike]

"David Lozzi" <dl****@nospam.nospamwrote in message
news:D1**********************************@microsof t.com...

Howdy,

I am using ASP.Net 2.0 and Crystal Reports in VS 2005. I am taking a
report, converting it to PDF then writing it out to a folder. Then I
attach this file to an email and send it off. Once it's sent, I then want
to delete the file from the folder, and here lies the issue. When i try to
delete it I get an error stating the file is being used by another
process.

Here's the code to create the file

Dim strStream As New
System.IO.BinaryReader(crReport.ExportToStream(Cry stalDecisions.[Shared].ExportFormatType.PortableDocFormat))

Dim fileName As String = "WO-" & Request("woid") & ".pdf"
Dim fs As FileStream = File.Create("c:\temp\" & fileName,
strStream.BaseStream.Length)

Dim writer As New IO.BinaryWriter(fs)
writer.Write(strStream.ReadBytes(strStream.BaseStr eam.Length))
writer.Flush()
writer.Close()

fs.Dispose()
fs.Close()
strStream.Close()
crReport.Close()

and to delete I simply

File.Delete(filePath)
Thanks a million!
David Lozzi

In your email sending code call the attachments dispose method

yourMailMessage.attachments.dispose()

Mike

[David Lozzi]

Man, I keep forgetting about that little tool. I hope it's available for
Vista!
"Alex Meleta" <am*****@gmail.comwrote in message
news:15**************************@msnews.microsoft .com...

Hi David,

>Then I attach this file to an email and send it off.

As suggestion: try to obtain what locks your file (e.g. by using process
explorer http://www.sysinternals.com/ntw2k/fr...procexp.shtml). May be
mailer has not been freeing it.

Regards, Alex Meleta
[TechBlog] http://devkids.blogspot.com

[David Lozzi]

Can I have your love child? That worked. Another dev and I have been chasing
down the stupid filestream object and what not and it was the stupid
message.... Thank you for your generousity and time!

David Lozzi

"vMike" <Mi************@5nerrawgenospam.comwrote in message
news:ZZ******************@bignews8.bellsouth.net.. .

>
"David Lozzi" <dl****@nospam.nospamwrote in message
news:D1**********************************@microsof t.com...

>Howdy,

I am using ASP.Net 2.0 and Crystal Reports in VS 2005. I am taking a
report, converting it to PDF then writing it out to a folder. Then I
attach this file to an email and send it off. Once it's sent, I then want
to delete the file from the folder, and here lies the issue. When i try
to delete it I get an error stating the file is being used by another
process.

Here's the code to create the file

Dim strStream As New
System.IO.BinaryReader(crReport.ExportToStream(Cr ystalDecisions.[Shared].ExportFormatType.PortableDocFormat))

Dim fileName As String = "WO-" & Request("woid") & ".pdf"
Dim fs As FileStream = File.Create("c:\temp\" & fileName,
strStream.BaseStream.Length)

Dim writer As New IO.BinaryWriter(fs)
writer.Write(strStream.ReadBytes(strStream.BaseStr eam.Length))
writer.Flush()
writer.Close()

fs.Dispose()
fs.Close()
strStream.Close()
crReport.Close()

and to delete I simply

File.Delete(filePath)
Thanks a million!
David Lozzi

In your email sending code call the attachments dispose method

yourMailMessage.attachments.dispose()

Mike