In ADO.NET 2.0, the original data objects (described above) do not go away, however much of their functionality has been encapsulated and made more easily usable, especially in those scenarios when you want to bind the data that has been retrieved from the original data source.
Here are a couple of those objects that are highlighted in video 9.
TableAdapter object – Combines the Connection, Command and DataAdapter functions into one easy to configure and use object. Its purpose is to retrieve data and put it in a dataset.
TableAdapters are available for specific types of data sources, such as databases (like SQL Server 2005 Express Edition), ODBC data sources, XML files, custom business objects and more.
BindingSource object – Manages the relationship between Windows user interface controls on your form to the associated dataset’s datatable’s columns as the user/application navigates from row to row.
There’s also a new object that is available when creating web applications in ASP.NET 2.0
DataSource object – Similar to the table adapter, this ASP.NET 2.0 scriptable object makes it easy to connect to, select, modify and bind to data without writing any C# or Visual Basic code. This can simplify the integration of external data into your web sites for those who are more familiar with scripting (using an HTML-like syntax) rather than programming.
See the Visual Web Developer 2005 Express Edition for Beginners series (video number 8) for more details.
The DataSource also comes in a variety of flavors based on the underlying data source that you will be using, including Sql Server, Access, a custom business object, XML and more.
As a beginner, you might find that you can get very quick results by using the TableAdapter or DataSource object. However it’s important to understand that they are built on top of other objects and learning about those as well can help you develop more robust applications.
Supplemental Readings for the Express Edition Videos Copyright © 2005 LearnVisualStudio.NET