Tuesday, November 16, 2010

Data Access Layer Class In C#

In this article, I would show to you how to create a Data Access Layer Class in C#. The data access layer always important when we are work with database and presentation layer. This class should contains all the methods which can be used to get data from database (using Stored Procedures) and also to insert and update data in database.

Data Access Layer Class contains the methods which return different objects like Data set, SqlDataReader, Integer etc at the end of the method. Data Access Layer Class also contains methods for adding.Parameter to SQL Command with different parameters and contains the method to set the parameter value.

Here is the sample code for create the Data Access Layer Class in C#.