Sqlhelper User Guide

Abstract: Data Access Application Block is a. NET component that contains optimized Data Access code. It can help users call stored procedures and issue SQL text commands to SQL Server databases. It returns SqlDataReader, DataSet, and XmlReader objects. You can use it as a construction block in your. NET application to reduce the number of custom code that needs to be created, tested, and maintained. You can download the complete C # and Visual Basic. NET source code and comprehensive documentation.
Introduction
Are you engaged in the design and development of. NET application data access code? Do you think you are always writing the same data access code? Have you ever wrapped the data access code in the Helper function so that you can call stored procedures in one row? If so, Microsoft & reg; Data Access Application Block for. NET is designed for you.
Data Access Application Block encapsulates the best experience in accessing Microsoft SQL Server & #8482; database performance and resource management. You can easily use it as a constructor block in your. NET application, reducing the number of custom code that needs to be created, tested, and maintained from the page.
In particular, Data Access Application Block helps you:
Call stored procedures or SQL text commands.
Specify the parameter details.
Returns the SqlDataReader, DataSet, or XmlReader object.
For example, in an Application that references Data Access Application Block, you can simply call a stored procedure in a line of code and generate a DataSet, as shown below:
[Visual Basic]
Dim ds As DataSet = SqlHelper. ExecuteDataset (_
ConnectionString ,_
CommandType. StoredProcedure ,_
"GetProductsByCategory ",_
New SqlParameter ("@ CategoryID", categoryID ))

[C #]
DataSet ds = SqlHelper. ExecuteDataset (
ConnectionString,
CommandType. StoredProcedure,
"GetProductsByCategory ",
New SqlParameter ("@ CategoryID", categoryID ));