Consuming and Manipulating data with ADO.NET

Summary

This Drill demonstrates how to manage data using ADO.NET. You will complete challenges in querying a SQL Server database, manipulating a DataSet, and working with disconnected DataSets. You will also create a strongly typed DataSet, use the DataSet’s built-in XML features, and produce code that works with multiple data providers.

Audience

This Drill is for developers who want to use ADO.NET technology to access data sources such as SQL databases, particularly those who want to gain experience using DataSets.

What you'll learn

You will learn the skills needed to manage data using ADO.NET. The skills you will learn include querying a SQL Server database, manipulating a DataSet, and working with disconnected DataSets. You will also learn how to create a strongly typed DataSet, use the DataSet’s built-in XML features, and produce code that works with multiple data providers.

What you need to know

We assume that you’re familiar with the concepts of programming and you’ve experience with Visual Studio 2005. You’ll also need to be comfortable with Visual C# or Visual Basic syntax and have a good knowledge and understanding of database concepts with SQL Server. You’ll need to know Windows Forms, and previous experience of ADO.NET 1.0 is useful for appreciating the new features of ADO.NET 2.0.