Updating clause used in instead
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.
NET 2.0 introduced a number of new Web controls designed for accessing and modifying data. In short, with the Data Source controls you can work with data without having to write a lick of data access code. NET 1.x, which required oft-repeated code to access data.
These controls allow page developers to declaratively access and modify data without writing any code to perform the data access. For example, to display the contents of a database table in a web page with ASP. NET 2.0, data can be accessed entirely from declarative markup.
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.
Therefore, the screen shots above are different for the Access Data Source.
Specifically, the first screen shot examined prompts for a file location; since there is no connection string, the second screen shot does not appear in the Access Data Source.
If there's a clustered index (such as a primary key constraint) on the table, the data will be ordered by the column(s) that make up that index; otherwise, the data is ordered by order it was entered into the database table.The first screen, shown below, prompts you to select the database from which the data will be queried.