Day 11. Understanding Visual Database Tools

Yesterday you learned the ins and outs of ADO.NET. Although you had to write some code to work with data, you saw how easy it is to write data access applications using ADO.NET. Today, you learn that you can write complete data-driven applications without writing any code. Using the visual tools in Visual Studio .NET, including the Server Explorer, you can create database connections, manage databases, create tables, views, and stored procedures, and use wizards to generate forms automatically. Today is broken down into three main sections. You learn how to

• Use the Server Explorer to manage databases and Connection objects, including creating views, stored procedures, and debugging stored procedures

• Create a data-driven form using the Server Explorer

• Use the DataForm Wizard to create a data-driven data entry form