System.InvalidCastException: Specified cast is not valid.

I have an table with a field of bit. the fields name is Active.
When trying to add that field to a label it gives me the following.
It all works when not using this field.

Error : System.InvalidCastException: Specified cast is not valid.
get {
Line 2057: try {
Line 2058: return ((bool)(this[this.tableJob_Posts.ActiveColumn]));
Line 2059: }
Line 2060: catch (System.InvalidCastException e) {

My code is as follows.

jpDT = jpTA.GetJob_PostsByJobID(jid);

foreach (DataSet1.Job_PostsRow jprin jpDT)

{

if (jpr.Active !=null)

{

this.ActiveLabel.Text = jpr.Active.ToString();

}

Is this field nullable in the database, and are you using TableAdapters? If so, can't simply check for null. You need to instead call the method IsActiveNull() which will be auto-generated by your row class if the field is nullable. This will then check for DbNull instead of null.

System.MissingFieldException: Field not found

http://groups.google.com/groups?hl=...%26filter %3D0

The above thread is old but has anyone come up with a solution to this
issue? The intermittent problem started after I added a UserControl that
contains a third party control.

The problem does not occur on my development workstation. But I have a
development site on the same server which hosts the production site. I
simply copy the executable from this site to the production site. Invariably
when I access the production site again for the first time, I get a compile
error. If I replace the dll again, the site works fine. But only for another
few days until I get the same exception.

Obviously the temporary fix is unacceptable.Further to my previous post, here's the problem described in another forum:

http://gotdotnet.com/community/mess...141&Page=1&so=1

It appears this behavior occurs when a third party control is embedded in a
UserControl on non-development machines.

Anyone have any ideas? The application going down every few days is really
unacceptable. Thanks in advance.
Field not found: SmartSub.MenuBar.webMenu.
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.MissingFieldException: Field not found:
SmartSub.MenuBar.webMenu.

Source Error:

[No relevant source lines]

Source File: c:\WINNT\Microsoft.NET\Framework\v1.1.4322\Tempora ry ASP.NET
Files\smartsub\c3628410\4e846907\y7d4qwa4.0.cs Line: 0

Stack Trace:

[MissingFieldException: Field not found: SmartSub.MenuBar.webMenu.]
ASP.MenuBar_ascx.__BuildControlTree(Control __ctrl) +0
ASP.MenuBar_ascx.FrameworkInitialize() in
c:\WINNT\Microsoft.NET\Framework\v1.1.4322\Tempora ry ASP.NET
Files\smartsub\c3628410\4e846907\y7d4qwa4.0.cs:0
System.Web.UI.UserControl.InitializeAsUserControlI nternal() +31
System.Web.UI.UserControl.InitializeAsUserControl( Page page) +15
ASP.Default_aspx.__BuildControlmenuBar() in C:\SmartSub\default.aspx:15
ASP.Default_aspx.__BuildControlformDefault() in
C:\SmartSub\default.aspx:14
ASP.Default_aspx.__BuildControlTree(Control __ctrl) in
C:\SmartSub\default.aspx:1
ASP.Default_aspx.FrameworkInitialize() in
c:\WINNT\Microsoft.NET\Framework\v1.1.4322\Tempora ry ASP.NET
Files\smartsub\c3628410\4e846907\koa-hius.0.cs:0
System.Web.UI.Page.ProcessRequest() +84
System.Web.UI.Page.ProcessRequest(HttpContext context) +18

System.Web.CallHandlerExecutionStep.System.Web.Htt pApplication+IExecutionSte
p.Execute() +179
System.Web.HttpApplication.ExecuteStep(IExecutionS tep step, Boolean&
completedSynchronously) +87

-----------------------
--
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET
Version:1.1.4322.573