Apply Your Knowledge


1.1. Preselecting Data with Parameterized Stored Procedures

One of the biggest issues in working with server-side data, such as SQL Server data, is to minimize the amount of data that you load into an application. Communication with such servers is typically comparatively slow, and the servers themselves have enough processing power to quickly locate the exact data that you want. In this exercise, you'll see how you can minimize the amount of data retrieved by using a series of stored procedures with parameters.

Estimated Time: 30 minutes.

Create a new Visual C# .NET project to use for the Exercises in this chapter. Name the project 320C01Exercises.
Add a new form to the project.
Place a ComboBox control ...

Get MCAD/MCSD Training Guide (70-320): Developing XML Web Services and Server Components with Visual C#™ .NET and the Microsoft .NET Framework 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.