gaqey.blogg.se

Using the “Browse …” button, you can specify the folder in which the database file “MyDataBase.mdf” will be placed.įigure 6 shows the name of the database being created, which is located on the following path: D:\Programs\C_SHARP\TermPaper1\MyDataBase.mdfįigure 6. In our case, the name “MyDataBase.mdf” is entered (Figure 6). In the “Database file name (new of existing)” field, enter the name of the new database that can be created. Selecting the Microsoft SQL Server Database File In our case (according to the condition of the task), select “Microsoft SQL Server Database File”.įigure 5.

a database of the Microsoft SQL Server type, including the local SQLEXPRESS server.a database that supports access using the ODBC driver.the Microsoft Access database, which is located in the file “*.mdb”.This will open the “Change Data Source” window (Figure 5), in which you need to set the Data source and the Data provider. check database connection ( Test Connection) Ĭhange the data source by clicking on the “Change …” button.set the password to enter the database (optional).create a new one or select an existing database file ( Database file name).In the “Add Connection” window, you can perform the following operations: The window “Add Connection”Īfter the “Connect to Database” command is opened, the “Add Connection” window will open (Figure 4). The “Connect to Database” command from ‘Server Explorer’ tool ⇑ 2.2.

The “Connect to Database …” commandįigure 3. сlicking the “Connect to Database” button in the Server Explorer menu (Figure 3).įigure 2.сall the command “Connect to Database” from the Tools menu (Figure 2).There are 2 ways to create a new local database, which is located in the “*.mdf” file: To access the Server Explorer window, use the command View -> Server Explorerįigure 1. To work with databases in the Microsoft Visual Studio system, use the Server Explorer utility (Figure 1). These tools include the relational database management system Microsoft SQL Server. The Microsoft Visual Studio system has powerful built-in tools for work databases.

The database must be used in the Microsoft SQL Server relational database management system. The name of the database is “MyDataBase.mdf”. Using the tools of Microsoft Visual Studio create a local database, which is located in the “*.mdf” file.