文件名称:AccessGuideExcel
- 所属分类:
- C#编程
- 资源属性:
- [Windows] [Visual.Net] [源码]
- 上传时间:
- 2013-05-13
- 文件大小:
- 22kb
- 下载次数:
- 0次
- 提 供 者:
- zpu****
- 相关连接:
- 无
- 下载说明:
- 别用迅雷下载,失败请重下,重下不扣分!
介绍说明--下载内容均来自于网络,请自行研究使用
本实例将引导你如何使用C#将Access数据导入到Excel中,这一系列过程包括:定义字符串,记录连接Access的语句,定义OleDbCommand类,打开连接的Access数据库,设置SQL语句,获取记录个数,实例化OleDbCommand类,执行SQL语句,并返回结果(每个Sheet只能最多保存65536条记录),记录连接Excel的语句,实例化OleDbCommand类,执行SQL语句,将数据表的内容导入到Excel中,关闭连接,释放资源等。您可以借此程序学习一下C#与Access数据为的连接。-This example will guide you how to use C# Access data into Excel, during this series include: custom string recorded statement to connect Access, defined OleDbCommand class, open the Access database connection, sets an SQL statement to get record number instance of the OleDbCommand class, execute SQL statements, and returns the result (each Sheet can only save up to 65,536 records) records to connect to the Excel statement the instance the OleDbCommand of class, execute SQL statements, the table of contents of the data imported into Excel close the connection, release resources. You can take this program to learn C# and Access data connection.
(系统自动生成,下载前可以参看下载内容)
下载文件列表
AccessGuideExcel\AccessGuideExcel\AccessGuideExcel.csproj
................\................\bin\Debug\db1.mdb
................\................\Form1.cs
................\................\Form1.Designer.cs
................\................\Form1.resx
................\................\Program.cs
................\................\...perties\AssemblyInfo.cs
................\................\..........\Resources.Designer.cs
................\................\..........\Resources.resx
................\................\..........\Settings.Designer.cs
................\................\..........\Settings.settings
................\AccessGuideExcel.sln
................\AccessGuideExcel.suo
................\................\bin\Debug
................\................\bin
................\................\Properties
................\AccessGuideExcel
AccessGuideExcel