If you want to open multiple data readers on a single connection, and you have SQL Server 2005 or later running, you need to enable MARS (Multiple Active Result Sets). To enable it, add MultipleActiveResultSets=True to the end of the connection string. I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be Forgive your enemies - it messes with their heads My blog | My articles | MoXAML PowerToys | Onyx

Repost. The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it. My latest tip/trick Visit the Hindi forum here.