在C#里实现DATAGRID的打印预览和打印

来源：ASPCool.com 作者：出处：巧巧读书 2007-05-21 进入讨论组

     很多人都在论坛里问，如何实现DATAGRID的打印预览和打印，现在我就把这方面的源代码告诉大家。这段代码也花费了我1个晚上的时间，呵呵！数据库是基于sql server2000自带的northwind。源代码如下：

  using System;
  using System.Drawing;
  using System.Collections;
  using System.ComponentModel;
  using System.Windows.Forms;
  using System.Data;
  using System.Data.OleDb;

  namespace DataGridPrint
  {
   /// <summary>
   /// Summary description for Form1.
   /// </summary>
   public class Form1 : System.Windows.Forms.Form
   {
   private System.Windows.Forms.Panel panel1;
   private System.Windows.Forms.DataGrid dgTest;
   private System.Windows.Forms.Button btnFillDataGrid;
   private System.Windows.Forms.MainMenu mnuFile;
   private System.Windows.Forms.MenuItem menuItem1;
   private System.Windows.Forms.MenuItem miPrintPreview;
   private System.Windows.Forms.MenuItem miPrint;
   private System.Windows.Forms.MenuItem menuItem4;
   private System.Windows.Forms.MenuItem miExit;
   private System.Windows.Forms.DataGridTableStyle dgtsCustomers;
   private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn1;
   private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn2;
   private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn3;
   private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn4;
   private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn6;
   private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn7;
   private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn8;
   private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn9;
   private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn10;
   private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn11;
   private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn5;
   private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;
   private System.Data.SqlClient.SqlCommand sqlSelectCommand1;
   private System.Data.SqlClient.SqlCommand sqlInsertCommand1;
   private System.Data.SqlClient.SqlCommand sqlUpdateCommand1;
   private System.Data.SqlClient.SqlCommand sqlDeleteCommand1;
   private System.Data.SqlClient.SqlConnection sqlConnection1;
   /// <summary>
   /// Required designer variable.
   /// </summary>
   private System.ComponentModel.Container components = null;

   public Form1()
   {
   //
   // Required for Windows Form Designer support
   //
   InitializeComponent();