ADO.NET Programming in Visual Basic™ .NET

Using the DataView Class

Finally we focus on the DataView class. This class is a helper that you can use to customize the behavior of the DataSet. The main functions of interest are sorts and filters, but there are other interesting methods and properties as well. We went through the properties and methods earlier in the chapter. Now let’s see how we can use the class to quickly switch attributes of the DataSet which affect its appearance.

Let’s create a project called ADOBook03-04. This time, instead of using relations to customize our view of the data, we’ll use the DataView class. In a real-world project, we would use a combination of both techniques, along with SQL to optimize performance. For example, we would not typically read all the ...