asp.net 4.0

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:

Learn more

The ADO.NET DataAdapter class

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 …

Learn more

How to monitor and block bad requests in ASP.NET in VB.NET

You can use approach described in the article How to handle improper parameter values in ASP.NET in VB.NET to create a blocking engine to handle and improve parameter values. You should manage invalid requests and notify the client about any invalid parameters that were passed in. You should reply to the request using one of the specific error …

Learn more