Microsoft® Visual C#® .NET 2003 Kick Start

Reading Data Cell by Cell

When you're working with databases in code, it's important to access data on a cell-by-cell basis. To see how to gain access to the data in a database, we'll create a new example, ch10_03, which will connect to the authors table in the pubs database and display data for various authors in text boxes, as you see in Figure 10.4.

Figure 10.4. The ch10_03 example.

To write this example, create a new Windows application named ch10_03 now and connect a SQL data adapter to the authors table. In addition, generate a new dataset, dataSet11, to hold the entire authors table. Next, add the four multiline text boxes to the example's ...