Get Data from Database using Class Library File

This blog show how to get data from database using data table return method and bind with what ever control you want.

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