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 ...
Get MCAD/MCSD.NET Training Guide (Exam 70-316): Developing and Implementing Windows®-Based Applications with Microsoft® Visual C#™ .NET and Microsoft® Visual Studio® .NET now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
