Description: 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.
File list (Check if you may need any files):
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
Download