Hello again!

Can someone tell me how can I open a PDF wich I store the path in a Access DB? I'm working with VB in .NET 1.1 .

Thanx in advance.

If you have the path in a DB just use a standard A HREF to link to the file and it will open in IE. If you have the file actually stored in the DB you would do something like this:

        With Page.Response
            .Clear()
            .ContentType = "application/pdf"
            .OutputStream.Write([byteArray], 0, [byteArrayLength])
            .End()
        End With

hth


-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

Thanx for the quick answer, dparsons.

But if I want to get the PDF from a certsin ID, would that work in the same way? Like using in:

...file.aspx?ID=n

or even:

RowView("ID").ToString()

Otherwise I will have to recode...

(hope u undestand my explaining)

On your file.aspx page just do:

SELECT path FROM table WHERE id= Request.QueryString("id")

And then redirect to the path that is returned form the query.

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

OK. I'm getting somewhere...

I've added the
SELECT path FROM table WHERE id= Request.QueryString("id")

parts. I also added this on Page_Load:

   Response.ClearContent()
   Response.ClearHeaders()
   Response.ContentType = "application/pdf" Response.WriteFile(Server.MapPath("pdf-file's-name"))
                     ----------------------------------------
   Response.Flush()
   Response.Close()

And now shall I change the underlined into:

Response.WriteFile(Server.MapPath("field-name"))

??

Please, be patient with me. I'm just starting.

First be aware of this: http://support.microsoft.com/kb/812406

Then do this:

Dim strPath as string = Server.MapPath([path value from database])
Dim file as System.IO.FileInfo = New System.IO.FileInfo(strPath)

If file.Exists then
With Response
     .Clear()
     .AddHeader("Content-Disposition", "attachment; filename=" & file.Name)
     .AddHeader("Content-Length", file.Length.ToString())
     .ContentType = "application/pdf"
     .WriteFile(file.FullName)
     .End

End With
Else
//file doesnt exist
End If

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

But that way (I guess) I have to open a specified PDF and I want to get the corresponding PDF for a certain ID.

Is this correct?

I understand that, you would pass the ID along the query string

file.aspx?id=n

then you would do

SELECT path from table where id=Request.querystring("id")

the value that is returned from that query is what you want to place in the

Dim strPath as string = Server.MapPath([path value from database])



-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

I've tried with

Dim strPath as string = Server.MapPath([FIELD with path value from database])

and I got this:

Could not find a part of the path "c:\inetpub\wwwroot\[FIELD with path value from database]".

Any ideas?

.... the [Field with path value from the database] needs to be the actual value of the path from your database.

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature