Introduction - If you have any usage issues, please Google them yourself
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 description 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