Summary

Today you gained a lot of practical knowledge about the tools available in Visual Studio .NET to work with databases, and how to use those tools to create data-driven applications with Windows Forms.

Using the Server Explorer to work with databases can save you lots of time; everything you need is right in front of you in an easy-to-use interface. The Query and View Designers, used in conjunction with the Stored Procedure Designer and Debugger can help you create efficient and scalable data access applications.

When you need to create fully functional, robust data-driven forms, use the Data Form Wizard in .NET. Even if you aren't writing Windows Forms applications, you can run the wizard and examine the auto-generated code to learn more about the DataAdapter and how it uses Select, Insert, Update, and Delete commands.