How to Read Uncommitted Data Created in Same Process?

I am new to C# and having a problem reading data created (or updated) in the same process. My transaction is at IsolationLevel.Serializable in order to avoid OTHER users uncommitted data etc. But, I find that if I open another connection (i.e. not in the serialized transaction) I can't read my own uncommitted data. Furthermore, if I use the connection with the serialized transaction I can't have open more than 1 reader, which my app design currently requires. Any way out of this gotcha?

Note that I am running VC# 2005 against a SQLServer 2000 database so I can't (as far as I know) set my connection to multi datasets or modify the IsolationLevel of the transaction to Uncommitted Read to read my own data and then back to Serializable to avoid reading others.

Thanks for any help,

bryano.

[831 byte] By [bryano] at [2007-12-25]