Microsoft Visual Basic 2010 Step by Step eBook

(Tina Meador) #1

Chapter 18 Getting Started with ADO .NET 445



  1. On the Data menu, click the Add New Data Source command.


The Data Source Configuration Wizard starts in the development environment,
as shown in the following screen shot:

The Data Source Connection Wizard is a feature within the Visual Studio 2010 IDE that
automatically prepares your Visual Basic program to receive database information. The
wizard prompts you for the type of database that you will be connecting to (a local or
remote database, Web service, custom data object that you have created, or Microsoft
SharePoint site), establishes a connection to the data, and then creates a dataset or
data entity within the program to hold specific database tables and fields. The result is
that the wizard opens the Data Sources window and fills it with a visual representation
of each database object that you can use in your program.


  1. Click the Database icon (if it is not already selected) in the Data Source Configuration
    Wizard, and then click Next.
    The wizard displays a screen prompting you to choose a database model for your
    application and the connection that your program will make to the database
    information. This is a new screen in Visual Studio 2010; your options are now to choose
    a dataset to make the connection or an entity data model. We will be using the dataset
    option here, but the entity data model can also be useful because it allows developers
    to work with data in the form of domain-specific objects and properties without

Free download pdf