ASP.NET 2.0数据库外文文献及翻译和参考文献 第3页
VS2005 in the development of ASP.NET 2.0 database program
1. Introduction
In November 7, 2005, Microsoft officially released. NET 2.0 (including ASP.NET 2.0),
Visual Studio 2005 and SQL Server 2005. All of these components were designed to work independently side by side. In other words, ASP.NET version 1. X and version 2.0 can be installed on the same machine, you can have Visual Studio.NET 2002/2003 and Visual Studio 2005, and also that SQL Server 2000 and SQL Server 2005. Moreover, Microsoft also issued Visual Studio 2005 and SQL Server 2005 Express-a SKU. Note that the Express version does not have all the features of Professional Edition.
2.0 In addition to supporting 1. X-style 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 ASP.NET 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 ASP.NET 2.0 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 2005 in the operation of the database
When you install any of Visual Studio 2005 version, you always be asked if you want to install SQL Server 2005 Express version. If you choose Yes, this will install your development kits in the SQL Server 2005 Express version - note that you are installing in this Visual Studio 2005! (SQL Server 2005 Express version of SQL Server with the other versions to install, including SQL Server 2000 and SQL Server 2005 the other versions.)
If you work in the current use of SQL Server 2000, then you can through Enterprise Manager to the most comfortable way to operate the databas毕业论文
http://www.youerw.come. Although you can still use Enterprise Manager to operate SQL Server 2000, or the use of SQL Server 2005 Management Studio to operate your SQL Server 2005 database, but you can Visual Studio 2005 data connections to manage the database. I mention these because the SQL Server 2005 Express version, there is no one like SQL Server 2000's Enterprise Manager or SQL Server 2005 Management Studio such a GUI tool for the generation, you must pass to Visual Studio 2005 Create and manage your SQL Server 2005 Express version of the database.
Tip management version of SQL Server 2005 Express database
If you have any other except Express outside the SQL Server 2005 version, you can install on your client machine tools, including management Studio-SQL Server 2005 database management of the GUI tools. If you install this tool, you can also use it to manage SQL Server 2005 Express version of the database.
To through Visual Studio 2005 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 right-mouse 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 2005 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, right-click the appropriate folder and choose "Add New X" menu option; To modify an existing data tables, storage, process or view, the double-click to. This will be their call to the Visual Studio - in this you can modify it according to need. You can also observe and modify data in a single table of data - and this is through a data table right-click and choose "data tables show data" to achieve.
Third, add a database to App_Data folder
In addition to data connectivity options cards add to existing databases, you can also add a site-specific database to the site's App_Data folder. App_Data is a new and retained in ASP.NET 2.0 in the folder - it was designed to store data on the content, including SQL database files (. Mdf file), Access database files (. Mdb file), XML documents. ASP.NET works from a site, you can easily create and add a new SQL Server 2005 Express database to your project - Solution Explorer by right-clicking in the App_Data folder and choose "Add New Item". Then, from the "Add New Item" dialog (shown below), select Add a new SQL database.
If you want to follow the本文来自优文论文网原文请找QQ752018766field), Name, City, State and ZipCode. Then, add some VS 2005 to record this data sheet.
In addition, you can add existing Access database file or even SQL Server 2000 database files. (Note: To add an existing SQL Server 2000. Mdf file, you will need to make sure it is the first time from enterprise management on a separation; To this end, Enterprise Manager, right-click the name of the database, then select "All Tasks" and Select "Detach database." Once you leave the sub-databases and add it to ASP.NET 2.0 works, you can enterprise management for its re-attachment.)
Fourth, the SqlDataSource control connected to the database
Now, since we have seen how to create and Visual Studio through the use of the interface to the database; Below, let us turn their attention to from a visit to ASP.NET 2.0 web pages from a database and display the data. ASP.NET 2.0 includes several new data source controls - their sole purpose is to provide data to the statement of access. There are five built-in data source control - all of them in Visual Studio in the toolbox "for" section found.
• SqlDataSource-for retrieval and modification of a relational database from the data. Here the "Sql" does not mean that the source of such data only with Microsoft SQL Server to work but can a relationship with any other database to work together: SQL Server, Access, Oracle, and so on. If you connect to a SQL Server database, then the controls will be very smart in the internal opening SqlClient category.
• AccessDataSource-for retrieval and modification from an Access database files of data. You may want to know if the SqlDataSource and Access database file毕业论文
http://www.youerw.coms can work together, then why is there this control » In fact, this Access data source controls make it easier for you to connect to an Access database - assigned to you as long as the Access database. Mdb file path. Note the use of SqlDataSource, you need to use a fully qualified to provide the specified data connection string.
• ObjectDataSource-to the adoption of a commercial object to retrieve and modify data. Ideally, your ASP.NET applications, including a group category - it's a middle layer (ASP.NET page rather than to direct operation of the database). If you have such a structure, you can use to query the middle of the ObjectDataSource.
• XmlDataSource-for retrieval from an XML file data.
• SiteMapDataSource-definition used to provide read-only access to the site map in the structure
上一页 [1] [2] [3] [4] [5] 下一页
ASP.NET 2.0数据库外文文献及翻译和参考文献 第3页下载如图片无法显示或论文不完整，请联系qq752018766
