SqlHelper源码及使用实例



SqlHelper是非常方便的数据库操作函数，功能强大，使用起来非常简单，免去很多复杂的数据库操作的代码，在多层应用及面向对象开发中都有很多应用



SqlHelper源码带有详细的说明，示例中有51aspx原始的示例Sql语句



主要包括以下操作：



简单SQL语句(ExcuteSql)

带参数的简单SQL语句(ExcuteSQLParm)

简单存储过程 (ExcuteProc)

带参数的存储过程(ExcuteProcParm)

只返回一个字段 (ExcuteScalar)

返回数据集(ExcuteReader)



数据库中有示例数据及存储过程updateTable\updateTableByParm，大家可以自行修改测试，转载请保留51aspx作者信息，谢谢！



1.修改ExcuteSQLParm，加入传多个参数的例子

2.对执行SQL加入了错误捕获，当执行出错时，显示SQL语句，方便调试

VS2005+SQL2005 -SqlHelper source and use cases



SqlHelper is very convenient database operations functions, powerful, easy to use, remove a number of complex database operations of the code, in multi-tier application and have a lot of object-oriented application development



SqlHelper source with a detailed descr iption of the sample in the original sample Sql statement 51aspx



Include the following:



Simple SQL statement (ExcuteSql)

Simple SQL statement with parameter (ExcuteSQLParm)

Simple stored procedure (ExcuteProc)

Stored procedure with parameters (ExcuteProcParm)

Returns only one field (ExcuteScalar)

Return data set (ExcuteReader)



Database with sample data and stored procedures updateTable \ updateTableByParm, we can modify test, reproduced Keep 51aspx of information, thank you!



1. Modify ExcuteSQLParm, adding examples of pass multiple parameters

2. On the implementation of the SQL error trapping added that when implementation of the error, the display SQL stateme