Search results

I have a method that calls ExecuteScalar for a Count(*) sql statement. It works fine for several iterations then all of a sudden it goes off and never returns. When it hangs it takes over 100% of my CPU. I get no error messages back so I have no clue what I am doing wrong. I have isolated my...