Other Visual Studio .NET Projects


As you learned earlier in the chapter, apart from the general programming projects, Visual Studio .NET also supports integrated development of projects for creating setup applications or even working with databases. In this section, you discover some of the Visual Studio .NET capabilities for working with databases using the Database Project Wizard (see Figure 5.30).

Figure 5.30. The Database Project Wizard.

The next step in the database project is to select a connection reference to the database. If any previously defined references exist, they will be listed as well. You use the Add New Reference Wizard to set up a connection to a local database server; in this case, it is SQL Server. (The wizard allows the user to connect to multiple databases using the appropriate OLE DB database provider, as illustrated in Figure 5.31.)

Figure 5.31. Select a database reference.

After the database has been opened, Visual Studio .NET provides integrated database manipulation by enlisting the various tables, stored procedures, views, and functions. New scripts, stored procedures, database queries, triggers, and views can be added for the database using a list of predefined templates. Even database table data can be manipulated using the prebuilt grid control (see Figure 5.32).

Figure 5.32. Database project details.

This is also an area where the next version of Visual Studio enhances a lot of development capabilities. Basically an upcoming version of the Visual Studio .NET environment will provide the capability for developing stored procedures and other scripts for the SQL Server Yukon release, using .NET-supported programming languages.



Microsoft.Net Kick Start
Microsoft .NET Kick Start
ISBN: 0672325748
EAN: 2147483647
Year: 2003
Pages: 195
Authors: Hitesh Seth

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net