GetSortedView Method

MultiColumnSort GetSortedView Method

CleanCode C# Libraries v1.2.03 API

Generates a sorted view of a DataGridView based on a query.

Namespace: CleanCode.Data
Assembly: CleanCode (in CleanCode.dll) Version: 1.2.3.0 (1.2.03)

Syntax

public DataView GetSortedView(
	string query
)

public DataView GetSortedView(
	string query
)

Public Function GetSortedView ( _
	query As String _
) As DataView

Public Function GetSortedView ( _
	query As String _
) As DataView

public:
DataView^ GetSortedView(
	String^ query
)

public:
DataView^ GetSortedView(
	String^ query
)

Returns a

DataView sorted per the specified query.

Exceptions

Exception	Condition
System ArgumentException	If no 'ORDER BY' clause is found or if there is any compound name in the clause that does not have an alias to a simple name.
System IndexOutOfRangeException	If an expression in the order by clause does not match a column name in the DataGridView. Note that most SQL interpreters will flag this as an error first. The only way this error will manifest is if you load the DataGridView without running it through a SQL interpreter (as when loading from a file, for example).

Remarks

See the class description for details.