October 2010
Intermediate to advanced
1920 pages
73h 55m
English
Content preview from ASP.NET 4 UnleashedBinding to a
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Binding to a DataSet
You also can use the ObjectDataSource when you need to represent an ADO.NET DataSet. Using a DataSet is slower than using a DataReader; however, you can perform advanced operations, such as filtering and sorting, on data represented with a DataSet.
The component in Listing 18.5 returns all the records from the Movies database table. However, it uses a DataSet instead of a DataReader object.
Listing 18.5. MovieDataSet.cs
The component in Listing 18.5 uses two ADO.NET objects: DataAdapter and DataSet. The SqlDataAdapter represents the SQL select command and populates the DataSet with the results of executing the command. The ...