February 27, 2021
Hot Topics:

Using Visual Studio Tools for Office in Visual Studio 2008

  • By M. Rajesh
  • Send Email »
  • More Articles »

Right-click the project in Solution Explorer and click add new item and choose Dataset from the dialog box (see Figure 7).

Click here for a larger image.

Figure 7: Adding a dataset to your project. This dataset will contain the query necessary for your application.

Now, you will see a blank window in which you can add a table (see Figure 8).

Click here for a larger image.

Figure 8: After adding the dataset to the project, the Dataset Designer comes where you can add your tables and build up your query.

Add a tableadapter to it because you are referring to a single table. Right-click the empty space in the middle window and then select TableAdapter from the pop up menu. You will be presented with a dialog box wizard to select the Data connection, as shown in Figure 9. Open the drop-down list box and you will see that the connection that you created recently is seen. Select that and click Next. Complete the rest of the wizard and make sure that you select only the Customers Table (see Figure 10) and nothing else.

Click here for a larger image.

Figure 9: Walking through the Wizard to add and configure a Table Adapter.

Click here for a larger image.

Figure 10: Add only the table Customers to the Table Adapter.

Page 4 of 7

This article was originally published on April 28, 2008

Enterprise Development Update

Don't miss an article. Subscribe to our newsletter below.

Thanks for your registration, follow us on our social networks to keep up-to-date