Object cannot be cast from DBNull to other types [Answered]RSS

• • Reply
  asp.ambur

  Member

  399 Points

  1101 Posts

  Object cannot be cast from DBNull to other types

  Mar 25, 2017 04:06 AM|asp.ambur|LINK

  Hello

  This is my code

      <asp:TemplateField HeaderText="Closing Value">                   
                          <ItemTemplate>
                              <asp:Label ID="L4" runat="server" Text='<%# Convert.ToDouble(Eval("m_Closing")) * Convert.ToDouble(Eval("ChemicalRatePerUnit"))%>'></asp:Label>
                          </ItemTemplate>   
                          <FooterTemplate>
                              <asp:Label ID="GTV4" runat="server"></asp:Label>
                          </FooterTemplate> 
                      </asp:TemplateField>

  How to avoid this below from the above code

  Object cannot be cast from DBNull to other types.

  Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
  
  Exception Details: System.InvalidCastException: Object cannot be cast from DBNull to other types.

• • Reply
  oned_gk

  All-Star

  52202 Points

  15507 Posts

  Re: Object cannot be cast from DBNull to other types

  Mar 25, 2017 04:38 AM|oned_gk|LINK

  This because the data is null, the trick is ensure the result always has value

  select isnull(m_Closing,0) as m_Closing

  Programming to simplify, don't look for difficult way
  Suwandi - Non Graduate Programmer
• • Reply
  asp.ambur

  Member

  399 Points

  1101 Posts

  Re: Object cannot be cast from DBNull to other types

  Mar 25, 2017 04:49 AM|asp.ambur|LINK

  Can it be possible to do in aspx page in this below code

   <asp:Label ID="L4" runat="server" Text='<%# Convert.ToDouble(Eval("m_Closing")) * Convert.ToDouble(Eval("ChemicalRatePerUnit"))%>'></asp:Label>
                         

• • Reply
  oned_gk

  All-Star

  52202 Points

  15507 Posts

  Re: Object cannot be cast from DBNull to other types

  Mar 25, 2017 07:01 AM|oned_gk|LINK

  vb

  IIF(IsDbNull(Eval("closing")),0,Convert.ToDouble(Eval("Closing")))

  c#

  Eval("closing")!=null ? Convert.ToDouble(Eval("closing")), 0

  vb
  

  Convert.ToDouble(IIF(IsDbNull(Eval("closing")),0,Eval("Closing")))

  Programming to simplify, don't look for difficult way
  Suwandi - Non Graduate Programmer
• • Reply
  asp.ambur

  Member

  399 Points

  1101 Posts

  Re: Object cannot be cast from DBNull to other types

  Mar 25, 2017 10:37 AM|asp.ambur|LINK

  oned_gk

  vb

  IIF(IsDbNull(Eval("closing")),0,Convert.ToDouble(Eval("Closing")))

  c#

  Eval("closing")!=null ? Convert.ToDouble(Eval("closing")), 0

  vb

  Convert.ToDouble(IIF(IsDbNull(Eval("closing")),0,Eval("Closing")))

  I'm using asp.net 2.0 C#

  getting error

  Syntax error, ':' expected

• • Reply
  oned_gk

  All-Star

  52202 Points

  15507 Posts

  Re: Object cannot be cast from DBNull to other types

  Mar 25, 2017 10:40 AM|oned_gk|LINK

  i mean

  Eval("closing")!=null ? Convert.ToDouble(Eval("closing")) : 0

  Programming to simplify, don't look for difficult way
  Suwandi - Non Graduate Programmer
• • Reply
  asp.ambur

  Member

  399 Points

  1101 Posts

  Re: Object cannot be cast from DBNull to other types

  Mar 25, 2017 10:48 AM|asp.ambur|LINK

  oned_gk

  i mean

  Eval("closing")!=null ? Convert.ToDouble(Eval("closing")) : 0

  Still the same error

  Object cannot be cast from DBNull to other types.

• • Reply
  asp.ambur

  Member

  399 Points

  1101 Posts

  Re: Object cannot be cast from DBNull to other types

  Mar 25, 2017 10:51 AM|asp.ambur|LINK

  This is my code for Multiply

  <asp:Label ID="L4" runat="server" Text='<%# Convert.ToDouble(Eval("m_Closing")) * Convert.ToDouble(Eval("ChemicalRatePerUnit"))%>'></asp:Label>

  Your Code Please

• • Reply
  Khuram.Shahz...

  Participant

  1596 Points

  766 Posts

  Re: Object cannot be cast from DBNull to other types

  Mar 25, 2017 11:57 AM|Khuram.Shahzad|LINK

  As you already now that there is some issue with your data that raise casting issue, why not you have a public method in your code behind and you pass parameters from UI to method , its easy to debug that function in Cb and you can have try catch block over there, you can do more..

  We cannot solve our problems with the same thinking we used when we created them.
• • Reply
  asp.ambur

  Member

  399 Points

  1101 Posts

  Re: Object cannot be cast from DBNull to other types

  Mar 25, 2017 12:07 PM|asp.ambur|LINK

  any other way to do it in rowdatabound.. to avoid this error

• • Reply
  AngelinaJoli...

  Contributor

  5270 Points

  2307 Posts

  Re: Object cannot be cast from DBNull to other types

  Mar 25, 2017 01:53 PM|AngelinaJolie|LINK

  Hi asp.ambur,

  Please refer to code below:

  <asp:Label ID="L4" runat="server" Text='<%= Eval("m_Closing") * Eval("ChemicalRatePerUnit")%>'></asp:Label>

  please have a try.

  Best regards,

  Jolie
   
                        

  MSDN Community Support
  Please remember to click "Mark as Answer" the responses that resolved your issue.
  If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
  
• • Reply
  oned_gk

  All-Star

  52202 Points

  15507 Posts

  Re: Object cannot be cast from DBNull to other types

  Mar 25, 2017 03:36 PM|oned_gk|LINK

  ((Eval("m_Closing")!=null ? Convert.ToDouble(Eval("m_Closing")) : 0) * 
  (Eval("ChemicalRatePerUnit")!=null ? Convert.ToDouble(Eval("ChemicalRatePerUnit")) : 0)).ToString()

  Programming to simplify, don't look for difficult way
  Suwandi - Non Graduate Programmer
• • Reply
  asp.ambur

  Member

  399 Points

  1101 Posts

  Re: Object cannot be cast from DBNull to other types

  Mar 26, 2017 07:53 AM|asp.ambur|LINK

  oned_gk

  ((Eval("m_Closing")!=null ? Convert.ToDouble(Eval("m_Closing")) : 0) * 
  (Eval("ChemicalRatePerUnit")!=null ? Convert.ToDouble(Eval("ChemicalRatePerUnit")) : 0)).ToString()

  Again same error

  Object cannot be cast from DBNull to other types.

• • Reply
  kaushalparik...

  All-Star

  31342 Points

  7050 Posts

  Re: Object cannot be cast from DBNull to other types

  Mar 27, 2017 10:40 AM|kaushalparik27|LINK

  asp.ambur

  Object cannot be cast from DBNull to other types.

  ((Eval("m_Closing")!= DBNull.Value ? Convert.ToDouble(Eval("m_Closing")) : 0) * 
  (Eval("ChemicalRatePerUnit")!= DBNull.Value ? Convert.ToDouble(Eval("ChemicalRatePerUnit")) : 0)).ToString()

  नमस्ते,
  [KaushaL] Blog Twitter [MS MVP 2008 & 2009] [MCC 2011] [MVP Reconnect 2017]
  Don't forget to click "Mark as Answer" on the post that helped you