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

  52493 Points

  15665 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

  52493 Points

  15665 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

  52493 Points

  15665 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...

  Contributor

  2096 Points

  1040 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..

  "Mark as Answer" if that helps you.
• • 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

  5290 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

  52493 Points

  15665 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

  31362 Points

  7055 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