【正文】 英文文獻(xiàn) VS2020 in the development of database program 1. Introduction In November 7, 2020, Microsoft officially released. NET (including ), Visual Studio 2020 and SQL Server 2020. All of these ponents were designed to work independently side by side. In other words, version 1. X and version can be installed on the same machine, you can have Visual 2020/2020 and Visual Studio 2020, and also that SQL Server 2020 and SQL Server 2020. Moreover, Microsoft also issued Visual Studio 2020 and SQL Server 2020 Expressa SKU. Note that the Express version does not have all the features of Professional Edition. In addition to supporting 1. Xstyle data access, including its new data source controls which makes database access and modify data very easily. The use of these data source control, you simply add the controls to pages and through control of these attributes to configure the connection string and SQL query. Then, the data Web control of the DataSourceID property to the data source controls the ID, the data source controls can be bundled with a data Web control (such as GridView) on. Today, we must rely on the preparation of the code to create connections, creating order, the designated SQL query, retrieve a DataReader or DataSet, and it bound to the data Web control the days are gone. These steps can be through the use of the statement of the data source controls instead. (Of course, you can through the use of your 1. X familiar with the code of the steps programming access to data.) In this article we will look at how to connect and display from a database of data. Specifically, we will discuss how to use programming and a statement of ways to access data and analysis through the GridView control data to show that the basic operation. Second, Visual Studio 2020 in the operation of the database When you install any of Visual Studio 2020 version, you always be asked if you want to install SQL Server 2020 Express version. If you choose Yes, this will install your development kits in the SQL Server 2020 Express version note that you are installing in this Visual Studio 2020! (SQL Server 2020 Express version of SQL Server with the other versions to install, inc luding SQL Server 2020 and SQL Server 2020 the other versions.) If you work in the current use of SQL Server 2020, then you can through Enterprise Manager to the most fortable way to operate the databas. Although you can still use Enterprise Manager to operate SQL Server 2020, or the use of SQL Server 2020 Management Studio to operate your SQL Server 2020 database, but you can Visual Studio 2020 data connections to manage the database. I mention these because the SQL Server 2020 Express version, there is no one like SQL Server 202039。s Enterprise Manager or SQL Server 2020 Management Studio such a GUI tool for the generation, you must pass to Visual Studio 2020 Create and manage your SQL Server 2020 Express version of the database. Tip management version of SQL Server 2020 Express database If you have any other except Express outside the SQL Server 2020 version, you can install on your client machine tools, including management StudioSQL Server 2020 database management of the GUI tools. If you install this tool, you can also use it to manage SQL Server 2020 Express version of the database. To through Visual Studio 2020 to manage a database, choose to Server Explorer。 in its on, you will find a data connection node (see Figure snapshot). You can connect the data node on the rightmouse click to add a new database connection and choose Add Connection. This will be out of a dialog prompts you some information, such as database server, authentication information, such as the use of any database. If you own the machines are installed on the SQL Server 2020 Express version, that is, through the use of default and called SQL Express installed examples of the database. Therefore, in order to connect to the service is famous YourMachineName \ SQL Express or. \ SQL Express. In addition to connect to an existing database, you can also connect node in the data, click the right mouse button and choose to create a new SQL Server database to create a new database. Once a database is added to the data connectivity options on the card, you can through the appropriate folder to add, delete or modify data tables, stored procedures, views, and so on. In order to create a new data tables or storage process, rightclick the appropriate folder and choose Add New X menu option。 To mod