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 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


Join the conversation! Your thoughts help the community grow.