«

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

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

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



DL> Howdy,
DL>
DL> I am using ASP.Net 2.0 and Crystal Reports in VS 2005. I am taking a
DL> report, converting it to PDF then writing it out to a folder. Then I
DL> attach this file to an email and send it off. Once it's sent, I then
DL> want to delete the file from the folder, and here lies the issue.
DL> When i try to delete it I get an error stating the file is being
DL> used by another process.
DL>
DL> Here's the code to create the file
DL>
DL> Dim strStream As New
DL> System.IO.BinaryReader(crReport.ExportToStream(Cry stalDecisions.[Sha
DL> red].ExportFormatType.PortableDocFormat))
DL>
DL> Dim fileName As String = "WO-" & Request("woid") &
DL> ".pdf"
DL> Dim fs As FileStream = File.Create("c:\temp\" &
DL> fileName,
DL> strStream.BaseStream.Length)
DL> Dim writer As New IO.BinaryWriter(fs)
DL>
DL> writer.Write(strStream.ReadBytes(strStream.BaseStr eam.Length))
DL> writer.Flush()
DL> writer.Close()
DL> fs.Dispose()
DL> fs.Close()
DL> strStream.Close()
DL> crReport.Close()
DL> and to delete I simply
DL>
DL> File.Delete(filePath)
DL>
DL> Thanks a million!
DL> David Lozz

"David Lozzi" <> wrote in message
news195832B-6C1A-47ED-941E-...
> 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

Man, I keep forgetting about that little tool. I hope it's available for
Vista!


"Alex Meleta" <> wrote in message
news: .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
>
>

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" <> wrote in message
news:ZZNki.20972$.. .
>
> "David Lozzi" <> wrote in message
> news195832B-6C1A-47ED-941E-...
>> 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
>
>