How to Connect DataBase in ASP.NET

In this tutorial we will learn about connecting database, using is contained on a .net framework, which is supported by many IDE’s. Usually, Visual Studio is used and heard. Database connection needs to be maintained, in order to communicate and manipulate data effectively. It is fetched, inserted, and displayed on your display using the choice of language, or syntax allotted to it.
Step # 1 – Opening your IDE and Selecting ASP.Net
First of all we’ll need to open our IDE, In my case Visual Studio. Make sure you select the ASP.Net website template in the Visual C#.
Starting your IDE

Step # 2 – Configuring Data Source
Connecting database is easy, first add a button from the toolbar and name it. Then drag and drop the sqldatasource option from the toolbox. Click on configure data source in order to get your connection string.
Inserting data source

Step # 3 – Generating connection string
Here we create a new connection by clicking on the button with the same name. Then we put the server name and select a database, I am going to use tempdb as my database. Now click on test connection in order to see if the database connection is established.
getting connection string

Step # 4 –Copy connection string
Copy the connection string from this window because we’ll need it while configuring the button event handler in the code.
Save connection string

Step # 5 –Connecting the database
In the code, first of all add the sql client system class library. Then paste the connection string behind the event handler of our My connection button and finally in order to establish the connection we use the Open method.
Opening the database