Try-Catch problem in C# console app

[Member 4645801]

I have the following code snippet in a C# console application and am getting the following error in VS2008 on the last line (bool recExists = myReader.HasRows): Error 2 Use of unassigned local variable 'myReader' Here's the code: string sResponse; SqlDataReader myReader; // Check existence of tracking record sQuery = "Select * from tracking where shipper_id = '" + sShipperId + "' AND shipper_ack = '" + sShipperAck + "'"; myCommand1 = new SqlCommand(sQuery, conn); try { myReader = myCommand1.ExecuteReader(); } catch (Exception e2) { conn.Close(); conn.Dispose(); sResponse = e2.GetBaseException().ToString() + " " + sQuery; } **bool recExists = myReader.HasRows**; I use this same identical code in a Windows Client app with no problems. What am I missing???? Thanks, Dave

[Christian Graus]

If that's a copy and paste of the code, it should work fine. I'm assuming there's something else that's not clear from what you copied and pasted. Is all of this an exact copy and paste of the whole function ? Of course, it's not good code. You should check if myreader is null, because if execute reader blows up, it could well be.

Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

[Lost User]

Change SqlDataReader myReader; to SqlDataReader myReader = null; and you should be fine

[Member 4645801]

Excellent.... That worked great, but why do I need to set the value to null in the console app and not in the Windows Forms app????

[Lost User]

(Just a guess since I don't know all your code) Maybe the SqlDataReader used to be a field instead of a local? Fields are initialized automatically whereas locals aren't so they often need explicit initialization

[Christian Graus]

Oh - yeah, I see the issue now. That is really dumb, IMO, I've had that happen too.

Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

[Zoki Manas]

Try your code like this: string sResponse; SqlDataReader myReader; bool recExists = false; // Check existence of tracking record sQuery = "Select * from tracking where shipper_id = '" + sShipperId + "' AND shipper_ack = '" + sShipperAck + "'"; myCommand1 = new SqlCommand(sQuery, conn); try { myReader = myCommand1.ExecuteReader(); bool recExists = myReader.HasRows; } catch (Exception e2) { conn.Close(); conn.Dispose(); sResponse = e2.GetBaseException().ToString() + " " + sQuery; } // for example return recExists; Hope this helps

[carlecomm]

change "SqlDataReader myReader;" to "SqlDataReader myReader = null;" and try again.