ado.net

How to filter data with the ADO.NET DataView in VB.NET

If in your project you want to include only certain rows in the display you can use a DataView to apply custom filtering. To accomplish this, you should use the RowFilter property which acts like a WHERE clause in a SQL query. You can limit the final results by using it and by applying logical operators, …

Learn more

How to filter data with the ADO.NET DataView in C#

If in your project you want to include only certain rows in the display you can use a DataView to apply custom filtering. To accomplish this, you should use the RowFilter property which acts like a WHERE clause in a SQL query. You can limit the final results by using it and by applying logical operators, …

Learn more

How to sort data with the ADO.NET DataView in VB.NET

If in your project you need to sort data by using ADO.NET DataView you can use the next example as a basic. The example uses a page with three GridView controls. When the page loads, it binds the same DataTable to each of the grids. However, it uses three different views, each of which sorts the …

Learn more

How to sort data with the ADO.NET DataView in C#

If in your project you need to sort data by using ADO.NET DataView you can use the next example as a basic. The example uses a page with three GridView controls. When the page loads, it binds the same DataTable to each of the grids. However, it uses three different views, each of which sorts the results using …

Learn more

The ADO.NET DataView class

A DataView defines a presentation of the data in a DataTable that can include custom filtering and sorting settings. You can configure these setting, by using the DataView’s properties such as Sort and RowFilter. You can use them to specify what data you’ll see through the view, but they don’t affect the actual data in the …

Learn more

The ADO.NET DataSet class

The DataSet, the heart of disconnected data access, contains two important parts:

– Collection of zero or more tables exposed through the Tables property.

– Collection of zero or more relationships that you can use to link tables together which are exposed through the Relations property.

The next picture presents the basic structure of the DataSet:

← Previous