Create A SQL Database In ASP.NET Web Form Using Visual Studio 2015 Update 3

Introduction

In this article, you will learn how to create SQL database Server in ASP.NET Web form, using Visual Studio 2015 Update 3.

Requirements

• Install
• Visual Studio 2015
• SQL Server 2014
• ASP.NET

Step 1

Open Visual Studio 2015 Update 3, go to file and afterwards, you can choose New project. Subsequently choose the Web and select the ASP.NET Web Application.



Now, we can choose Web and afterwards ASP.NET Web Application.


Here, we can select the Empty Application and afterwards, you can click OK button



Step 2

Now, open the project and afterwards, you can go to project. Right click and select Add. Choose the New item or those which follow the shortcut keys Ctrl+Shift+A.



Now, we can select Web then choose the Web form. Afterwards, you can click Add button.


Now, once again go to Ctrl+Shift+A. Subsequently, choose the Web and afterwards, you can select the StyleSheet and click the "Add" button. Now, link the Style sheet.





Step 3

Here, we can see that Web form page.



Here, go to your project, click the right click and choose the add. Afterwards, choose the New Item. Now, select the Visual C# and select SQL Server database and write the Server name. Click the "Add" button.



Now, click the "yes" button.




Step 4

Now, go to View and select the Server Explorer.



Here, double click the database, open the table and so on. Subsequently, click the right click and add a new table.



Here, open the database table and we need something where you can create your database oriented data, which should be like Name, Age and so on.



Now, you can change table name and afterwards, you can click Update button.



Here,click the Update database.



Now, go to Server Explorer and click the table (databaseone). Right click to open the Window and afterwards, you can click the Show table Data.



Here, we can see the default data and you can write your database oriented data or information. Now, save all the data.





Step 5

Now, we can select the Grid View and Sqldatasource.



Now, we can see the design page.



Here, we can change SQL source name.



Here, we can click the Configure Data source and subsequently click the Next button.



Now, we can choose our database.



Here,we will write the ConnectionString. Now, click Next button.



Now, we can see your data. Now, click Next button.



Here, we can click the Test Query and click the Finish button.



Step 6

Now, you can click the Grid view and choose the data source (your data source name).



Here, you can get the access to the Enabling page and Enable sort. Click the auto format, choose the color and apply. Afterwards, click OK button.



Step 7

Now, we can choose the Run option, which should be like Google Chrome, Microsoft Edge and so on.



Step 8

Now, we can see the output.