Everything you've done so far is invisible at runtime. You've set up a DataAdapter object, a Connection object, and a DataSet object, but you can't see any of these things. In order to actually see the data you're working with, you'll need to add controls to the page. ASP.NET makes this simple.
Now that you've set up all the data-handling components, it's time to add the DataGrid control to the page and hook it up. Follow these steps to display the data retrieved by the DataAdapter in a grid:
In the Solution Explorer window, select Products.aspx and select View, Designer (or simply double-click) to view the page in the designer.
From the Web Forms tag of the Toolbox window, drag a DataGrid control ...