O'Reilly logo

MCAD/MCSD.NET Training Guide (Exam 70-316): Developing and Implementing Windows®-Based Applications with Microsoft® Visual C#™ .NET and Microsoft® Visual Studio® .NET by MCSD Amit Kalani - MCAD

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Transforming and Filtering Data

Display and update data:

  • Transform and filter data.

The second test objective for this chapter involves transforming and filtering data. Especially when you're dealing with data from a database, you might find that the data is not in the exact form that you'd like to display to the user. Perhaps there are 5,000 rows in the Customer table, and you'd like to pull out the single row that interests your users. Or perhaps you'd like to show customer names with orders, but the Orders table only stores the CustomerID. The following sections look at a few of the tools that the .NET Framework offers for manipulating database data.

First, you'll dig into Server Explorer, which allows you to interact directly with SQL Server ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required