While these can be set through the Properties pane, it's usually quicker to use the wizard, which can be reached by clicking on the "Configure Data Source" link in the Sql Data Source control's smart tag.
While you can set all of these properties by hand in the Source view, the Design view offers a time-saving wizard for quickly specifying which database to connect to and what query to issue.To get started, fire up Visual Studio 2005 and create a new website or, alternatively, download the code example at the end of this article.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.If not, you have to find each and every page that references the connection string and update it accordingly.
Furthermore, by placing your connection string information in The Access Data Source differs from the Sql Data Source in one minor aspect - rather than specifying a connection string as with the Sql Data Source, the Access Data Source prompts for the path to the database file.
We'll see how to use these Data Source controls to modify database data in a future installment.
Also, we'll focus on working with these Data Source controls in Visual Studio 2005 through the Design view.
To specify a different ordering, click the ORDER BY button.
Here you can choose what columns the data should be sorted by, and if it should be sorted in ascending or descending order.
Doing so will take us to the screen shot shown below.