Writing large data to PDF giving system out of memory Exception

[manjit]

Hi am trying to write large data to PDF but giving system out of memory Exception.

step1:

 using (SqlDataReader dr = cmd.ExecuteReader())
                            {
 
                                Int64 counter = 0;
 
 
 
                                setBLR.Append("<table border = '1' width='100%'>");
                                setBLR.Append("<meta http-equiv=");
                                setBLR.Append("Content-Type");
                                setBLR.Append("content=");
                                setBLR.Append("text/html;");
                                setBLR.Append("charset=utf-8");
                                setBLR.Append("/>");
                                int t;
 
 
 
                                #region "show header/footer"
                                if (i.header.ToUpper() == "Y")
                                {
                                    setBLR.Append("<tr>");
                                    for (t = 0; t < dr.FieldCount; t++)
                                    {
                                        setBLR.Append("<td>" + dr.GetName(t) + "</td>");
                                    }
 
                                    setBLR.Append("</tr>");
 
                                }
                                #endregion
                                while (dr.Read())
                                {
                                    counter++;
                                    setBLR.Append("<tr>");
 
                                    for (t = 0; t < dr.FieldCount; t++)
                                    {
 
 
                                        setBLR.Append("<td>" + dr[t].ToString() + "</td>");
                                    }
 
                                    setBLR.Append("</tr>");
                                }
 
                                setBLR.Append("</tr></table>");
 
 
 
 
                                StringReader sr = new StringReader(setBLR.ToString());
                                string shoheader = i.header.ToString();
                                converttopdf(setBLR.ToString(), i.file.ToString(), shoheader, i, counter);
 
                            }
 
Step 2:
 public void converttopdf(string HTMLString, string fileLocation,string Header, Item i,Int64 counter)
        {
            try
            {
                Document document = new Document();
                List<IElement> htmlarraylist = new List<IElement>();
                Phrase phrase = null;
                //Full path to the Unicode Arial file
                string ARIALUNI_TFF = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Fonts), "ARIALUNI.TTF");
 
 
                phrase = new Phrase();
                PdfWriter.GetInstance(document, new FileStream(fileLocation, FileMode.Create));
                document.Open();
 
 
 
                var arialFontPath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Fonts), "ARIALUNI.TTF");
                FontFactory.Register(arialFontPath);
                BaseFont bf = BaseFont.CreateFont(arialFontPath, BaseFont.IDENTITY_H, true);
                iTextSharp.text.Font FontAr = new iTextSharp.text.Font(bf);
                iTextSharp.text.FontFactory.RegisterDirectory(arialFontPath);
                StyleSheet styles = new StyleSheet();
                styles.LoadTagStyle(HtmlTags.DIV, HtmlTags.FONTSIZE, "16");
                styles.LoadTagStyle(HtmlTags.DIV, HtmlTags.COLOR, "navy");
                styles.LoadTagStyle(HtmlTags.DIV, HtmlTags.FONTWEIGHT, "bold");
                styles.LoadTagStyle(HtmlTags.P, HtmlTags.INDENT, "30px");
                styles.LoadTagStyle(HtmlTags.BODY, HtmlTags.FACE, "Arial Unicode MS");
                styles.LoadTagStyle(HtmlTags.BODY, HtmlTags.ENCODING, BaseFont.IDENTITY_H);
 
                if (!String.IsNullOrWhiteSpace(i.addRowCount) && i.rowCountPosition.ToLower() == "top")
                {
 
                    StringBuilder bs = new StringBuilder();
                    bs.Append("<table border = '1' width='100%'>");
                    bs.Append("<tr>");
                    bs.Append("<td>" + "Total Row Count:" + counter + "</td>");
                    bs.Append("</tr>");
                    bs.Append("</table>");
 
                    htmlarraylist = HTMLWorker.ParseToList(new StringReader(bs.ToString() + HTMLString.ToString()), styles);
 
                }
                else if (!String.IsNullOrWhiteSpace(i.addRowCount) && i.rowCountPosition.ToLower() == "bottom")
                {
 
                    StringBuilder bs = new StringBuilder();
                    bs.Append("<table border = '1' width='100%'>");
                    bs.Append("<tr>");
                    bs.Append("<td>" + "Total Row Count: " + counter + "</td>");
                    bs.Append("</tr>");
                    bs.Append("</table>");
 
                    htmlarraylist = HTMLWorker.ParseToList(new StringReader(HTMLString.ToString() + bs.ToString()), styles);
                }
                else
                {
                    htmlarraylist = HTMLWorker.ParseToList(new StringReader(HTMLString.ToString()), styles);
 
                }
 
 
                for (int k = 0; k < htmlarraylist.Count; k++)
                {
                    document.Add((IElement)htmlarraylist[k]);
 
                }
 
 
                document.Close();
            }
            catch (Exception ex)
            {
 
                throw ex;
            }
 
        }

[Luuk]

1. Define 'large'
2. On what line is the 'system out of memory Exception ' raised?

@1: is Large something in kiloBytes, megaBytes, gigaBytes, or bigger....
@2: I think the line on which the exception occurs is a line that starts with 'setBLR.Append(.....'