Get Data from Database using Class Library File

Step 1: Create a empty website using Visual Studio 2012.

Step 2: Open vs 2012 > go new tab> open new website >select empty website.

Step 3: Give the name to your site what ever you want. Click on ok button. 

 

 

Step 4: Add a web page in you website name it what you want and Select web form.

 

 

  

Step 5: Add a class  library file to create a method name it datalayer. 

 

 

Step 6: Set your connection string in you web config file.

 

 

Step 7: Create a data table return type method using a parameter of SQL query. 

 

 

 Step 8: Binding method to control in webpage.

 

 

 

Out Put