Displaying multiple page of Listview in Print Preview

Question

0.00/5 (No votes)

See more:

Hi,
I am new in programming world. I have developed a project that can operate a small shop. But i can't display multiple page in print preview that load from a list view.
Please help me to solve this page display problem.
My code block are following:

C#

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.Common;
using System.Data.OleDb;
using System.Collections;
using System.Drawing.Printing;

namespace ABCLimited
{
    public partial class ReportForm : Form
    {
        public ReportForm()
        {
            InitializeComponent();
        }
        decimal totalCostPrice, totalSalesPrice, totalProfit;
        DataTable dt;
        int checkReportType = 0;
        private void btnAnalysis_Click(object sender, EventArgs e)
        {
            Cursor = Cursors.WaitCursor;
            try
            {
                lvProfit.Items.Clear();
                DateTime fromDate = Convert.ToDateTime(dateTimePicker1.Text);
                DateTime toDate = Convert.ToDateTime(dateTimePicker2.Text);
                string queryProfit = "Select * from SalesTable where SalesDate between #" + fromDate + "# and #" + toDate + "#";
                DbCommand com = Central.con.CreateCommand();
                com.CommandType = CommandType.Text;
                com.CommandText = queryProfit;
                Central.con.Open();
                DbDataReader ddr = com.ExecuteReader();
                dt = new DataTable();
                dt.Load(ddr);
                if (dt != null)
                {
                    if (dt != null)
                    {
                        try
                        {
                            for (int i = 0; i < dt.Rows.Count; i++)
                            {
                                totalCostPrice += Convert.ToDecimal(dt.Rows[i].ItemArray[12]);
                                totalSalesPrice += Convert.ToDecimal(dt.Rows[i].ItemArray[11]);
                                totalProfit += Convert.ToDecimal(dt.Rows[i].ItemArray[13]);
                                System.Windows.Forms.ListViewItem listViewItem1 = new System.Windows.Forms.ListViewItem(new string[] {
                                dt.Rows[i].ItemArray[0].ToString(),
                                dt.Rows[i].ItemArray[2].ToString(),
                                dt.Rows[i].ItemArray[3].ToString(),
                                dt.Rows[i].ItemArray[12].ToString(),
                                dt.Rows[i].ItemArray[11].ToString(),
                                dt.Rows[i].ItemArray[4].ToString(),
                                dt.Rows[i].ItemArray[9].ToString(),
                                dt.Rows[i].ItemArray[13].ToString()}, -1);
                                lvProfit.Items.Add(listViewItem1);
                                checkReportType = 1;

                            }
                        }

                        catch (Exception ex)
                        {
                            MessageBox.Show(ex.Message);
                        }
                        finally
                        {
                            ddr.Close();
                        }
                        ///To convert intop 2 digits after point.inherit from pointsConvert() method.
                        txtTotalCostPrice.Text =pointsConvert(totalCostPrice.ToString());
                        txtTotalSalesPrice.Text =pointsConvert(totalSalesPrice.ToString());
                        txtTotalProfit.Text =pointsConvert(totalProfit.ToString());
                        
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                Central.con.Close();
            }
            Cursor = Cursors.Default;
        }

        public void printDocument1_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
        {
            

            e.Graphics.DrawLine(new Pen(Color.Black, 2), 80, 70, 750, 70);
            e.Graphics.DrawLine(new Pen(Color.Black, 2), 80, 73, 750, 73);

            string comName = "ABC TRADING CO. L.L.C";
            Font FontName = new Font("Time New Roman", 20, FontStyle.Bold);
            e.Graphics.DrawString(comName, FontName, Brushes.Black, 240, 80);

            string addName = "A, AL DIST";
            Font FontName1 = new Font("Time New Roman", 12, FontStyle.Bold);
            e.Graphics.DrawString(addName, FontName1, Brushes.Black, 300, 110);

            string imName = "Importers, Exporters & Distributors, Whole sale and Retail";
            Font FontName2 = new Font("Time New Roman", 10, FontStyle.Regular);
            e.Graphics.DrawString(imName, FontName2, Brushes.Black, 250, 135);

            string Name = "Sales/Profit Analysis";
            Font FontName3 = new Font("Time New Roman", 16, FontStyle.Bold);
            e.Graphics.DrawString(Name, FontName3, Brushes.Black, 340, 150);

            FontName = new Font("Time New Roman", 10, FontStyle.Bold);
            Font fontNameRegular = new Font("Time New Roman", 10, FontStyle.Regular);

            e.Graphics.DrawLine(new Pen(Color.Black, 2), 80, 200, 750, 200);
            e.Graphics.DrawLine(new Pen(Color.Black, 2), 80, 203, 750, 203);
            //draw table
            e.Graphics.DrawLine(new Pen(Color.Black, 1), 80, 220, 750, 220);
            e.Graphics.DrawLine(new Pen(Color.Black, 1), 80, 220, 80, 250);

            if (checkReportType == 1)
            {

                e.Graphics.DrawString("Memo No :", FontName, Brushes.Black, 82, 222);
                e.Graphics.DrawLine(new Pen(Color.Black, 1), 175, 220, 175, 250);

                e.Graphics.DrawString("ProductID :", FontName, Brushes.Black, 185, 222);
                e.Graphics.DrawLine(new Pen(Color.Black, 1), 280, 220, 280, 250);

                e.Graphics.DrawString("Product Name :", FontName, Brushes.Black, 300, 222);
                e.Graphics.DrawLine(new Pen(Color.Black, 1), 500, 220, 500, 250);

                e.Graphics.DrawString("Sales Type ", FontName, Brushes.Black, 510, 222);
                e.Graphics.DrawLine(new Pen(Color.Black, 1), 610, 220, 610, 250);

                e.Graphics.DrawString("Total Profit :", FontName, Brushes.Black, 620, 222);
                e.Graphics.DrawLine(new Pen(Color.Black, 1), 750, 220, 750, 250);

                e.Graphics.DrawLine(new Pen(Color.Black, 1), 80, 250, 750, 250);

                int itemY = 230;
                if (dt != null)
                {
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        itemY += 20;
                        e.Graphics.DrawString(dt.Rows[i].ItemArray[0].ToString(), FontName, Brushes.Black, 82, itemY);

                        e.Graphics.DrawString(dt.Rows[i].ItemArray[2].ToString(), FontName, Brushes.Black, 185, itemY);

                        e.Graphics.DrawString(dt.Rows[i].ItemArray[3].ToString(), FontName, Brushes.Black, 300, itemY);

                        e.Graphics.DrawString(dt.Rows[i].ItemArray[9].ToString(), FontName, Brushes.Black, 525, itemY);

                        e.Graphics.DrawString(dt.Rows[i].ItemArray[13].ToString(), FontName, Brushes.Black, 625, itemY);
                    }
                }
                e.Graphics.DrawLine(new Pen(Color.Black, 3), 80, itemY + 90, 750, itemY + 90);
                e.Graphics.DrawString("Total Profit :", FontName, Brushes.Black, 500, itemY + 72);

                e.Graphics.DrawString(txtTotalProfit.Text, FontName, Brushes.Black, 650, itemY + 72);
                e.Graphics.DrawLine(new Pen(Color.Black, 3), 80, itemY + 70, 750, itemY + 70);

                e.Graphics.DrawLine(new Pen(Color.Black, 3), 80, 220, 80, itemY + 90);
                e.Graphics.DrawLine(new Pen(Color.Black, 3), 175, 220, 175, itemY + 70);
                e.Graphics.DrawLine(new Pen(Color.Black, 3), 280, 220, 280, itemY + 70);
                e.Graphics.DrawLine(new Pen(Color.Black, 3), 500, 220, 500, itemY + 70);
                e.Graphics.DrawLine(new Pen(Color.Black, 3), 610, 220, 610, itemY + 70);
                e.Graphics.DrawLine(new Pen(Color.Black, 3), 750, 220, 750, itemY + 90);
            }
            else
            {
                e.Graphics.DrawString("Prod.ID ", FontName, Brushes.Black, 80, 222);
                e.Graphics.DrawString("Product Name ", FontName, Brushes.Black, 210, 222);
                e.Graphics.DrawString("T.Sales Price", FontName, Brushes.Black, 385, 222);             
                e.Graphics.DrawString("TC.Price", FontName, Brushes.Black, 498, 222);             
                e.Graphics.DrawString("TS.Unit", FontName, Brushes.Black, 582, 222);             
                e.Graphics.DrawString("Total Profit", FontName, Brushes.Black, 660, 222);
                e.Graphics.DrawLine(new Pen(Color.Black, 1), 80, 250, 750, 250);
                int itemY = 230;
                if (dt != null)
                {
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        itemY += 20;
                        e.Graphics.DrawString(dt.Rows[i].ItemArray[0].ToString(), FontName, Brushes.Black, 80, itemY);                       e.Graphics.DrawString(dt.Rows[i].ItemArray[1].ToString(), FontName, Brushes.Black, 150, itemY);                        e.Graphics.DrawString(dt.Rows[i].ItemArray[3].ToString(), FontName, Brushes.Black, 379, itemY);                        e.Graphics.DrawString(dt.Rows[i].ItemArray[4].ToString(), FontName, Brushes.Black, 496, itemY);                        e.Graphics.DrawString(dt.Rows[i].ItemArray[2].ToString(), FontName, Brushes.Black, 580, itemY);                        e.Graphics.DrawString(dt.Rows[i].ItemArray[5].ToString(), FontName, Brushes.Black, 652, itemY);
                    }
                }
                e.Graphics.DrawLine(new Pen(Color.Black, 2), 80, itemY + 90, 750, itemY + 90);
                e.Graphics.DrawString("Total Profit :", FontName, Brushes.Black, 520, itemY + 72);

                e.Graphics.DrawString(txtTotalProfit.Text, FontName, Brushes.Black, 650, itemY + 72);
                e.Graphics.DrawLine(new Pen(Color.Black, 2), 80, itemY + 70, 750, itemY + 70);

                e.Graphics.DrawLine(new Pen(Color.Black, 2), 80, 220, 80, itemY + 90);
                e.Graphics.DrawLine(new Pen(Color.Black, 2), 150, 220, 150, itemY + 70);
                e.Graphics.DrawLine(new Pen(Color.Black, 2), 377, 220, 377, itemY + 70);
                e.Graphics.DrawLine(new Pen(Color.Black, 2), 494, 220, 494, itemY + 70);
                e.Graphics.DrawLine(new Pen(Color.Black, 2), 578, 220, 578, itemY + 70);
                e.Graphics.DrawLine(new Pen(Color.Black, 2), 650, 220, 650, itemY + 70);
                e.Graphics.DrawLine(new Pen(Color.Black, 2), 750, 220, 750, itemY + 90);
               
            }
        }
        private void btnPrintPreview_Click(object sender, EventArgs e)
        {
            printPreviewDialog1.ShowDialog();        
        }
        private void btnClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        private void button1_Click(object sender, EventArgs e)
        {
            Cursor = Cursors.WaitCursor;

            try
            {
                lvProfit.Items.Clear();
                DateTime fromDate = Convert.ToDateTime(dateTimePicker1.Text);
                DateTime toDate = Convert.ToDateTime(dateTimePicker2.Text);
                string queryProfit = "SELECT ProductID, ProductName, sum(SalesUnit), sum(SalesPriceWithOutDis), sum(TotalCostPrice), sum(Profit) FROM salesTable WHERE salesDate Between #" + fromDate + "# And #" + toDate + "# GROUP BY ProductName, ProductID";
                DbCommand com = Central.con.CreateCommand();
                com.CommandType = CommandType.Text;
                com.CommandText = queryProfit;
                Central.con.Open();
                DbDataReader ddr = com.ExecuteReader();
                dt = new DataTable();
                dt.Load(ddr);
                if (dt != null)
                {
                    if (dt != null)
                    {
                        try
                        {
                            for (int i = 0; i < dt.Rows.Count; i++)
                            {
                                totalCostPrice += Convert.ToDecimal(dt.Rows[i].ItemArray[4]);
                                totalSalesPrice += Convert.ToDecimal(dt.Rows[i].ItemArray[3]);
                                totalProfit += Convert.ToDecimal(dt.Rows[i].ItemArray[5]);
                                System.Windows.Forms.ListViewItem listViewItem1 = new System.Windows.Forms.ListViewItem(new string[] {
            null,
            dt.Rows[i].ItemArray[0].ToString(),
            dt.Rows[i].ItemArray[1].ToString(),
            dt.Rows[i].ItemArray[4].ToString(),
            dt.Rows[i].ItemArray[3].ToString(),
            dt.Rows[i].ItemArray[2].ToString(),
            null,
            dt.Rows[i].ItemArray[5].ToString()}, -1);
                                lvProfit.Items.Add(listViewItem1);
                                
                                //for print Priview
                                checkReportType = 0;
                            }
                        }

                        catch (Exception ex)
                        {
                            MessageBox.Show(ex.Message);
                        }
                        finally
                        {
                            ddr.Close();
                        }
                        ///To convert intop 2 digits after point.inherit from pointsConvert() method
                        txtTotalCostPrice.Text =pointsConvert(totalCostPrice.ToString());
                        txtTotalSalesPrice.Text =pointsConvert(totalSalesPrice.ToString());
                        txtTotalProfit.Text =pointsConvert(totalProfit.ToString());
                        
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                Central.con.Close();
            }
            Cursor = Cursors.Default;
        }
        private void printPreviewDialog1_Load(object sender, EventArgs e)
        {
        }

        private void printDocument1_BeginPrint(object sender, System.Drawing.Printing.PrintEventArgs e)
        {
           
        }

        private void printDocument1_EndPrint(object sender, System.Drawing.Printing.PrintEventArgs e)
        {

        }

        private void printPreviewDialog1_Click(object sender, EventArgs e)
        {
            //bool hasMorePage = oo;
                      
        }
        public string pointsConvert(string n)
        {
            string sr = "";
            string numb = n;
            String val = "", wholeNo = numb, points = "";
            string subP = "";

            int decimalPlace = numb.IndexOf(".");
            if (decimalPlace > 0)
            {
                wholeNo = numb.Substring(0, decimalPlace);
                points = numb.Substring(decimalPlace + 1);
                if (Convert.ToInt64(points) > 0)
                {
                    ArrayList ar = new ArrayList();
                    for (int i = 0; i < points.Length; i++)
                    {
                        ar.Add(points[i]);
                    }

                    ar.RemoveRange(2, points.Length - 2);

                    foreach (char p in ar)
                    {
                        subP += p;

                    }
                    sr = "." + subP;
                    //return sr;
                }
                val = wholeNo + sr;
                return val;

                //}
                //val = wholeNo + "." + subP;
                //return val;
            }
            else
            {
                return numb;
            }
        }
        private void PageSetup(object sender, EventArgs e)
        {
            pageSetupDialog1.ShowDialog();
        }

    }
}

Posted 6-Jul-10 19:18pm

nazmulshakil

Updated 9-Jul-10 0:04am

v4

Add a Solution

Comments

Christian Graus 7-Jul-10 1:21am

No-one is going to wade through all this code. This is complex code for a beginner, although it's certainly not well thought out or written, from what I can see. Perhaps you need to show us the bit of pertinent code, explain what you've tried, and see if we can help from there ?

nazmulshakil 9-Jul-10 6:05am

Dear Graus,thank you for seeing my question and response.I want to show print preview in multiple page and the printDocument1 fetch from a listView(lvProfit),now i am able to show print preview but i can't show printDocument1 in multiple pages.It shows First page but second or another pages are not displayed.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2010-07-06T19:24:00

Solution 1

As CG as suggested, looking at the whole code won't help much. Further you have not explained what have you tried.
Yet, based on what your need is, this article might help you out:
Printable ListView[^]

Posted 6-Jul-10 19:24pm

Sandeep Mewara

Comments

nazmulshakil 9-Jul-10 5:45am

Thank You very much Dear sandeep vaia.