There are many reasons why an application pools’ worker process (W3WP.exe) could be behaving badly. The best approach is to capture some memory dumps during the problem situation and then analyze them. The problem with that is the root cause is not always obvious, even after many hours of analysis and investigation. An alternative to […]
Read More →
NOTE: This solution does not implement paging and requires the retrieval of the entire result set. If your dataset is huge, I wouldn’t go this route. Other options, LIKE %text%, FULL-TEXT search, Lucene.Net…and many others… Check out another of my blogs where I defer the retrieval using a Delayed Action. Again, if you look hard […]
Read More →
In another blog I covered how to perform filtering using the ListCollectionView class on a datagrid. What I noticed on the implementation on a larger result set was a little lag in the response when characters were being entered into the filter textbox. The way it was implemented was for each character entered; perform a […]
Read More →
I made the mistake of using the SelectionChange event on a textbox while implementing some filtering on a DataGrid. What happened, when using SelectionChanged, was that each time the textbox received focus I was executing the filter. Even initially when there was nothing to filter. My logic was checking if the contents of the textbox […]
Read More →
A few months ago I wrote a question asking for solutions to this error. There were some good answers but none of them provided me with a work around that was database independent. At least something that would work with both Oracle and SQL Server. I was implementing some calculated fields in NHibernate and I […]
Read More →Some time ago I had to implement a search box which filtered a result set in a DataGrid. It was a pretty straight forward exercise. However, it took some time to find a good example and change it into what I needed. Basically, what needs to be done is to add a TextBlock and a […]
Read More →Like I’ve said before, once you find what your looking for, it is wasy to find examples about how to use and implement it. I had this again while trying to add images to a treeview. The term I was looking for, while trying to find a solution was ValueConverter. In this solution I will […]
Read More →I was developing a WPF application that contained a DataGrid like so many times in the past. However, this time it was taking 20-30 seconds for the DataGrid to render. I checked the query execution speed. I was building the DataTable dynamically, but I checked the speed of that too and it was fast as […]
Read More →