System.FormatException: Input string was not in a correct format.???? RSS

• • Reply
  

  ShilpaSunil

  Member

  505 Points

  144 Posts

  Re: System.FormatException: Input string was not in a correct format.????

  Sep 07, 2009 10:34 AM|LINK

  Again u r getting null value i think

  by default in stored procedure , if @HowManyProducts count is 0, u set @HowManyProducts to zero,

  
  

  oterwise use iif() condition to check where null or not , after that u convert it.
  

  
  

  
  

  Shilpa Sunil
• • Reply
  

  aduhperf

  Member

  20 Points

  54 Posts

  Re: System.FormatException: Input string was not in a correct format.????

  Sep 07, 2009 11:01 AM|LINK

  thanks for ur response. But please i still dont ge itt. cud  u explain it wit some  lines of code. thanks

• • Reply
  

  aduhperf

  Member

  20 Points

  54 Posts

  Re: System.FormatException: Input string was not in a correct format.????

  Sep 07, 2009 06:30 PM|LINK

  I have gotten the solutions i figured dat that the @HowManyProducts was returning null values

  so wat i did was check for isnull using 

   SELECT @HowManyProducts = isNull (COUNT (ProductID), 0) FROM @Products

• • Reply
  

  chetan.sarod...

  All-Star

  65619 Points

  11118 Posts

  Re: System.FormatException: Input string was not in a correct format.????

  Sep 16, 2009 03:14 AM|LINK

   Thats nice

  Chetan Sarode
  Senior Software Engineer,
  Approva Systems Pvt Ltd, Pune, India.