Visual Studio 2010 All-in-One For Dummies
xviii
Dragging and Dropping Data ......................................................................558
Preparing your computer to work with data..................................559
Adding data to Windows applications ............................................559
Adding data to Web Forms ...............................................................564
Chapter 2: Show Me the Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .569
Adding Data Access in Windows Applications ........................................569
Working with the Data Sources pane ..............................................570
Viewing data source objects ............................................................571
Adding data sources ..........................................................................572
Connecting to databases...................................................................574
Adding controls from the Data Sources pane ................................577
Getting Your Data in a Bind ........................................................................580
Using BindingSource to connect to other data ..............................580
Using BindingNavigator ....................................................................582
Binding by using the Binding property ...........................................583
Creating Web Forms That Access Data ....................................................585
Meet the controls ...............................................................................586
Customizing layout with templates .................................................590
Working with tasks and properties .................................................594
Updating data with the DataSet Designer .......................................596
Getting the view right with the GridView control..........................599
Binding to expressions ......................................................................602
Chapter 3: Working with Strongly Typed DataSets . . . . . . . . . . . . . . .605
Understanding the DataSet ........................................................................605
Discerning typed versus untyped DataSets....................................608
Working with untyped DataSets.......................................................609
Flexing your strongly typed DataSets .............................................610
DataSets and XML, together at last .................................................611
Creating Typed DataSets ............................................................................612
Creating a DataSet in a class library ................................................612
Adding typed DataSets to existing projects ...................................614
Exploring the DataSet Designer .................................................................615
Meet the players ................................................................................615
Building a DataSet of your own ........................................................616
Adding database objects...................................................................620
Going beyond database tables .........................................................622
Shepherding Data ........................................................................................623
Using the TableAdapter Con guration Wizard ..............................624
Using the TableAdapter Query Con guration Wizard ..................631
Looking under the Hood of a Strongly Typed DataSet ...........................634
Viewing code ......................................................................................634
Using partial classes ..........................................................................634
Viewing the source ............................................................................636
Using a Typed DataSet ................................................................................637
02_539439-ftoc.indd xviii02_539439-ftoc.indd xviii 5/21/10 1:46 PM5/21/10 1:46 PM