文件名称:AccessDBUtilDemo
- 所属分类:
- C#编程
- 资源属性:
- [Windows] [Visual.Net] [源码]
- 上传时间:
- 2012-11-26
- 文件大小:
- 191kb
- 下载次数:
- 0次
- 提 供 者:
- 陈**
- 相关连接:
- 无
- 下载说明:
- 别用迅雷下载,失败请重下,重下不扣分!
介绍说明--下载内容均来自于网络,请自行研究使用
本文介绍C#访问操作Access数据库的基础知识,并提供一个相关的例程。
本例程演示了:
1.Access数据库的插入,更新,修改,查询;
2.带参数的sql语句的使用,而不是拼SQL;
3.使用DataReader的分页查询,而不是用嵌套的SQL语句来分页;
4.用事务同时执行多个SQL语句;
5.在插入数据的同时返回最新的ID值;
6.整型,实型,字符串,日期型,布尔型五种数据类型的操作;
7.使用正则表达式来验证整数和实数;
8.listview用来显示数据的一些基本用法。
-This article describes the C# Visit to the operation of the basic knowledge of Access databases, and to provide a relevant routines. Demonstrated the routine: 1.Access database insert, update, modify, query 2. The sql statement with parameter use, rather than fight SQL 3. Use DataReader paging query, rather than using nested SQL statement to paging 4. with affairs at the same time to run multiple SQL statement 5. Insert data at the same time to return to the latest ID value 6. integer, real, string, date, type, five Boolean data type operations 7. to use regular expressions to validate integer and real numbers 8.listview data used to display some of the basic usage.
本例程演示了:
1.Access数据库的插入,更新,修改,查询;
2.带参数的sql语句的使用,而不是拼SQL;
3.使用DataReader的分页查询,而不是用嵌套的SQL语句来分页;
4.用事务同时执行多个SQL语句;
5.在插入数据的同时返回最新的ID值;
6.整型,实型,字符串,日期型,布尔型五种数据类型的操作;
7.使用正则表达式来验证整数和实数;
8.listview用来显示数据的一些基本用法。
-This article describes the C# Visit to the operation of the basic knowledge of Access databases, and to provide a relevant routines. Demonstrated the routine: 1.Access database insert, update, modify, query 2. The sql statement with parameter use, rather than fight SQL 3. Use DataReader paging query, rather than using nested SQL statement to paging 4. with affairs at the same time to run multiple SQL statement 5. Insert data at the same time to return to the latest ID value 6. integer, real, string, date, type, five Boolean data type operations 7. to use regular expressions to validate integer and real numbers 8.listview data used to display some of the basic usage.
(系统自动生成,下载前可以参看下载内容)
下载文件列表
AccessDBUtilDemo
................\AccessDBUtil.cs
................\AccessDBUtilDemo.csproj
................\AccessDBUtilDemo.sln
................\AccessPageUtil.cs
................\AssemblyInfo.cs
................\bin
................\...\Debug
................\...\Release
................\MainForm.cs
................\MainForm.Designer.cs
................\MainForm.resx
................\obj
................\...\AccessDBUtilDemo.csproj.FileList.txt
................\...\AccessDBUtilDemo.csproj.FileListAbsolute.txt
................\...\Debug
................\...\Release
................\Page.cs
................\PageQueryDao.cs
................\Product.cs
................\ProductDao.cs
................\Program.cs
................\readme.txt
................\Validator.cs
................\AccessDBUtil.cs
................\AccessDBUtilDemo.csproj
................\AccessDBUtilDemo.sln
................\AccessPageUtil.cs
................\AssemblyInfo.cs
................\bin
................\...\Debug
................\...\Release
................\MainForm.cs
................\MainForm.Designer.cs
................\MainForm.resx
................\obj
................\...\AccessDBUtilDemo.csproj.FileList.txt
................\...\AccessDBUtilDemo.csproj.FileListAbsolute.txt
................\...\Debug
................\...\Release
................\Page.cs
................\PageQueryDao.cs
................\Product.cs
................\ProductDao.cs
................\Program.cs
................\readme.txt
................\Validator.cs