Gridview data's is not printing,Getting empty sheet out....

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • shaliniraji
    New Member
    • Jan 2015
    • 15

    #1

    Gridview data's is not printing,Getting empty sheet out....

    Hi everyone,

    I'm trying to take print out from C#(winforms) Gridview,when I give print I'm getting empty sheet out not printing data's on the paper and not getting any error too..Can anyone tell me whats wrong with my code??

    Here is my code:

    Code:
    namespace PrintandPrintPreview
    {
        public partial class Form1 : Form
        {
            #region Member Variables
            StringFormat strFormat; //Used to format the grid rows.
            ArrayList arrColumnLefts = new ArrayList();//Used to save left coordinates of columns
            ArrayList arrColumnWidths = new ArrayList();//Used to save column widths
            int iCellHeight = 0; //Used to get/set the datagridview cell height
            int iTotalWidth = 0; //
            int iRow = 0;//Used as counter
            bool bFirstPage = true; //Used to check whether we are printing first page
            bool bNewPage = false;// Used to check whether we are printing a new page
            int iHeaderHeight = 0; //Used for the header height
            #endregion
    
            public Form1()
            {
                InitializeComponent();
                printDocument1.PrintPage += new PrintPageEventHandler(printDocument1_PrintPage);
            }
    
     private void Form1_Load(object sender, EventArgs e)
            {
                // TODO: This line of code loads data into the 'rajiDataSet.orders' table. You can move, or remove it, as needed.
                this.ordersTableAdapter.Fill(this.rajiDataSet.orders);
               
                
            }
    
            private void btnprint_Click(object sender, EventArgs e)
            {
                //Open the print dialog
                PrintDialog printDialog = new PrintDialog();
                printDialog.Document = printDocument1; ;
                printDialog.UseEXDialog = true;
                //Get the document
                if (DialogResult.OK == printDialog.ShowDialog())
                {
                    printDocument1.DocumentName = "Document is printing";
                   printDocument1.Print();
                }
                /*
                Note: In case you want to show the Print Preview Dialog instead of 
                Print Dialog then comment the above code and uncomment the following code
                */
    
                 //Open the print preview dialog
                 //PrintPreviewDialog objPPdialog = new PrintPreviewDialog();
                 //objPPdialog.Document = printDocument1;
                 //objPPdialog.ShowDialog();
            }
    
            private void printDocument1_PrintPage(object sender, PrintPageEventArgs e)
            {
                try
                {
                    //Set the left margin
                    int iLeftMargin = 0;
                    if (e.MarginBounds.Left > 0)
                    {
                        iLeftMargin = e.MarginBounds.Left;
                    }
                    //Set the top margin
                    int iTopMargin = 0;
                    if (e.MarginBounds.Top > 0)
                    {
                        iTopMargin = e.MarginBounds.Top;
                    }
                    //Whether more pages have to print or not
                    bool bMorePagesToPrint = false;
                    int iTmpWidth = 0;
    
                    //For the first page to print set the cell width and header height
                    if (bFirstPage)
                    {
                        foreach (DataGridViewColumn GridCol in dataGridView1.Columns)
                        {
                            iTmpWidth = (int)(Math.Floor((double)((double)GridCol.Width /
                                (double)iTotalWidth * (double)iTotalWidth *
                                ((double)e.MarginBounds.Width / (double)iTotalWidth))));
    
                            iHeaderHeight = (int)(e.Graphics.MeasureString(GridCol.HeaderText,
                                GridCol.InheritedStyle.Font, iTmpWidth).Height) + 11;
    
                            // Save width and height of headers
                            arrColumnLefts.Add(iLeftMargin);
                            arrColumnWidths.Add(iTmpWidth);
                            iLeftMargin += iTmpWidth;
                        }
                    }
                    //Loop till all the grid rows not get printed
                    while (iRow <= dataGridView1.Rows.Count - 1)
                    {
                        DataGridViewRow GridRow = dataGridView1.Rows[iRow];
                        //Set the cell height
                        iCellHeight = GridRow.Height + 5;
                        int iCount = 0;
                        //Check whether the current page settings allows more rows to print
                        if (iTopMargin + iCellHeight >= e.MarginBounds.Height + e.MarginBounds.Top)
                        {
                            bNewPage = true;
                            bFirstPage = false;
                            bMorePagesToPrint = true;
                            break;
                        }
                        else
                        {
                            if (bNewPage)
                            {
                                //Draw Header
                                e.Graphics.DrawString("Customer Summary",
                                    new Font(dataGridView1.Font, FontStyle.Bold),
                                    Brushes.Black, e.MarginBounds.Left,
                                    e.MarginBounds.Top - e.Graphics.MeasureString("Customer Summary",
                                    new Font(dataGridView1.Font, FontStyle.Bold),
                                    e.MarginBounds.Width).Height - 13);
    
                                String strDate = DateTime.Now.ToLongDateString() + " " +
                                    DateTime.Now.ToShortTimeString();
                                //Draw Date
                                e.Graphics.DrawString(strDate,
                                    new Font(dataGridView1.Font, FontStyle.Bold), Brushes.Black,
                                    e.MarginBounds.Left +
                                    (e.MarginBounds.Width - e.Graphics.MeasureString(strDate,
                                    new Font(dataGridView1.Font, FontStyle.Bold),
                                    e.MarginBounds.Width).Width),
                                    e.MarginBounds.Top - e.Graphics.MeasureString("Customer Summary",
                                    new Font(new Font(dataGridView1.Font, FontStyle.Bold),
                                    FontStyle.Bold), e.MarginBounds.Width).Height - 13);
    
                                //Draw Columns                 
                                iTopMargin = e.MarginBounds.Top;
                                foreach (DataGridViewColumn GridCol in dataGridView1.Columns)
                                {
                                    e.Graphics.FillRectangle(new SolidBrush(Color.LightGray),
                                        new Rectangle((int)arrColumnLefts[iCount], iTopMargin,
                                        (int)arrColumnWidths[iCount], iHeaderHeight));
    
                                    e.Graphics.DrawRectangle(Pens.Black,
                                        new Rectangle((int)arrColumnLefts[iCount], iTopMargin,
                                        (int)arrColumnWidths[iCount], iHeaderHeight));
    
                                    e.Graphics.DrawString(GridCol.HeaderText,
                                        GridCol.InheritedStyle.Font,
                                        new SolidBrush(GridCol.InheritedStyle.ForeColor),
                                        new RectangleF((int)arrColumnLefts[iCount], iTopMargin,
                                        (int)arrColumnWidths[iCount], iHeaderHeight), strFormat);
                                    iCount++;
                                }
                                bNewPage = false;
                                iTopMargin += iHeaderHeight;
                            }
                            iCount = 0;
                            //Draw Columns Contents                
                            foreach (DataGridViewCell Cel in GridRow.Cells)
                            {
                                if (Cel.Value != null)
                                {
                                    e.Graphics.DrawString(Cel.Value.ToString(),
                                        Cel.InheritedStyle.Font,
                                        new SolidBrush(Cel.InheritedStyle.ForeColor),
                                        new RectangleF((int)arrColumnLefts[iCount],
                                        (float)iTopMargin,
                                        (int)arrColumnWidths[iCount], (float)iCellHeight),
                                        strFormat);
                                }
                                //Drawing Cells Borders 
                                e.Graphics.DrawRectangle(Pens.Black,
                                    new Rectangle((int)arrColumnLefts[iCount], iTopMargin,
                                    (int)arrColumnWidths[iCount], iCellHeight));
                                iCount++;
                            }
                        }
                        iRow++;
                        iTopMargin += iCellHeight;
                    }
                    //If more lines exist, print another page.
                    if (bMorePagesToPrint)
                        e.HasMorePages = true;
                    else
                        e.HasMorePages = false;
                }
                catch (Exception exc)
                {
                    MessageBox.Show(exc.ToString());
                }
            }
    
        }
    }
    Last edited by Rabbit; Mar 23 '15, 04:50 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.
Working...