打印DataGridView中的内容

最新推荐文章于 2020-05-24 19:36:31 发布
最新推荐文章于 2020-05-24 19:36:31 发布
阅读量1.1k 收藏 1
点赞数
分类专栏： 其他 文章标签： exception printing object string float datagrid 
using System;
using System.Collections.Generic;
using System.Windows.Forms;
using System.Drawing;
using System.Collections;
using System.Data;
using System.Text;
 
 
namespace DgPrint
{
public class PrintService
{
private StringFormat StrFormat; // Holds content of a TextBox Cell to write by DrawString
private int RowPos;
 
// Position of currentlyprinting row
private bool NewPage;
 
// Indicates if a new page reached
private int PageNo;
 
// Number of pages to print
private int CellHeight;
 
// Height of DataGrid Cell
private int RowsPerPage;
 
// Number of Rows per Page
private System.Drawing.Printing.PrintDocument printDoc =
new System.Drawing.Printing.PrintDocument(); // PrintDocumnet Object used for printing
private ArrayList ColumnLefts = new ArrayList(); // Left Coordinate of Columns
private ArrayList ColumnWidths = new ArrayList(); // Width of Columns
private string PrintTitle = ""; // Header of pages
private DataTable dgv;
 
// Holds DataGridView Object to print its contents
private List<string> AvailableColumns = new List<string>(); // All Columns avaiable in DataGrid
private int HeaderHeight = 0;
private Dictionary<string, int> ColWith;
public void Print(DataTable tab, string Title, Dictionary<string, int> colWith)
{
PrintPreviewDialog ppvw;
try
{
// Getting DataGridView object to print
dgv = tab;
ColWith = colWith;
// Getting all Coulmns Names in the DataGridView
AvailableColumns.Clear();
foreach (DataColumn c in dgv.Columns)
{
AvailableColumns.Add(c.ColumnName);
}
 
// Showing the PrintOption Form
 
PrintTitle = Title;
 
RowsPerPage = 0;
printDoc.DocumentName = " ";
PrintDialog dia = new PrintDialog();
dia.PrintToFile = false;
dia.Document = printDoc;
dia.UseEXDialog = true;
if (dia.ShowDialog() != DialogResult.OK) return;
ppvw = new PrintPreviewDialog();
ppvw.WindowState = FormWindowState.Maximized;
ppvw.Document = printDoc;
 
// Showing the Print Preview Page
printDoc.BeginPrint += new System.Drawing.Printing.PrintEventHandler(PrintDoc_BeginPrint);
printDoc.PrintPage += new System.Drawing.Printing.PrintPageEventHandler(PrintDoc_PrintPage);
if (ppvw.ShowDialog() != DialogResult.OK)
{
printDoc.BeginPrint -= new System.Drawing.Printing.PrintEventHandler(PrintDoc_BeginPrint);
printDoc.PrintPage -= new System.Drawing.Printing.PrintPageEventHandler(PrintDoc_PrintPage);
return;
}
 
// Printing the Documnet
printDoc.Print();
printDoc.BeginPrint -= new System.Drawing.Printing.PrintEventHandler(PrintDoc_BeginPrint);
printDoc.PrintPage -= new System.Drawing.Printing.PrintPageEventHandler(PrintDoc_PrintPage);
}
catch (Exception ex)
{
 
}
finally
{
 
}
}
 
private DataGridView grid;
public void Print(DataGridView grid, string Title)
{
PrintPreviewDialog ppvw;
try
{
// Getting DataGridView object to print
this.grid = grid;
// Getting all Coulmns Names in the DataGridView
AvailableColumns.Clear();
foreach (DataGridViewColumn c in grid.Columns)
{
if (c.Visible)
AvailableColumns.Add(c.HeaderText);
}
 
// Showing the PrintOption Form
 
PrintTitle = Title;
 
RowsPerPage = 0;
printDoc.DocumentName = " ";
PrintDialog dia = new PrintDialog();
dia.PrintToFile = false;
dia.Document = printDoc;
dia.UseEXDialog = true;
if (dia.ShowDialog() != DialogResult.OK) return;
ppvw = new PrintPreviewDialog();
ppvw.WindowState = FormWindowState.Maximized;
ppvw.Document = printDoc;
 
// Showing the Print Preview Page
printDoc.BeginPrint += new System.Drawing.Printing.PrintEventHandler(PrintGridDoc_BeginPrint);
printDoc.PrintPage += new System.Drawing.Printing.PrintPageEventHandler(PrintGridDoc_PrintPage);
if (ppvw.ShowDialog() != DialogResult.OK)
{
printDoc.BeginPrint -= new System.Drawing.Printing.PrintEventHandler(PrintGridDoc_BeginPrint);
printDoc.PrintPage -= new System.Drawing.Printing.PrintPageEventHandler(PrintGridDoc_PrintPage);
return;
}
 
// Printing the Documnet
printDoc.Print();
printDoc.BeginPrint -= new System.Drawing.Printing.PrintEventHandler(PrintGridDoc_BeginPrint);
printDoc.PrintPage -= new System.Drawing.Printing.PrintPageEventHandler(PrintGridDoc_PrintPage);
}
catch (Exception ex)
{
 
}
finally
{
 
}
}
 
private void PrintGridDoc_BeginPrint(object sender,
System.Drawing.Printing.PrintEventArgs e)
{
try
{
StrFormat = new StringFormat();
StrFormat.Alignment = StringAlignment.Near;
StrFormat.LineAlignment = StringAlignment.Center;
StrFormat.Trimming = StringTrimming.EllipsisCharacter;
 
ColumnLefts.Clear();
ColumnWidths.Clear();
CellHeight = 0;
RowsPerPage = 0;
 
 
PageNo = 1;
NewPage = true;
RowPos = 0;
}
catch (Exception ex)
{
 
}
}
 
private void PrintGridDoc_PrintPage(object sender,
System.Drawing.Printing.PrintPageEventArgs e)
{
int tmpWidth, i;
int tmpTop = e.MarginBounds.Top;
int tmpLeft = e.MarginBounds.Left;
Font font = new Font("宋体", 9);
try
{
// Before starting first page, it saves Width & Height of Headers and CoulmnType
if (PageNo == 1)
{
foreach (DataGridViewColumn GridCol in grid.Columns)
{
// Skip if the current column not selected
 
// Detemining whether the columns are fitted to page or not.
if (GridCol.Visible)
{
tmpWidth = GridCol.Width;
HeaderHeight = 33;
 
// Save width & height of headres and ColumnType
ColumnLefts.Add(tmpLeft);
ColumnWidths.Add(tmpWidth);
tmpLeft += tmpWidth;
}
}
}
 
// Printing Current Page, Row by Row
while (RowPos <= grid.Rows.Count - 1)
{
DataGridViewRow GridRow = grid.Rows[RowPos];
 
CellHeight = 22;
 
if (tmpTop + CellHeight >= e.MarginBounds.Height + e.MarginBounds.Top)
{
DrawGridFooter(e, RowsPerPage);
NewPage = true;
PageNo++;
e.HasMorePages = true;
return;
}
else
{
if (NewPage)
{
// Draw Header
e.Graphics.DrawString(PrintTitle, new Font(font, FontStyle.Bold),
Brushes.Black, e.MarginBounds.Left, e.MarginBounds.Top -
e.Graphics.MeasureString(PrintTitle, new Font(font,
FontStyle.Bold), e.MarginBounds.Width).Height - 13);
 
String s = DateTime.Now.ToLongDateString() + " " + DateTime.Now.ToShortTimeString();
 
e.Graphics.DrawString(s, new Font(font, FontStyle.Bold),
Brushes.Black, e.MarginBounds.Left + (e.MarginBounds.Width -
e.Graphics.MeasureString(s, new Font(font,
FontStyle.Bold), e.MarginBounds.Width).Width), e.MarginBounds.Top -
e.Graphics.MeasureString(PrintTitle, new Font(new Font(font,
FontStyle.Bold), FontStyle.Bold), e.MarginBounds.Width).Height - 13);
 
// Draw Columns
tmpTop = e.MarginBounds.Top;
i = 0;
foreach (DataGridViewColumn GridCol in grid.Columns)
{
 
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, font,
new SolidBrush(Color.Black),
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)
{
e.Graphics.DrawString(Cel.Value.ToString(), font,
new SolidBrush(Color.Black),
new RectangleF((int)ColumnLefts[i], (float)tmpTop,
(int)ColumnWidths[i], (float)CellHeight), StrFormat);
// 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)
DrawGridFooter(e, RowsPerPage);
 
e.HasMorePages = false;
printDoc.DocumentName = PrintTitle;
}
catch (Exception ex)
{
 
}
}
 
private void DrawGridFooter(System.Drawing.Printing.PrintPageEventArgs e,
int RowsPerPage)
{
double cnt = 0;
 
 
cnt = grid.Rows.Count; // When the DataGridView allows adding rows
 
// Writing the Page Number on the Bottom of Page
string PageNum = " 第 " + PageNo.ToString()
+ " 页，共 " + Math.Ceiling((double)(cnt / RowsPerPage)).ToString()
+ " 页";
Font font = new Font("宋体", 9);
e.Graphics.DrawString(PageNum, font, Brushes.Black,
e.MarginBounds.Left + (e.MarginBounds.Width -
e.Graphics.MeasureString(PageNum, font,
e.MarginBounds.Width).Width) / 2, e.MarginBounds.Top +
e.MarginBounds.Height + 31);
}
 
private void PrintDoc_BeginPrint(object sender,
System.Drawing.Printing.PrintEventArgs e)
{
try
{
StrFormat = new StringFormat();
StrFormat.Alignment = StringAlignment.Near;
StrFormat.LineAlignment = StringAlignment.Center;
StrFormat.Trimming = StringTrimming.EllipsisCharacter;
 
ColumnLefts.Clear();
ColumnWidths.Clear();
CellHeight = 0;
RowsPerPage = 0;
 
 
PageNo = 1;
NewPage = true;
RowPos = 0;
}
catch (Exception ex)
{
 
}
}
 
private void PrintDoc_PrintPage(object sender,
System.Drawing.Printing.PrintPageEventArgs e)
{
int tmpWidth, i;
int tmpTop = e.MarginBounds.Top;
int tmpLeft = e.MarginBounds.Left;
Font font = new Font("宋体", 9);
try
{
// Before starting first page, it saves Width & Height of Headers and CoulmnType
if (PageNo == 1)
{
foreach (DataColumn GridCol in dgv.Columns)
{
// Skip if the current column not selected
 
// Detemining whether the columns are fitted to page or not.
if (ColWith.ContainsKey(GridCol.ColumnName))
tmpWidth = ColWith[GridCol.ColumnName];
else
tmpWidth = 100;
HeaderHeight = 33;
 
// Save width & height of headres and ColumnType
ColumnLefts.Add(tmpLeft);
ColumnWidths.Add(tmpWidth);
tmpLeft += tmpWidth;
}
}
 
// Printing Current Page, Row by Row
while (RowPos <= dgv.Rows.Count - 1)
{
DataRow GridRow = dgv.Rows[RowPos];
 
CellHeight = 22;
 
if (tmpTop + CellHeight >= e.MarginBounds.Height + e.MarginBounds.Top)
{
DrawFooter(e, RowsPerPage);
NewPage = true;
PageNo++;
e.HasMorePages = true;
return;
}
else
{
if (NewPage)
{
// Draw Header
e.Graphics.DrawString(PrintTitle, new Font(font, FontStyle.Bold),
Brushes.Black, e.MarginBounds.Left, e.MarginBounds.Top -
e.Graphics.MeasureString(PrintTitle, new Font(font,
FontStyle.Bold), e.MarginBounds.Width).Height - 13);
 
String s = DateTime.Now.ToLongDateString() + " " + DateTime.Now.ToShortTimeString();
 
e.Graphics.DrawString(s, new Font(font, FontStyle.Bold),
Brushes.Black, e.MarginBounds.Left + (e.MarginBounds.Width -
e.Graphics.MeasureString(s, new Font(font,
FontStyle.Bold), e.MarginBounds.Width).Width), e.MarginBounds.Top -
e.Graphics.MeasureString(PrintTitle, new Font(new Font(font,
FontStyle.Bold), FontStyle.Bold), e.MarginBounds.Width).Height - 13);
 
// Draw Columns
tmpTop = e.MarginBounds.Top;
i = 0;
foreach (DataColumn GridCol in dgv.Columns)
{
 
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.ColumnName, font,
new SolidBrush(Color.Black),
new RectangleF((int)ColumnLefts[i], tmpTop,
(int)ColumnWidths[i], HeaderHeight), StrFormat);
i++;
}
NewPage = false;
tmpTop += HeaderHeight;
}
 
// Draw Columns Contents
i = 0;
foreach (Object Cel in GridRow.ItemArray)
{
e.Graphics.DrawString(Cel.ToString(), font,
new SolidBrush(Color.Black),
new RectangleF((int)ColumnLefts[i], (float)tmpTop,
(int)ColumnWidths[i], (float)CellHeight), StrFormat);
// 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;
printDoc.DocumentName = PrintTitle;
}
catch (Exception ex)
{
 
}
}
 
private void DrawFooter(System.Drawing.Printing.PrintPageEventArgs e,
int RowsPerPage)
{
double cnt = 0;
 
 
cnt = dgv.Rows.Count; // When the DataGridView allows adding rows
 
// Writing the Page Number on the Bottom of Page
string PageNum = " 第 " + PageNo.ToString()
+ " 页，共 " + Math.Ceiling((double)(cnt / RowsPerPage)).ToString()
+ " 页";
Font font = new Font("宋体", 9);
e.Graphics.DrawString(PageNum, font, Brushes.Black,
e.MarginBounds.Left + (e.MarginBounds.Width -
e.Graphics.MeasureString(PageNum, font,
e.MarginBounds.Width).Width) / 2, e.MarginBounds.Top +
e.MarginBounds.Height + 31);
}
}
}

liujf
关注
专栏目录
DataGridView控件中数据表打印文档
qq_30725967的博客
12-25 557
C# DataGridView控件中数据表打印文档 一、打印类定义： using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Drawing; using System.Drawing.Printing; using System.Windows.For...
C#里面DataGridView控件数据打印
07-10
使用DataGridView控件里面的数据打印，包含条码显示打印
打印dataGridView中的数据
熊小屁的专栏
05-09 670
//执行打印窗体中的数据操作private void toolStripButton2_Click(object sender, EventArgs e){printDialog1.ShowDialog(); //设置打印文档printPreviewDialog1.Document = this.printDocument1;printPreviewDialog1.ShowDialog()
一个DATAGRIDVIEW的打印类
luckisok的专栏
05-08 746
using System;using System.Text;using System.Collections;using System.Collections.Generic;using System.Drawing;using System.Drawing.Printing;using System.Data;using System.Windows.Forms;class DataGri
vb.net如何打印dataGridview中的数据
11-06
参照：http://www.codeproject.com/KB/grid/PrintDataGrid_CS.aspx
dataGridView内容打印实例VS2010版
11-27
dataGridView内容打印实例VS2010版
Winform中打印 dataGridView里的内容
刘欢的博客
07-01 4350
//调用GridPrinter 首先添加一个printDocument控件并激活其printDocument_PrintPage事件写： 实例化类GridPrinter gridPrinter; private void printDocument_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e) ...
C# 打印DataGridView的实现(完整实例)
11-02
本实例将详细讲解如何实现C#中打印`DataGridView`的功能，包括设置不同的打印样式、支持多页打印以及保证打印效果美观、可靠。 首先，我们需要引入`System.Drawing.Printing`命名空间，它包含了用于打印操作的相关...
C#万能打印--winform中打印dataGridView表格
06-22
1.在解决方案中添加现有项目DLLFullPrint，然后在主工程中添加引用，引用这个项目。 2.在界面设计中，添加按钮PrintButton，双击它进入代码界面； 在代码文件中，首先使用using DLLFullPrint; 然后按钮点击事件中...
datagridview中的数据直接进行打印预览
05-17
如何可以将datagridview中的数据直接进行打印预览 ,网上收集的资料，还没有经过测试
VB.net DataGridView 打印控件
01-25
VB.net DataGridView 打印控件，源码一起。互相学习
C# dataGridView打印控件，可以打印dataGridView中的数据，同时可以把dataGridView数据导出到EXCEL中(源码)
12-19
用一个基于PrintDocument来完成的对DataGridVeiw中显示的数据进行打印的控件。同时，提供了把dataGridView中的数据导出到EXCEL中。 源码示例。。。
DataGridView打印。打印预览解决方案-第一部分
01-16
DataGridView打印。打印预览解决方案-第一部分
vb.net DataGridView 预览打印
05-31
vb.net DataGridView 打印预览及调用打印机方面的源码
[VB.NET] - 打印DataGridView类
weixin_30779691的博客
03-18 300
Imports System.Drawing.PrintingPublic Class PrintDataGridView Private WithEvents PrintDocument1 As New Printing.PrintDocument Private WithEvents PageSetupDialog1 As New System.Windows.Forms.Pa...
DataGridView打印代码分享（VB.NET)
huanghai231的博客
05-23 1474
@TOC) 创建一个类。 Namespace DgPrint Public Class ClassPrint Private StrFormat As StringFormat '单元格内容 Private RowPos As Integer '当前打印行 Pri...
VB.Net 2008打印DataGridView（文本换行顶部标题列和宽度锁定）
IT与开发人员的地盘
05-24 365
我正在使用VB.Net 2008应用程序。 我正在使用DataGridView。 我有一个打印选项，在这里我需要打印DataGridView。 我将此代码用于“打印”和“打印预览”。 DimMyDataGridViewPrinterAsDataGridViewPrinter PrivateFunctionSetupThePrinting()AsBoolea...
打印DataGridView内容的类
fstanwh的专栏
06-21 876
using System; using System.Collections.Generic; using System.Text; using System.Windows.Forms; using System.Drawing.Printing; using System.Drawing; namespace 数据导出 { public class Printer {
C# 实现 DataGridView 打印类
"C#中用于打印DataGridView控件的类" 在C#编程中，当需要将数据从DataGridView控件导出或打印到纸上时，我们可以自定义一个类来实现这个功能。给定的代码示例展示了一个名为`PrintDataGridView`的类，这个类提供了...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值