Test paging, updating, deleting and inserting a new record to see how it works.
Recently I was tasked with encrypting/decrypting some data that could be edited using ASP. Along with the details view control, the legacy code used a SQL Data Source to select and update everything.
Details View server control is used to display, delete, insert or edit a single record from data source. More about Form View control you can read in Form View Control: Step by Step tutorial. After we created Sql Data Source control, we need to associate it with Details View control.
In our case table primary key column is named "Product ID".
Now, you can start an example again and joy in new features.
Category Name FROM Products INNER JOIN Categories ON Products. ID ORDER BY Product ID" This data source contains commands for all four basic operations: Select, Update, Insert and Delete.
Run the example and Details View control will show first record, similar to the next image: Before using an example you need to set Data Key Names property of Details View control to the name of table primary key column.