Click here to Skip to main content
15,867,771 members
Articles / Programming Languages / Visual Basic
Article

DataGridView Printing by Selecting Columns and Rows

Rate me:
Please Sign up or sign in to vote.
4.85/5 (102 votes)
11 Mar 2007CPOL3 min read 890.1K   45.9K   238   204
An article on DataGrdView printing.

Image 1

Image 2

Introduction

Sometimes the user needs to print specific columns and rows (or all of them) in a DataGridView. Some cases can be as below:

  • There are too many rows in a DataGridView and there is no need to print all of them.
  • Sum of the column widths may be wider than the page width, and it is better to remove one or more columns while printing.

So a class named PrintDGV was implemented, and can be used in any .NET2.0 application. I have done it both for the DataGrid and for the DataGridView, in C# and VB.NET.

Description

The main section of the code is the PrintDGV class and the PrintOptions form.

In the PrintDGV, we have:

  • The SelectedColumns and AvailableColumns lists to hold column names.
  • A PrintDocument object named PrintDoc (with the BeginPrint and PrintPage event handlers)
  • Four functions:
    • Print_DataGridView: The main function that can be called from outside of the class.
    • PrintDoc_BeginPrint: Initializes some variables to begin printing.
    • PrintDoc_PrintPage: Performs the printing job.
    • DrawFooter: Writes the page number.

The code has the following features :

  • Supports TextBox, Link, Button, ComboBox, CheckBox, and Image columns.
  • Draws the columns to fit on the page width, or draws them as they are shown.
  • Wraps the cell text if the cell width is smaller than its contents.
  • Draws the page footer, date, time, and the title on the page.

Using the code

For using the code in an application, the PrintDGV class and the PrintOptions form must be added to it, and then the function Print_DataGridView is called. In our example, the sample project has a Form named MainForm.

In the MainForm, the DataGridView is filled with 'Persons' table of the 'Persongs.mdb'.

In the PrintOption form, the DataGridView Columns, Fitting to page, and the Title can be selected by user.

The PrintDoc_PrintPage event handler does the following tasks :

  • Calculates the column widths.
  • Prints the current page, row by row - loops through all rows in the DataGridView.
  • In the 'Print Selected Rows' mode, if the current row is not selected, then skips it.
  • If it reaches the end of the page, then writes the page number and goes to the next page. If it doesn't reach the end of the page then:
  • If it is in a new page, then draws the title, date-time, headers, and columns (checks to see if each column was selected by the user, if not, skips it).
  • Draws the column contents for the TextBox, Link, Button, CheckBox, ComboBox, and Image cells (checks to see if each column was selected by the user, if not, skips it).
  • Draws the borders.
  • Calculates the 'Rows per Page' for the first page.
  • Writes the page footer (page number).
C#
private static void PrintDoc_PrintPage(object sender, 
        System.Drawing.Printing.PrintPageEventArgs e) 
{
    int tmpWidth, i;
    int tmpTop = e.MarginBounds.Top;
    int tmpLeft = e.MarginBounds.Left;
    int HeaderHeight=0;

    try 
    {            
        // Before starting first page, it saves
        // Width & Height of Headers and CoulmnType
        if (PageNo == 1) 
        {
            foreach (DataGridViewColumn GridCol in dgv.Columns)
            {
                if (!GridCol.Visible) continue;
                // Skip if the current column not selected
                if (!PrintDGV.SelectedColumns.Contains(
                     GridCol.HeaderText)) continue;

                // Detemining whether the columns
                // are fitted to the page or not.
                if (FitToPageWidth) 
                    tmpWidth = (int)(Math.Floor((double)(
                               (double)GridCol.Width / 
                               (double)TotalWidth * (double)TotalWidth * 
                               ((double)e.MarginBounds.Width / 
                                (double)TotalWidth))));
                else
                    tmpWidth = GridCol.Width;

                HeaderHeight = 
                   (int)(e.Graphics.MeasureString(GridCol.HeaderText,
                    GridCol.InheritedStyle.Font, tmpWidth).Height) + 11;

                // Save width & height of headres and ColumnType
                ColumnLefts.Add(tmpLeft);
                ColumnWidths.Add(tmpWidth);
                ColumnTypes.Add(GridCol.GetType());
                tmpLeft += tmpWidth;
            }
        }

        // Printing Current Page, Row by Row
        while (RowPos <= dgv.Rows.Count - 1)
        {
            DataGridViewRow GridRow = dgv.Rows[RowPos];
            if (GridRow.IsNewRow || (!PrintAllRows && !GridRow.Selected))
            {
                RowPos++;
                continue;
            }

            CellHeight = GridRow.Height;

            if (tmpTop + CellHeight >= 
                 e.MarginBounds.Height + e.MarginBounds.Top)
            {
                DrawFooter(e, RowsPerPage);
                NewPage = true;
                PageNo++;
                e.HasMorePages = true;
                return;
            }
            else
            {
                if (NewPage)
                {
                    // Draw Print Title
                    e.Graphics.DrawString(PrintTitle, 
                           new Font(dgv.Font, FontStyle.Bold), 
                            Brushes.Black, e.MarginBounds.Left, 
                            e.MarginBounds.Top -
                            e.Graphics.MeasureString(PrintTitle, 
                            new Font(dgv.Font, 
                            FontStyle.Bold), 
                            e.MarginBounds.Width).Height - 13);

                    String s = DateTime.Now.ToLongDateString() + " " + 
                               DateTime.Now.ToShortTimeString();
                    // Draw Time and Date    
                    e.Graphics.DrawString(s, 
                            new Font(dgv.Font, FontStyle.Bold), 
                            Brushes.Black, e.MarginBounds.Left + 
                            (e.MarginBounds.Width - 
                            e.Graphics.MeasureString(s, new Font(dgv.Font, 
                            FontStyle.Bold), e.MarginBounds.Width).Width), 
                            e.MarginBounds.Top - 
                            e.Graphics.MeasureString(PrintTitle, 
                            new Font(new Font(dgv.Font, 
                            FontStyle.Bold), FontStyle.Bold), 
                            e.MarginBounds.Width).Height - 13);

                    // Draw Headers
                    tmpTop = e.MarginBounds.Top;
                    i = 0;
                    foreach (DataGridViewColumn GridCol in dgv.Columns)
                    {
                        if (!GridCol.Visible) continue;
                        if (!PrintDGV.SelectedColumns.Contains(
                                            GridCol.HeaderText)) 
                            continue;

                        e.Graphics.FillRectangle(new 
                            SolidBrush(Color.LightGray), 
                            new Rectangle((int) ColumnLefts[i], tmpTop,
                            (int)ColumnWidths[i], HeaderHeight));

                        e.Graphics.DrawRectangle(Pens.Black, 
                            new Rectangle((int) ColumnLefts[i], tmpTop,
                            (int)ColumnWidths[i], HeaderHeight));

                        e.Graphics.DrawString(GridCol.HeaderText, 
                            GridCol.InheritedStyle.Font, 
                            new SolidBrush(GridCol.InheritedStyle.ForeColor),
                            new RectangleF((int)ColumnLefts[i], tmpTop, 
                            (int)ColumnWidths[i], HeaderHeight), StrFormat);
                        i++;
                    }
                    NewPage = false;
                    tmpTop += HeaderHeight;
                }

                // Draw Columns Contents
                i = 0;
                foreach (DataGridViewCell Cel in GridRow.Cells)
                {
                    if (!Cel.OwningColumn.Visible) continue;
                    if (!SelectedColumns.Contains(
                            Cel.OwningColumn.HeaderText))
                        continue;

                    // For the TextBox Column
                    if (((Type) ColumnTypes[i]).Name == 
                         "DataGridViewTextBoxColumn" || 
                        ((Type) ColumnTypes[i]).Name == 
                         "DataGridViewLinkColumn")
                    {
                        e.Graphics.DrawString(Cel.Value.ToString(), 
                                Cel.InheritedStyle.Font, 
                                new SolidBrush(Cel.InheritedStyle.ForeColor),
                                new RectangleF((int)ColumnLefts[i], 
                                (float)tmpTop,
                                (int)ColumnWidths[i], 
                                (float)CellHeight), StrFormat);
                    }
                    // For the Button Column
                    else if (((Type) ColumnTypes[i]).Name == 
                                     "DataGridViewButtonColumn")
                    {
                        CellButton.Text = Cel.Value.ToString();
                        CellButton.Size = new Size((int)ColumnWidths[i], 
                                                    CellHeight);
                        Bitmap bmp = new Bitmap(CellButton.Width, 
                                                CellButton.Height);
                        CellButton.DrawToBitmap(bmp, new Rectangle(0, 0, 
                                bmp.Width, bmp.Height));
                        e.Graphics.DrawImage(bmp, 
                          new Point((int)ColumnLefts[i], tmpTop));
                    }
                    // For the CheckBox Column
                    else if (((Type) ColumnTypes[i]).Name == 
                              "DataGridViewCheckBoxColumn")
                    {
                        CellCheckBox.Size = new Size(14, 14);
                        CellCheckBox.Checked = (bool)Cel.Value;
                        Bitmap bmp = new Bitmap((int)ColumnWidths[i], 
                                                 CellHeight);
                        Graphics tmpGraphics = Graphics.FromImage(bmp);
                        tmpGraphics.FillRectangle(Brushes.White, 
                                new Rectangle(0, 0, 
                                bmp.Width, bmp.Height));
                        CellCheckBox.DrawToBitmap(bmp, 
                                new Rectangle((int)((bmp.Width - 
                                CellCheckBox.Width) / 2), 
                                (int)((bmp.Height - CellCheckBox.Height) / 2), 
                                CellCheckBox.Width, CellCheckBox.Height));
                        e.Graphics.DrawImage(bmp, 
                                new Point((int)ColumnLefts[i], tmpTop));
                    }
                    // For the ComboBox Column
                    else if (((Type) ColumnTypes[i]).Name == 
                              "DataGridViewComboBoxColumn")
                    {
                        CellComboBox.Size = new Size((int)ColumnWidths[i], 
                                                CellHeight);
                        Bitmap bmp = new Bitmap(CellComboBox.Width, 
                                                CellComboBox.Height);
                        CellComboBox.DrawToBitmap(bmp, new Rectangle(0, 0, 
                                bmp.Width, bmp.Height));
                        e.Graphics.DrawImage(bmp, 
                                new Point((int)ColumnLefts[i], tmpTop));
                        e.Graphics.DrawString(Cel.Value.ToString(), 
                                Cel.InheritedStyle.Font, 
                                new SolidBrush(Cel.InheritedStyle.ForeColor), 
                                new RectangleF((int)ColumnLefts[i] + 1, 
                                tmpTop, (int)ColumnWidths[i]
                                - 16, CellHeight), StrFormatComboBox);
                    }
                    // For the Image Column
                    else if (((Type) ColumnTypes[i]).Name == 
                              "DataGridViewImageColumn")
                    {
                        Rectangle CelSize = new Rectangle((int)ColumnLefts[i], 
                                tmpTop, (int)ColumnWidths[i], CellHeight);
                        Size ImgSize = ((Image)(Cel.FormattedValue)).Size;
                        e.Graphics.DrawImage((Image)Cel.FormattedValue, 
                                new Rectangle((int)ColumnLefts[i] + 
                                (int)((CelSize.Width - ImgSize.Width) / 2), 
                                tmpTop + (int)((CelSize.Height - 
                                ImgSize.Height) / 2), 
                                ((Image)(Cel.FormattedValue)).Width, 
                                ((Image)(Cel.FormattedValue)).Height));

                    }

                    // Drawing Cells Borders 
                    e.Graphics.DrawRectangle(Pens.Black, 
                            new Rectangle((int)ColumnLefts[i], 
                            tmpTop, (int)ColumnWidths[i], CellHeight));

                    i++;

                }
                tmpTop += CellHeight;
            }

            RowPos++;
            // For the first page it calculates Rows per Page
            if (PageNo == 1) RowsPerPage++;
        }

        if (RowsPerPage == 0) return;

        // Write Footer (Page Number)
        DrawFooter(e, RowsPerPage);

        e.HasMorePages = false;
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message, "Error", 
                        MessageBoxButtons.OK, 
                        MessageBoxIcon.Error);
    }
}

History

Two bugs fixed (22 Feb 2007):

  • The number of pages in the C# code was wrong.
  • For the pages after the first page, the column headers were overwriting the first row ( both in the C# code and the VB code).

License

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


Written By
Web Developer
Iran (Islamic Republic of) Iran (Islamic Republic of)
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions

 
QuestionUndefined How to fix Pin
Member 124643744-Nov-20 23:20
Member 124643744-Nov-20 23:20 
QuestionNew point on DatagridView Pin
Aggelos Tzitzifas8-Feb-18 10:03
Aggelos Tzitzifas8-Feb-18 10:03 
Questioncustom selection of columns Pin
Member 1134024214-Jul-17 6:54
Member 1134024214-Jul-17 6:54 
AnswerFor those who are Unable to print the selected rows Pin
Member 1284257612-Dec-16 19:06
Member 1284257612-Dec-16 19:06 
QuestionUnable to print the selected rows Pin
Gaziuddin3-Nov-16 20:06
Gaziuddin3-Nov-16 20:06 
AnswerRe: Unable to print the selected rows Pin
Member 1284257612-Dec-16 19:02
Member 1284257612-Dec-16 19:02 
Questionselected rows not printing any row pls help me Pin
vijayaraj1323-Jun-16 3:04
vijayaraj1323-Jun-16 3:04 
QuestionRows height Pin
Member 1218567511-Jan-16 6:34
Member 1218567511-Jan-16 6:34 
QuestionGreat! Pin
Member 1209579517-Dec-15 18:44
Member 1209579517-Dec-15 18:44 
QuestionLandscape Pin
m@r1014-Aug-15 20:43
m@r1014-Aug-15 20:43 
QuestionLandscape print Pin
m@r1014-Aug-15 20:40
m@r1014-Aug-15 20:40 
Questioncan we use excel file as database insisted of access Pin
Member 1027329324-Jul-15 21:23
Member 1027329324-Jul-15 21:23 
QuestionSir Two Questions Pin
Rose4203-Oct-14 1:43
Rose4203-Oct-14 1:43 
QuestionSelect Printer Pin
Member 102755607-Sep-14 16:58
Member 102755607-Sep-14 16:58 
Questionquestion Pin
Member 109300397-Jul-14 7:49
Member 109300397-Jul-14 7:49 
QuestionDataGridView Cell is empty -> object reference not set to an instance of an object Pin
Member 885789712-Feb-14 3:32
Member 885789712-Feb-14 3:32 
AnswerRe: DataGridView Cell is empty -> object reference not set to an instance of an object Pin
Member 885789712-Feb-14 20:18
Member 885789712-Feb-14 20:18 
QuestionRe: DataGridView Cell is empty -> object reference not set to an instance of an object Pin
Member 1031538613-Nov-16 18:36
professionalMember 1031538613-Nov-16 18:36 
GeneralRe: DataGridView Cell is empty -> object reference not set to an instance of an object Pin
Member 1299661614-Mar-17 21:59
Member 1299661614-Mar-17 21:59 
QuestionNice post Pin
Tridip Bhattacharjee12-Dec-13 21:50
professionalTridip Bhattacharjee12-Dec-13 21:50 
QuestionDataGridView Printing by Selecting Columns and Rows Pin
Cheeky22-Sep-13 10:20
Cheeky22-Sep-13 10:20 
SuggestionDataGridView Printing by Selecting Columns and Rows Pin
Cheeky22-Sep-13 10:18
Cheeky22-Sep-13 10:18 
Questionhow can I adjust size of cells? Pin
babak146-Sep-13 1:45
babak146-Sep-13 1:45 
QuestionAfra, I have could you email me? Pin
Steve_Scott111-Jun-13 23:30
Steve_Scott111-Jun-13 23:30 
Generalawesome Pin
ajit_machhe2-Jun-13 9:47
ajit_machhe2-Jun-13 9:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.