Following tip will allow your to increase your performance when your are using DataView RowFilter property. Just instead of using following syntax: DataView dv = new DataView("tableName"); dv.RowFilter = "Name like '%blabla%'"; Use the next one (combine it to single statement): DataView dv = new DataView( TableName, "EName like '%Test%'", null, DataViewRowFilter.CurrentRows ); This will improve your performance !!! It's real.
ASP.NET tips, problems and solutions discovered during development