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.Binar yReader(crRepor t.ExportToStrea m(CrystalDecisi ons.[Shared].ExportFormatTy pe.PortableDocF ormat))

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

Dim writer As New IO.BinaryWriter (fs)
writer.Write(st rStream.ReadByt es(strStream.Ba seStream.Length ))
writer.Flush()
writer.Close()

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

and to delete I simply

File.Delete(fil ePath)
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.Bin aryReader(crRep ort.ExportToStr eam(CrystalDeci sions.[Sha
DLred].ExportFormatTy pe.PortableDocF ormat))
DL>
DLDim fileName As String = "WO-" & Request("woid") &
DL".pdf"
DLDim fs As FileStream = File.Create("c: \temp\" &
DLfileName,
DLstrStream.Bas eStream.Length)
DLDim writer As New IO.BinaryWriter (fs)
DL>
DLwriter.Write( strStream.ReadB ytes(strStream. BaseStream.Leng th))
DLwriter.Flush( )
DLwriter.Close( )
DLfs.Dispose()
DLfs.Close()
DLstrStream.Clo se()
DLcrReport.Clos e()
DLand to delete I simply
DL>
DLFile.Delete(f ilePath)
DL>
DLThanks a million!
DLDavid Lozzi

[vMike]

"David Lozzi" <dl****@nospam. nospamwrote in message
news:D1******** *************** ***********@mic rosoft.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.Binar yReader(crRepor t.ExportToStrea m(CrystalDecisi ons.[Shared].ExportFormatTy pe.PortableDocF ormat))

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

Dim writer As New IO.BinaryWriter (fs)
writer.Write(st rStream.ReadByt es(strStream.Ba seStream.Length ))
writer.Flush()
writer.Close()

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

and to delete I simply

File.Delete(fil ePath)
Thanks a million!
David Lozzi

In your email sending code call the attachments dispose method

yourMailMessage .attachments.di spose()

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.micr osoft.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************ @5nerrawgenospa m.comwrote in message
news:ZZ******** **********@bign ews8.bellsouth. net...

>
"David Lozzi" <dl****@nospam. nospamwrote in message
news:D1******** *************** ***********@mic rosoft.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.Bina ryReader(crRepo rt.ExportToStre am(CrystalDecis ions.[Shared].ExportFormatTy pe.PortableDocF ormat))

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

Dim writer As New IO.BinaryWriter (fs)
writer.Write(st rStream.ReadByt es(strStream.Ba seStream.Length ))
writer.Flush()
writer.Close()

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

and to delete I simply

File.Delete(fil ePath)
Thanks a million!
David Lozzi

In your email sending code call the attachments dispose method

yourMailMessage .attachments.di spose()

Mike