for some reason when i deploy my C# application on windows 2003 occasionaly rdr[0].ToString() hangs where rdr is a System.Data.SqlClient.SqlDataReader. Is there a fix for this? is my visual studio.net out dated?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Daniel - 22 Mar 2006 08:36 GMT

for some reason when i deploy my C# application on windows 2003 occasionaly
rdr[0].ToString() hangs where rdr is a System.Data.SqlClient.SqlDataReader.
Is there a fix for this? is my visual studio.net out dated?

Reply to this Message

Jason Hales - 22 Mar 2006 14:30 GMT

I assume you're only using one sqlDataReader at a time with your
sqlConnection and you're explicitly calling the Close() method when
finished?

Is rdr[0] ever a null value? If so ToString will raise an exception

Are there any other exceptions being raised which you're trapping and
not reporting?

Is there a lock occuring on the table in your SQL database that is
preventing the reader from returning?

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...