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 ...