Description: This example demonstrates the use of C# Operation method of MySQL to provide three types of reusable MySqlDBUtil, MySqlPageUtil, Page. Demonstrated the routine: 1.MySQL database insert, update, modify, query 2. The sql statement with parameter use, rather than fight SQL 3. The use of Limit clause paging query 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 kinds of data types Boolean operations 7. use regular expressions to verify integer and real numbers 8.listview used to display some of the basic usage data.
File list (Check if you may need any files):
MySqlDBUtilDemo
...............\AssemblyInfo.cs
...............\bin
...............\...\Debug
...............\...\Release
...............\lib
...............\...\MySql.Data.dll
...............\MainForm.cs
...............\MainForm.Designer.cs
...............\MainForm.resx
...............\MySqlDBUtil.cs
...............\MySqlDBUtilDemo.csproj
...............\MySqlDBUtilDemo.sln
...............\MySqlPageUtil.cs
...............\Page.cs
...............\PageQueryDao.cs
...............\Product.cs
...............\ProductDao.cs
...............\Program.cs
...............\readme.txt
...............\Validator.cs
Download