can you please explain to me as why i am still not seeing an image when i export to pdf using the following method
Dim filename As String
Dim folder As String
Dim empid As Int16
empid = Request.QueryString("empid")
folder = Request.QueryString("rtype")
filename = "docs/" + folder + "/" + Request.QueryString("prob").ToString() + ".pdf"
Dim cmd As New OracleCommand
Dim cn As New OracleConnection(ConfigurationManager.ConnectionStrings("EMIS").ConnectionString.ToString())
cmd.Connection = cn
cmd.CommandText = "INSERT INTO WEB_RESOURCE_PROB_LETTERBANK ( PERSONAL_ID, LETTER_ID,AUTH_USER ,PROBATION_ID,FILENAME,LONGTEST ) VALUES ( :PERSONAL_ID, :LETTER_ID ,:AUTH_USER,:PROBATION_ID,:filename,:LETTER2)"
cmd.Parameters.Add("PERSONAL_ID", OracleType.Number).Value = GetLastLetter()
cmd.Parameters.Add("LETTER_ID", OracleType.Number).Value = GetLastLetter()
cmd.Parameters.Add("AUTH_USER", OracleType.VarChar).Value = "adb30291"
cmd.Parameters.Add("LETTER2", OracleType.LongVarChar).Value = DirectCast(Editor1, CuteEditor.Editor).Text
cmd.Parameters.Add("PROBATION_ID", OracleType.Number).Value = Convert.ToInt32(Request.QueryString("prob"))
cmd.Parameters.Add("filename", OracleType.VarChar).Value = filename
Try
cn.Open()
cmd.ExecuteNonQuery()
Catch ex As Exception
Throw New Exception(ex.Message)
Finally
cn.Close()
End Try
Dim letterid As Integer
letterid = Me.GetLastLetter()
Editor1.SavePDF(filename)
Response.ContentType = "Application/pdf"
Response.WriteFile(MapPath(filename))
Dim cmd2 As New OracleCommand
Dim cn2 As New OracleConnection(ConfigurationManager.ConnectionStrings("EMIS").ConnectionString.ToString())
cmd2.Connection = cn2
cmd2.CommandText = "UPDATE WEB_RESOURCE_PROBATION SET LETTER_ID = :letterid WHERE PROBATION_ID=:probid"
With cmd2
.Parameters.Add("letterid", OracleType.Number).Value = GetLastLetter()
.Parameters.Add("probid", OracleType.Number).Value = Convert.ToInt32(Request.QueryString("prob"))
End With
cn2.Open()
cmd2.ExecuteNonQuery()
Response.Redirect("updateprob.aspx?prob=" + Request.QueryString("prob") + "&letterid=" & GetLastLetter())
Response.End()