-
大小: 439KB文件類型: .rar金幣: 2下載: 0 次發(fā)布日期: 2021-05-04
- 語(yǔ)言: C#
- 標(biāo)簽: DataGridView??分面顯示??
資源簡(jiǎn)介
用C#寫的實(shí)現(xiàn)DataGridView合并單元格、分頁(yè)顯示、頁(yè)面設(shè)置、打印和Excel導(dǎo)出功能,精典實(shí)例,可以直接使用。如在使用過程中有問題或改進(jìn),可以發(fā)Email:liubingchao@126.com;互相交流與學(xué)習(xí)。

代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Windows.Forms;
using?liubingchao.DataGridViewPrint;
using?System.Drawing.Printing;
namespace?DataGridViewCz
{
????public?partial?class?DataGridViewCz?:?Form
????{
????????int?pageSize?=?0;?????//每頁(yè)顯示行數(shù)
????????int?nMax?=?0;?????????//總記錄數(shù)
????????int?pageCount?=?0;????//頁(yè)數(shù)=總記錄數(shù)/每頁(yè)顯示行數(shù)
????????int?pageCurrent?=?0;???//當(dāng)前頁(yè)號(hào)
????????int?nCurrent?=?0;??????//當(dāng)前記錄行
????????DataSet?ds?=?new?DataSet();
????????System.Data.DataTable?dtInfo?=?new?System.Data.DataTable();
????????public?DataGridViewCz()
????????{
????????????InitializeComponent();
????????}
????????#region?窗體load事件,加載數(shù)據(jù)(用戶可從數(shù)據(jù)庫(kù)中直接讀取數(shù)據(jù))
????????private?void?DataGridViewCz_Load(object?sender?EventArgs?e)
????????{
????????????dataGridView1.RowCount?=?10;
????????????dataGridView1.Rows[0].Cells[0].Value?=?“電腦“;
????????????dataGridView1.Rows[1].Cells[0].Value?=?“電腦“;
????????????dataGridView1.Rows[2].Cells[0].Value?=?“電腦“;
????????????dataGridView1.Rows[3].Cells[0].Value?=?“電腦“;
????????????dataGridView1.Rows[4].Cells[0].Value?=?“電視機(jī)“;
????????????dataGridView1.Rows[5].Cells[0].Value?=?“電視機(jī)“;
????????????dataGridView1.Rows[6].Cells[0].Value?=?“電視機(jī)“;
????????????dataGridView1.Rows[7].Cells[0].Value?=?“冰箱“;
????????????dataGridView1.Rows[8].Cells[0].Value?=?“冰箱“;
????????????dataGridView1.Rows[9].Cells[0].Value?=?“冰箱“;
????????????dataGridView1.Rows[0].Cells[1].Value?=?“聯(lián)想“;
????????????dataGridView1.Rows[1].Cells[1].Value?=?“惠普“;
????????????dataGridView1.Rows[2].Cells[1].Value?=?“三星“;
????????????dataGridView1.Rows[3].Cells[1].Value?=?“戴爾“;
????????????dataGridView1.Rows[4].Cells[1].Value?=?“長(zhǎng)虹“;
????????????dataGridView1.Rows[5].Cells[1].Value?=?“創(chuàng)維“;
????????????dataGridView1.Rows[6].Cells[1].Value?=?“海爾“;
????????????dataGridView1.Rows[7].Cells[1].Value?=?“海信“;
????????????dataGridView1.Rows[8].Cells[1].Value?=?“海爾“;
????????????dataGridView1.Rows[9].Cells[1].Value?=?“新飛“;
????????????dataGridView1.Rows[0].Cells[2].Value?=?“5600“;
????????????dataGridView1.Rows[1].Cells[2].Value?=?“4800“;
????????????dataGridView1.Rows[2].Cells[2].Value?=?“3600“;
????????????dataGridView1.Rows[3].Cells[2].Value?=?“2400“;
????????????dataGridView1.Rows[4].Cells[2].Value?=?“3800“;
????????????dataGridView1.Rows[5].Cells[2].Value?=?“3200“;
????????????dataGridView1.Rows[6].Cells[2].Value?=?“2800“;
????????????dataGridView1.Rows[7].Cells[2].Value?=?“2400“;
????????????dataGridView1.Rows[8].Cells[2].Value?=?“2000“;
????????????dataGridView1.Rows[9].Cells[2].Value?=?“1600“;
????????????dataGridView1.Rows[0].Cells[3].Value?=?“山東“;
????????????dataGridView1.Rows[1].Cells[3].Value?=?“北京“;
????????????dataGridView1.Rows[2].Cells[3].Value?=?“上海“;
????????????dataGridView1.Rows[3].Cells[3].Value?=?“廣東“;
????????????dataGridView1.Rows[4].Cells[3].Value?=?“北京“;
????????????dataG
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件??????63488??2011-02-19?15:26??DataGridView\DataGridViewCz\DataGridViewCz\bin\Debug\DataGridViewCz.exe
?????文件??????67072??2011-02-19?15:26??DataGridView\DataGridViewCz\DataGridViewCz\bin\Debug\DataGridViewCz.pdb
?????文件??????14328??2011-02-19?15:26??DataGridView\DataGridViewCz\DataGridViewCz\bin\Debug\DataGridViewCz.vshost.exe
?????文件????1276720??2007-10-10?09:49??DataGridView\DataGridViewCz\DataGridViewCz\bin\Debug\Microsoft.Office.Interop.Excel.dll
?????文件??????64288??2007-10-10?09:49??DataGridView\DataGridViewCz\DataGridViewCz\bin\Debug\Microsoft.Vbe.Interop.dll
?????文件?????416544??2007-10-10?09:49??DataGridView\DataGridViewCz\DataGridViewCz\bin\Debug\office.dll
?????文件????????448??2011-02-19?15:17??DataGridView\DataGridViewCz\DataGridViewCz\bin\Debug\PageSettings.xm
?????文件??????17707??2011-02-19?15:26??DataGridView\DataGridViewCz\DataGridViewCz\DataGridViewCz.cs
?????文件???????4369??2011-02-19?15:20??DataGridView\DataGridViewCz\DataGridViewCz\DataGridViewCz.csproj
?????文件??????35636??2011-02-19?15:24??DataGridView\DataGridViewCz\DataGridViewCz\DataGridViewCz.Designer.cs
?????文件??????11130??2011-02-19?15:24??DataGridView\DataGridViewCz\DataGridViewCz\DataGridViewCz.resx
?????文件???????5504??2011-02-19?15:16??DataGridView\DataGridViewCz\DataGridViewCz\DataOperation.cs
?????文件???????1335??2011-02-19?15:26??DataGridView\DataGridViewCz\DataGridViewCz\obj\Debug\DataGridViewCz.csproj.FileListAbsolute.txt
?????文件????????921??2011-02-19?15:26??DataGridView\DataGridViewCz\DataGridViewCz\obj\Debug\DataGridViewCz.csproj.GenerateResource.Cache
?????文件???????2753??2011-02-19?15:26??DataGridView\DataGridViewCz\DataGridViewCz\obj\Debug\DataGridViewCz.DataGridViewCz.resources
?????文件??????63488??2011-02-19?15:26??DataGridView\DataGridViewCz\DataGridViewCz\obj\Debug\DataGridViewCz.exe
?????文件??????67072??2011-02-19?15:26??DataGridView\DataGridViewCz\DataGridViewCz\obj\Debug\DataGridViewCz.pdb
?????文件????????180??2011-02-19?15:20??DataGridView\DataGridViewCz\DataGridViewCz\obj\Debug\DataGridViewCz.Properties.Resources.resources
?????文件??????14108??2011-02-19?15:20??DataGridView\DataGridViewCz\DataGridViewCz\obj\Debug\liubingchao.DataGridViewPrint.PrintOptions.resources
?????文件???????9879??2011-02-19?15:20??DataGridView\DataGridViewCz\DataGridViewCz\obj\Debug\ResolveAssemblyReference.cache
?????文件??????30934??2011-02-19?15:16??DataGridView\DataGridViewCz\DataGridViewCz\PrintDGV.cs
?????文件???????1735??2011-02-18?08:40??DataGridView\DataGridViewCz\DataGridViewCz\PrintOptions.cs
?????文件??????11465??2011-02-18?08:40??DataGridView\DataGridViewCz\DataGridViewCz\PrintOptions.designer.cs
?????文件??????26424??2011-02-18?08:40??DataGridView\DataGridViewCz\DataGridViewCz\PrintOptions.resx
?????文件???????9472??2011-02-19?15:21??DataGridView\DataGridViewCz\DataGridViewCz\Program.cs
?????文件???????1368??2011-02-19?15:03??DataGridView\DataGridViewCz\DataGridViewCz\Properties\AssemblyInfo.cs
?????文件???????2878??2011-02-19?15:03??DataGridView\DataGridViewCz\DataGridViewCz\Properties\Resources.Designer.cs
?????文件???????5612??2011-02-19?15:03??DataGridView\DataGridViewCz\DataGridViewCz\Properties\Resources.resx
?????文件???????1099??2011-02-19?15:03??DataGridView\DataGridViewCz\DataGridViewCz\Properties\Settings.Designer.cs
?????文件????????249??2011-02-19?15:03??DataGridView\DataGridViewCz\DataGridViewCz\Properties\Settings.settings
............此處省略15個(gè)文件信息
評(píng)論
共有 條評(píng)論