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);
Posted by on Tuesday, February 26, 2008
Labels: ,

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);

August 6, 2008 4:12 PM

Post a Comment

Subscribe to: Post Comments (Atom)