>Hi,
>
>I've inherited an ASP.NET application which makes use of DataSets and TableAdapters for displaying/editing data.
>
>I've added in 2 new columns to a table, with all the vales in these columns being null. I've adjusted the DataTable and TableAdpaters accordingly.
>
>Now when I try to access a web page which uses this table, but does not display either of these new fields, I get this error:
>
>

Exception Details: System.InvalidCastException: Specified cast is not valid.
>
>Source Error: 
>
>
>Line 11323:                get {
>Line 11324:                    try {
>Line 11325:                        return ((decimal)(this[this.tablePNRs.ChargeColumn]));
>Line 11326:                    }
>Line 11327:                    catch (global::System.InvalidCastException e) {
>
>Source File: D:\Development\VS2010\RESREPRICER_asp4\RESREPRICERDataSet.Designer.cs    Line: 11325 
>
>Stack Trace: 
>
>
>[InvalidCastException: Specified cast is not valid.]
>   RESREPRICER.Web.PNRsRow.get_Charge() in D:\Development\VS2010\RESREPRICER_asp4\RESREPRICERDataSet.Designer.cs:11325
>
>[StrongTypingException: The value for column 'Charge' in table 'PNRs' is DBNull.]
>   RESREPRICER.Web.PNRsRow.get_Charge() in D:\Development\VS2010\RESREPRICER_asp4\RESREPRICERDataSet.Designer.cs:11328
>   RESREPRICER.Web.PrepareInvoicesEdit.butCreate_Click(Object sender, EventArgs e) in D:\Development\VS2010\RESREPRICER_asp4\PrepareInvoicesEdit.aspx.cs:217
>   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +9628614
>   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +103
>   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
>   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
>   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +35
>   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1724

>
>What do I need to do to fix this?
>
>This will also lead me on to other issues with passing in nulls to the insert an dupdate of this data, but I'll leave that alone until I understand what's going on here.

Hi Frank,

Basically, you can't cast DBNull to decimal, because it is unknown.

Take a look at this

https://msdn.microsoft.com/en-us/library/system.convert.isdbnull(v=vs.110).aspx

You need to test for DBNull, then decide how to display that to the user..