How to filter data based on relationships with the ADO.NET DataView in VB.NET
The article How to filter data with the ADO.NET DataView in VB.NET does not cover one of little-known features of the DataView to filter data rows based on relationships. For example, you need to display categories that contain more than five products, or you need to display customers who have bought more than 5 bank products. …
How to filter data based on relationships with the ADO.NET DataView in C#
The article How to filter data with the ADO.NET DataView in C# does not cover one of little-known features of the DataView to filter data rows based on relationships. For example, you need to display categories that contain more than five products, or you need to display customers who have bought more than 5 bank products. …
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, …
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, …
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 …
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 …
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 …
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:
When you need to extract records from a database and use them to fill a table in a DataSet, you should use ADO.NET object: DataAdapter. Because the DataAdapter comes in a provider-specific object there is separate class for each provider: SqlDataAdapter, OracleDataAdapter, and so on. The DataAdapter works as a bridge between a single DataTable in …
There is a threat for file access named path canonicalization. Canonicalization is a process for converting data in standard (or canonical) form and it refers to the action that builds a path in a safe form. The next picture shows this process:
Path canonicalization in action. If an attacker passes special characters, such as .. or …