ADO.NET 2.x: DataTable.Select()

Converting a data type in a DataTable.Select() filter expression:
string filterExpression = "Convert(Year, 'System.String') LIKE '%{0}%'";
string sortExpression = "Year DESC";
DataRow[] rows = dataTable.select(filterExpression, sortExpression);

1 comments:

Anonymous said...

// The second parameter is for sort expression.
// It is better to change the variable name "searchExpression" to "sortExpression"
dataTable.select(filterExpression, sortExpression);