Hi-
The majority of the PDF files used in my application are scanned drawings or documents.
I am using the following code to save annotations to the PDF files back to the database:
'Create a connection to the database
Dim ConStr As String
ConStr = MyAppConnString
Dim con As New SqlConnection(ConStr)
con.Open()
Dim sqlCommand As New SqlCommand()
’ Set Command text to stored procedure name
With sqlCommand
sqlCommand.Parameters.Clear()
.CommandText = “RetrieveDocument”
’ Set the command type to Stored procedure
.CommandType = CommandType.StoredProcedure
’ Add parameter/s to the command. Depends on the Stored procedure
.Parameters.Add("@SelectedNode", SqlDbType.NVarChar, 128).Value = myTag
'add the conection to the command
.Connection = con
End With
Dim filePath As String = CStr(sqlCommand.ExecuteScalar())
'Obtain a Transaction Context
Dim transaction As SqlTransaction = con.BeginTransaction(“ItemTran”)
sqlCommand.Transaction = transaction
’ Set Command text to stored procedure name
With sqlCommand
sqlCommand.Parameters.Clear()
.CommandText = “tContext”
’ Set the command type to Stored procedure
.CommandType = CommandType.StoredProcedure
.Connection = con
End With
Dim txContext As Byte() = CType(sqlCommand.ExecuteScalar(), Byte())
'Open and read file using SqlFileStream Class
Dim sqlFileStream As New SqlTypes.SqlFileStream(filePath, txContext, FileAccess.ReadWrite)
Dim buffer As Byte() = New Byte(CInt(sqlFileStream.Length)) {}
'Bind the image data to an image control
Dim ms As MemoryStream = New MemoryStream(buffer)
_pdfdoc.Lock()
Try
_pdfdoc.Save(ms, SDF.SDFDoc.SaveOptions.e_incremental)
Catch ex As Exception
MessageBox.Show(ex.ToString(), “Error during the Save”)
End Try
_pdfdoc.Unlock()
sqlFileStream.Write(buffer, 0, buffer.Length)
'Cleanup
sqlFileStream.Close()
sqlCommand.Transaction.Commit()
con.Close()
It seems the above code doesn’t work with many of my PDF files since I receive the following error message after adding an annotation and during the save:
pdftron.Common.PDFNetException: Unknown exception.
at pdftron.PDF.PDFDoc.Save(Stream stm, SaveOptions flags)
at devFacilivuePRO.PDFTron.saveDoc() in [path to file in my project]
The PDF files subsequently seem to become corrupted and cannot be opened (using my application or using the latest version of Adobe Acrobat).
If an error is not received during the save (after adding an annotation), the file cannot be opened by Adobe Acrobat but can be opened in my application.
If I load a good copy of one of the problematic PDF files from the file system in the PDFView sample and save them, the files save without error and can be opened with Adobe Acrobat. Because of this, I’m guessing the problem is not with the PDF files.
Am I doing something wrong while saving?
Thank you,
Matt