Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot set Column 'IRDate' to be null. Please use DBNull
Message
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Miscellaneous
Thread ID:
01260333
Message ID:
01260449
Views:
12
I was the earlier thread about a HotFix that you suggested would solve the issue. I installed the 8/17/2007 v2.4 Hotfix (uninstalled prior version first) and rebuilt my project, but I'm still getting the same error. Do I need to remove and then add back Mere Mortals referemces?


>Greetings Kevin,
>
>Any ideas about this. The table has a date field that has null values to start with. I'm editing the row in a gridview and setting the date ( I can see the valid date value when debugging). Then I get this error when calling this.Save. It seems like if the data contained null values to start with you should be able to save it back without this happening.
>
>Regards,
>
>E.R.
>
>
>System.ArgumentException was unhandled by user code
> Message="Cannot set Column 'IRDate' to be null. Please use DBNull instead."
> Source="System.Data"
> StackTrace:
> at System.Data.DataRow.set_Item(DataColumn column, Object value)
> at System.Data.DataRow.set_Item(String columnName, Object value)
> at OakLeaf.MM.Main.Web.UI.WebControls.mmGridView.BindBack(DataSet ds, String tableName)
> at OakLeaf.MM.Main.Web.UI.mmWebBindingStrategyDataGrid.BindData(ImmWebBindingDataGrid mmGrid, mmBusinessObject bizObj, Boolean bindBack, mmBusinessStateChangeEventArgs e)
> at OakLeaf.MM.Main.Web.UI.mmWebBindingStrategyDataGrid.BindData(ImmWebBindingDataGrid mmGrid, mmBaseBusinessObject bizObj, Boolean bindBack, mmBusinessStateChangeEventArgs e)
> at OakLeaf.MM.Main.Web.UI.WebControls.mmGridView.StateChangeHandler(mmBaseBusinessObject bizObj, mmBusinessStateChangeEventArgs e)
> at OakLeaf.MM.Main.Business.mmBusinessObject.OnStateChange(mmBusinessState bizState, String tableName, Object primaryKeyValue, Object[] primaryKeyValues)
> at OakLeaf.MM.Main.Business.mmBusinessObject.CallStateChange(mmBusinessState bizState, String tableName, DataRow dr)
> at OakLeaf.MM.Main.Business.mmBusinessObject.CallStateChange(mmBusinessState bizState, String tableName)
> at OakLeaf.MM.Main.Business.mmBusinessObject.PreSaveProcessing(DataSet ds, String tableName)
> at OakLeaf.MM.Main.Business.mmBusinessObject.SaveDataSet(DataSet ds, String tableName, String databaseKey, IDbDataAdapter dbAdapter)
> at OakLeaf.MM.Main.Business.mmBusinessObject.SaveDataSet(DataSet ds, String tableName, String databaseKey)
> at OakLeaf.MM.Main.Business.mmBusinessObject.SaveDataSet(DataSet ds, String tableName)
> at OakLeaf.MM.Main.Business.mmBusinessObject.SaveDataSet(DataSet ds)
> at OakLeaf.MM.Main.Web.UI.mmBusinessWebPage.Save(mmBusinessObject bizObj, DataSet ds, String tableName)
> at OakLeaf.MM.Main.Web.UI.mmBusinessWebPage.Save(mmBusinessObject bizObj, DataSet ds)
> at VisitForm.gvVaccinesRequested_RowUpdating(Object sender, GridViewUpdateEventArgs e) VisitForm.aspx.cs:line 537
> at System.Web.UI.WebControls.GridView.OnRowUpdating(GridViewUpdateEventArgs e)
> at System.Web.UI.WebControls.GridView.HandleUpdate(GridViewRow row, Int32 rowIndex, Boolean causesValidation)
> at System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup)
> at System.Web.UI.WebControls.GridView.OnBubbleEvent(Object source, EventArgs e)
> at OakLeaf.MM.Main.Web.UI.WebControls.mmGridView.OnBubbleEvent(Object source, EventArgs e)
> at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
> at System.Web.UI.WebControls.GridViewRow.OnBubbleEvent(Object source, EventArgs e)
> at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
> at System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e)
> at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument)
> at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
> at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
> at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
> at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
>
>
Regards,

E.R. Gilmore
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform