AppendHTML NullReferenceException

Wed Jul 24, 2019 2:43 am

Hi there, love your product but I'm fairly new to it. Having problems merging in some HTML to a word doc. I'm guessing it's something in the HTML string which is upsetting it, but struggling to find it. Throws NullReferenceException on the AppendHTML line, there is definately HTML string in the reader.
I';m using Spire.Doc 7.7 Any pointers? Thank you

Dim strSQL As String = "SELECT * FROM SCHEDULE where contract_id=58527"
Using c As SqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("etb").ConnectionString)
c.Open()
Using Cmd As SqlCommand = New SqlCommand(strsql, c)
Using myreader As SqlDataReader = Cmd.ExecuteReader()
If myreader.HasRows Then
Dim dx As New Document()
dx.AddSection()
Dim p0 As Paragraph = dx.Sections(0).AddParagraph()

Do While myreader.Read()
p0.AppendBreak(BreakType.PageBreak)
If Not IsDBNull(myreader("BODY")) Then p0.AppendHTML(myreader("BODY"))
Loop
Using ms As IO.MemoryStream = New IO.MemoryStream()
dx.SaveToStream(ms, FileFormat.Docx)
Response.Clear()
Response.ContentType = "application/msword"
Response.AddHeader("Content-Disposition", "attachment; filename=myfile.docx")
Response.BinaryWrite(ms.ToArray())
End Using
Response.Flush()
Response.Close()
Response.End()

End If
End Using
End Using
End Using

Wed Jul 24, 2019 3:37 am

Hello,

Thanks for your inquiry.
To help us investigate your issue accurately, please provide the content of your appended html string that causes the exception. You also could send it to us via email (support@e-iceblue.com). Thanks in advance.

Sincerely,
Lisa
E-iceblue support team

Sun Jul 28, 2019 10:54 pm

<div style="font-size: 12px !important;">
1)                            Date of this Employment Agreement:                21 January 2019
 
2)                            Date of Physical Commencement of Work:      4 February 2019
 
3)                            Principal Work Location:                                   AUCKLAND/NORTH SHORE 
 
 
4)                            Brand Activator Number:                                  XXX
Remuneration Rates:  
Merchandising Rate:                                                                       $18.50 per hour 
 
Travel Rate
General Merchandising:                                                                  .48c after the first 15km travelled each day
Travel time can be claimed from 1st to last call for Red Bull/Pernod Ricard
Weekend Merchandising calls only
No other Travel Time is claimable, unless prior approval is given.
Laminex Allowance
Laminex Contribution of $150.00 per year towards Commercial Car Insurance & storage of products.
This contribution will be paid to the employee after 3 months of employment with the Laminex account. However, if the employee resigns within the first 6 months of employment, this contribution will be deducted from any monies owing.
Laminex Shirt
You are required to wear your Hoop Polo or vest on all Laminex  calls
 
Expenses for reimbursement of personal phone usage if tablet is not in working order:
- Text:20c per text 
- Pixt: 50c per pixt 
 
Rest & Meal breaks: 
 
Length of employee's work period with HOOP - 2.00 - 4.00 hours - 
 
1 x 10 minute paid rest break 
 
Length of employee's work period with HOOP - 4.01 - 6.00 hours - 
 
1 x 10 minute paid rest break, 1 x 30 minute unpaid meal break   
 
Length of employee's work period with HOOP - 6.01 - 10.00 hours - 
 
1 x 10 minute paid rest break, 1 x 30 minute unpaid meal break,  1 x 10 minute paid rest break 
 
Length of employee's work period with HOOP 10-01 - 12.00 hours -  
 
1 x 10 minute paid rest break, 1 x 30 minute unpaid meal break, 1 x 10 minute paid rest break, 1 x 10 minute paid rest break, 
 
Length of employee's work period with HOOP 12.01 - 14.00 hours - 
 
1 x 10 minute paid rest break, First 30 minute unpaid meal break, 1 x 10 minute paid rest break, 1 x 10 minute paid rest break, Second 30 minute unpaid meal break 

Bi-monthly Payments Provisions: 
 
2 payments in arrears on 6th and 23rd of each Month calculations as per Schedule 5
Notice Period for Employee taking Annual Leave: 
- 4 weeks for leave duration of 2 weeks or less and  
- 12 weeks’ notice for any leave in excess of 2 weeks 
 
Contact Details of Person for Sick and Bereavement Leave: XXXXXXXXX
Probationary Period: 
 
Review Cycle: 4th week, 8th week, 12 week. 
 
Notice period for termination during the Probationary Period: 2 weeks
Termination of Employment:
Termination Notice Period: 2 weeks
 
 
Resignation Notice Period: 4 weeks 
 
Redundancy Notice Period: 4 weeks
Reporting: 
 
Calls are to be entered on online: Daily on completion of each call 
Monthly Expense report received and calls entered online: Before monthly deadline as recorded on expense report each month 
 
Cancellation of Work:
Cancellation Notice Period: 48 hours 
Compensation in Lieu of Cancellation of Notice Period: 
 
•             If not given notice before 48 hours = 25% of pay 
•             If not given notice before 24 hours = 50% of pay 
•             If not given notice before 12 hours = 75% of pay
</div>

Mon Jul 29, 2019 6:36 am

Hello,

Thanks for your feedback.
After testing with your html code, I didn't encounter the exception. Here, I uploaded my simple testing Demo for your reference. Please run it on your side, if your issue still occurs, please share us with your system information (E.g. Windows 7, 64 bit) and region setting (E.g. China, Chinese) to help further look into your issue.

Sincerely,
Lisa
E-iceblue support team

Fri Aug 02, 2019 8:29 am

Hello,

Greetings from E-iceblue.
Could you please let us know how is the issue going? Thanks in advance for your feedback and time.

Sincerely,
Lisa
E-iceblue support team

AppendHTML NullReferenceException

Purchase

Partnership

Products

Corporation