基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：78630559

本次赞助数额为： 2 元　

支付宝支付

微信支付

   源码介绍

---

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Drawing.Printing;
namespace ColorDemo
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        //public DataSet ExecuteDataSet(string sql)
        //{
        //    string strCon = "server=.;Database=Northwind;uid=sa;pwd=123456";
        //    SqlConnection con = new SqlConnection(strCon);
        //    SqlCommand cmd = new SqlCommand(sql, con);
        //    SqlDataAdapter da = new SqlDataAdapter(cmd);
        //    DataSet ds = new DataSet();
        //    da.Fill(ds);
        //    con.Close();
        //    return ds;
        //}

        private void Form1_Load(object sender, EventArgs e)
        {
           // dgvInfo2.DataSource = ExecuteDataSet("select * from Products").Tables[0];
            OleDbConnection con1 = new OleDbConnection();
            con1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="   System.Windows.Forms.Application.StartupPath   "\\HeDao.mdb";
            con1.Open();
            string sql = "select * from 工程量估算";
            OleDbDataAdapter ad = new OleDbDataAdapter(sql, con1);
            DataTable dt = new DataTable();
            ad.Fill(dt);
            dgvInfo2.DataSource = dt.DefaultView;
            dgvInfo2.Refresh();
            con1.Close();
           
        }
         private void PrintDocument_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
        {
            
        }



        private void btnPrint_Click(object sender, EventArgs e)
        {
            //this.ppd.ShowDialog();
            this.pdGrid.ShowDialog();

        }

        private void printPreviewDialog1_Load(object sender, EventArgs e)
        {
        
        }

        private void PrintDataGridView_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
        {
           
        }

        private void pdGrid_PrintPage(object sender, PrintPageEventArgs e)
        {
            Font font = new Font("宋体", 12);
            SizeF s = e.Graphics.MeasureString("菜单信息", font);
            //Point offset = e.MarginBounds.Location;//e.MarginBounds用户的打印区域
            //e.Graphics.DrawString("菜单信息",font,Brushes.Black,new PointF(offset.X (e.MarginBounds.Width-s.Width)/2.0f,offset.Y));
            //offset.Offset(0,(int)Math.Round(s.Height) 10);
            //e.Graphics.DrawImage(
            e.Graphics.DrawString("菜单信息", font, Brushes.Red, 400, 20);
            e.Graphics.DrawString("时间"   DateTime.Now.ToLongDateString(), font, Brushes.Black, 20, 40);
            int x = 10;
            int y = 70;

            this.pdGrid.Print(dgvInfo2, true, e, ref x, ref y);    //注意：PrintDataGridView该类位于上面所写的业务逻辑层之中
        }

        private void button1_Click(object sender, EventArgs e)
        {
            PrintDGV.Print_DataGridView(this.dgvInfo2);
        }
    }
}