PRACTICAL 1 EXERCISE 1: Databases and Visual Studio The exercises and tasks in the first part of this practical are step-by-step instructions to guide you in the setting up a normalised database within Visual Studio. This is followed by a number of exercises and tasks for you to complete by applying the knowledge that you have just gained. TASK 1: Creating the Database in Visual Studio Step 1: Run Visual Studio and then from the Visual Studio File menu, select New (or press Then click on Project, select C# Windows Forms Application and name it Ctrl+Shift+N). e.g. DB_Prac01. Step 2: Open the Server Explorer (top left hand side of Visual Studio) and right click on Data Connections, choose Create New SQL Server Database. The Create New SQL Server Database window should open, Figure 1. Figure 1 Step 3: The Server name should be .\sqlexpress and the New database name: should be set to ProjectManagement. Click OK and the database should appear in your Server Explorer, see Figure 2. Figure 2 Note: To check that you are connected to the database you will notice the Green connection logo. A red x would indicate an unsuccessful connection.
PRACTICAL 1 EXERCISE 1: Databases and Visual Studio The exercises and tasks in the first part of this practical are step-by-step instructions to guide you in the setting up a normalised database within Visual Studio. This is followed by a number of exercises and tasks for you to complete by applying the knowledge that you have just gained. TASK 1: Creating the Database in Visual Studio Step 1: Run Visual Studio and then from the Visual Studio File menu, select New (or press Ctrl+Shift+N). Then click on Project, select C# Windows Forms Application and name it e.g. DB_Prac01. Step 2: Open the Server Explorer (top left hand side of Visual Studio) and right click on Data Connections, choose Create New SQL Server Database. The Create New SQL Server Database window should open, Figure 1. Figure 1 Step 3: The Server name should be .\sqlexpress and the New database name: should be set to ProjectManagement. Click OK and the database should appear in your Server Explorer, see Figure 2. Figure 2 Note: To check that you are connected to the database you will notice the Green connection logo. A red x would indicate an unsuccessful connection.
PracticalWeek01.docx