Microsoft Windows 2000/NT/2003: Cast Exception

• ianmoores / 118 / Wed, 10 Feb 2010 08:06:00 GMT / Comments (0)
• That's very odd the only thing i could think of is that somewhere on your
  live machine (assuming it is using a different database) you are returning a
  NULL value, which won't cast to an int, but might possibly not blow up using
  the Convert.ToInt32 that's a pure guess though
  
  
  >
  >I have a method in my DAL that accesses the DB to check the uniqueness of
  >an
  >item.
  >
  >From my sql (MySql db) I am returning a count (select count(*) )
  >
  >int recCount;
  >recCount = (int)cmd.ExecuteScalar();
  >
  >This works fine on my Dev machine. However, it is causing an invalid cast
  >exception on the Live machine and I have to change the line to the
  >following
  >to get the right result:
  >
  >recCount = Convert.ToInt32(myCmd.ExecuteScalar().ToString());
  >
  >Any ideas why this is happening?
  >
  >Thanks,
  >C
  >
  >
  >
  
  >This email and any files transmitted with it are confidential and
  >intended solely for the use of the individual or entity to whom they
  >are addressed. If you have received this email in error please notify
  >the system manager.
  >
  >This footnote also confirms that this email message has been swept by
  >MIMEsweeper for the presence of computer viruses.
  >
  >www.mimesweeper.com
  
  Yahoo! Groups Sponsor
  <font face=arial size=-1><a href="*">In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide!</a>.</font>
  
  Yahoo! Groups Links
  
  <*To visit your group on the web, go to:
  
  <*To unsubscribe from this group, send an email to:
  CSharpNET-unsubscribe (AT) yahoogroups (DOT) com
  
  <*Your use of Yahoo! Groups is subject to:
  
• Keywords:

  cast, exception, microsoft, windows 2000, nt, 2003

• http://www.edevs.com/windows-2000-nt/76643/«« Last Thread - Next Thread »»