forcing new page in Stringbuilder

[Mike P]

I am creating a batch of invoices via the StringBuilder object and then
trying to print them all out, but I need to separate them so that they
all print on separate pages. Is there some HTML that I can use to force
a new page?

_sb.Append("<form id='form1' runat='server'>");
_sb.Append("<div style='text-align:center;'>");
_sb.Append("<table style='width:6.5in;border:solid
1px black;height:9.78in'>");
_sb.Append("<tr>");
_sb.Append("<td valign=top>");
_sb.Append("<!-- top row -->");
_sb.Append("<table width=90%>");
_sb.Append("<tr>");
_sb.Append("<td align=left valign=middle><br /><img
src='http://www.me.co.uk/content/images/logo.gif' /></td>");
_sb.Append("<td align=right valign=middle><br
/><b>Sales Invoice</b></td>");
_sb.Append("</tr>");
_sb.Append("<tr>");
_sb.Append("<td align=left valign=top><br />Me
House<br />");
_sb.Append("Add1<br />");
_sb.Append("Add2<br />");
_sb.Append("Add3<br />");
_sb.Append("Add4<br />");
_sb.Append("Add5<br />");
_sb.Append("Switchboard: 0199 929 5799</td>");
_sb.Append("<td align=right valign=bottom><b>Invoice
Number : </b>" + PaymentID + " <br /><b>Date :</b> &nbsp;&nbsp;" +
DateTime.Now.ToShortDateString() + "</td>");
_sb.Append("</tr>");
_sb.Append("</table>");
_sb.Append("<!-- end of top row -->");
_sb.Append("<!-- middle row -->");
_sb.Append("<br />");
_sb.Append("<table width=90%>");
_sb.Append("<tr>");
_sb.Append("<td align=left valign=middle>");
_sb.Append("<b>To:</b><br />");
_sb.Append(_rdr["Title"].ToString() + " " +
_rdr["forename"].ToString() + " " + _rdr["Surname"].ToString() + "<br
/>");
_sb.Append(_rdr["companyname"].ToString() + "<br
/>");
_sb.Append(_rdr["companyaddress1"].ToString() + "<br
/>");
_sb.Append(_rdr["companyaddress2"].ToString() + "<br
/>");
_sb.Append(_rdr["companyaddress3"].ToString() + "<br
/>");
_sb.Append(_rdr["companyaddress4"].ToString() + "<br
/>");
_sb.Append(_rdr["companypostcode"].ToString() + "<br
/>");
_sb.Append(_rdr["companytelephone"].ToString() +
"<br />");
_sb.Append("</td>");
_sb.Append("<td align=left valign=top>");
_sb.Append("<b>Ship To:</b><br />");
_sb.Append(_rdr["companyname"].ToString() + "<br
/>");
_sb.Append(_rdr["invoiceaddress1"].ToString() + "<br
/>");
_sb.Append(_rdr["invoiceaddress2"].ToString() + "<br
/>");
_sb.Append(_rdr["invoiceaddress3"].ToString() + "<br
/>");
_sb.Append(_rdr["invoiceaddress4"].ToString() + "<br
/>");
_sb.Append(_rdr["invoicepostcode"].ToString() + "<br
/>");
_sb.Append("</td>");
_sb.Append("</tr>");
_sb.Append("</table>");
_sb.Append("<!-- end of middle row -->");
_sb.Append("</td>");
_sb.Append("</tr>");
_sb.Append("<tr>");
_sb.Append("<td colspan=2 valign=top>");
_sb.Append("<!-- totals table row -->");
_sb.Append("<table width=90% style='border:solid 1px
black;' cellpadding=0 cellspacing=0>");
_sb.Append("<tr><td align=centre valign=middle
style='border:1px;
border-style:solid;border-color:black;border-right:1px;border-bottom:1px
;border-left:0px;border-top:0px;'><b>Description</b></td><td
style='width:150px;border:1px;
border-style:solid;border-color:black;border-right:0px;border-bottom:1px
;border-left:0px;border-top:0px;'><b>Price in £</b></td></tr>");

decimal _totalprice = 0;

if (_rdr["PaymentGuid"] != null)
{
using (SqlConnection _conn2 = new
SqlConnection(Resource1.ConnectionStringEng01))
using (SqlCommand _comm2 = new
SqlCommand("GetCounts", _conn2))
{
_conn2.Open();
_comm2.CommandType =
CommandType.StoredProcedure;
_comm2.Parameters.AddWithValue("@Guid",
_rdr["PaymentGuid"]);

SqlDataReader _rdr2 = null;
_rdr2 = _comm2.ExecuteReader();


while (_rdr2.Read())
{
if (_rdr2["LicenceType"].ToString() ==
"1")
{
_sb.Append("<tr><td align=centre
valign=middle style='border:1px;
border-style:solid;border-color:black;border-right:1px;border-bottom:0px
;border-left:0px;border-top:0px;'>" + _rdr2["Description"].ToString() +
"</td><td style='width:150px;border:1px;
border-style:solid;border-color:black;border-right:0px;border-bottom:0px
;border-left:0px;border-top:0px;'>" + _rdr2["PriceSU"] + "</td></tr>");

_totalprice = _totalprice +
Convert.ToDecimal(_rdr2["PriceSU"].ToString());
}
else
{
_sb.Append("<tr><td align=centre
valign=middle style='border:1px;
border-style:solid;border-color:black;border-right:1px;border-bottom:0px
;border-left:0px;border-top:0px;'>" + _rdr2["Description"].ToString() +
"</td><td style='width:150px;border:1px;
border-style:solid;border-color:black;border-right:0px;border-bottom:0px
;border-left:0px;border-top:0px;'>" + _rdr2["PriceMU"] + "</td></tr>");

_totalprice = _totalprice +
Convert.ToDecimal(_rdr2["PriceMU"].ToString());
}

//_totalprice = _totalprice +
Convert.ToDecimal(_rdr2["Value"].ToString());
}

}
}

_sb.Append("<tr><td align=centre valign=middle
height=100px style='border:1px;
border-style:solid;border-color:black;border-right:1px;border-bottom:0px
;border-left:0px;border-top:0px;'>&nbsp;</td><td
style='width:150px;border:1px;
border-style:solid;border-color:black;border-right:0px;border-bottom:0px
;border-left:0px;border-top:0px;'>&nbsp;</td></tr>");
_sb.Append("</table>");
_sb.Append("<table width=90% border=0 cellpadding=0
cellspacing=0>");
_sb.Append("<tr><td align=right valign=middle >Total
Cost&nbsp;&nbsp;</td><td style='width:150px;border:1px;
border-style:solid;border-color:black;border-right:1px;border-bottom:1px
;border-left:1px;border-top:0px;'>" + _totalprice + "</td></tr>");
_sb.Append("</table>");
_sb.Append("<!-- end totals table row -->");
_sb.Append("</td>");
_sb.Append("</tr>");
_sb.Append("<tr>");
_sb.Append("<td> <br /><br />if you have any
queries regarding this invoice contact : Me</td>");
_sb.Append("</tr>");
_sb.Append("<tr>");
_sb.Append("<td align=center><br /><br /><br /><br
/><b>Thanks for you order</b></td>");
_sb.Append("</tr>");
_sb.Append("</table>");
_sb.Append("</div>");
_sb.Append("</form>\n");

 

[Damien]

I am creating a batch of invoices via the StringBuilder object and then
trying to print them all out, but I need to separate them so that they
all print on separate pages. Is there some HTML that I can use to force
a new page?

Might this be your answer?
http://www.css3.com/css-page-break-after/

Damien

 

[Mike P]

Cheers Damien, worked perfectly!