string filterExpression = "Convert(Year, 'System.String') LIKE '%{0}%'";
string sortExpression = "Year DESC";
DataRow[] rows = dataTable.select(filterExpression, sortExpression);
ADO.NET 2.x: DataTable.Select()
Converting a data type in a DataTable.Select() filter expression:
Subscribe to:
Post Comments (Atom)
1 comments:
// The second parameter is for sort expression.
// It is better to change the variable name "searchExpression" to "sortExpression"
dataTable.select(filterExpression, sortExpression);
Post a Comment