Creating a Data Application
It's time to use these objects now, putting them to work in an example to see how things fit together. The C# IDE lets you work with the objects we've seen in a way that's relatively easy, simply using visual tools. We'll see how they work in the first example for this chapter, named ch09_01 in the code for this book.
This example fetches the data in the authors table of the pubs example database that comes with SQL Server, and displays it in a C# data grid control. To start, create the Windows application named Ch09_01 now.
Creating a Data Connection
To work with the pubs example database in SQL Server, you first need a connection to that database. In the IDE, you use a tool called the Server Explorer to establish ...