Dragging Tables from the Server Explorer to a Form

As we saw in the EasyAccess example in the In Depth section of this chapter, you can drag whole data entities—such as tables—from the Server Explorer onto a form. In that example, we dragged a whole table, the authors table, to a Windows form, and Visual Basic created a data connection and data adapter object for us automatically. We then generated a new dataset with the Data|Generate Dataset menu item, added code to fill the data set from the data adapter, and connected that dataset to a data grid, as you see in Figure 20.10.

Behind the scenes, Visual Basic added a tremendous amount of code to Form1.vb when we performed these actions. Take a look at the next topic for the details.