MySqlDBUtilDemo

所属分类:C#编程
开发工具:MultiPlatform
文件大小:198KB
下载次数:36
上传日期:2008-11-02 15:47:43
上 传 者chenshuqi24
说明:  本示例演示了用C#操作MySQL的方法,提供了三个可重用的类MySqlDBUtil,MySqlPageUtil,Page。 本例程演示了: 1.MySQL数据库的插入,更新,修改,查询; 2.带参数的sql语句的使用,而不是拼SQL; 3.使用Limit子句的分页查询; 4.用事务同时执行多个SQL语句; 5.在插入数据的同时返回最新的ID值; 6.整型,实型,字符串,日期型,布尔型五种数据类型的操作; 7.使用正则表达式来验证整数和实数; 8.listview用来显示数据的一些基本用法。
(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.)

文件列表:
MySqlDBUtilDemo\AssemblyInfo.cs (1095, 2008-01-05)
MySqlDBUtilDemo\lib\MySql.Data.dll (266240, 2007-08-22)
MySqlDBUtilDemo\MainForm.cs (7383, 2008-01-05)
MySqlDBUtilDemo\MainForm.Designer.cs (14122, 2008-01-04)
MySqlDBUtilDemo\MainForm.resx (5817, 2008-01-04)
MySqlDBUtilDemo\MySqlDBUtil.cs (5787, 2008-01-05)
MySqlDBUtilDemo\MySqlDBUtilDemo.csproj (2322, 2008-01-05)
MySqlDBUtilDemo\MySqlDBUtilDemo.sln (848, 2008-01-05)
MySqlDBUtilDemo\MySqlPageUtil.cs (801, 2008-01-05)
MySqlDBUtilDemo\Page.cs (984, 2008-01-04)
MySqlDBUtilDemo\PageQueryDao.cs (1772, 2008-01-05)
MySqlDBUtilDemo\Product.cs (863, 2007-12-25)
MySqlDBUtilDemo\ProductDao.cs (3278, 2008-01-05)
MySqlDBUtilDemo\Program.cs (636, 2007-12-17)
MySqlDBUtilDemo\Validator.cs (764, 2008-01-04)
MySqlDBUtilDemo\bin\Debug (0, 2008-01-05)
MySqlDBUtilDemo\bin\Release (0, 2008-01-05)
MySqlDBUtilDemo\bin (0, 2008-01-05)
MySqlDBUtilDemo\lib (0, 2008-01-05)
MySqlDBUtilDemo (0, 2008-01-05)

本程序使用SharpDevelop开发,在.net framework 2.0下编译运行通过。 你可以将此程序的代码以任意方式用于任何用途而不需要向作者支付报酬, 这意味着你清楚所用代码的功能并对此负责。 要运行示例,必须先执行create_product.sql创建表,并修改MySqlDBUtil中的connectionString Albert Song(http://www.albertsong.com) 2008-1-4

近期下载者

相关文件


收藏者