Doing so will take us to the screen shot shown below.
(True, you have to provide a connection string rather than simply the path to the file, but Visual Studio 2005 can automatically create appropriate connection strings for those databases residing in your folder.) In this article we'll examine the Sql Data Source in detail, just touching upon the one difference in the Access Data Source.
Furthermore, the Sql Data Source and Access Data Source controls can be used to both access and modify data; however, this article only examines accessing data.
The selections here tack on an If you opt to select the columns to return from a table or view you can only configure simple queries that involve a single table or view.
With relational databases, often there's data in related tables that we need to grab, requiring s.
The first screen, shown below, prompts you to select the database from which the data will be queried.