RecordField type="date" in coolite 0.8

[dperera]

Hi,

from 0.8 coolite version, there is a problem with the date recordfields.

When I do the Coolite.Ext.Web.ChangeRecords Method:

ChangeRecords<USERS> lstUsers = e.DataHandler.ObjectData<USERS>();

and the date of the store is null value he throws a Exception:

Exception was unhandled by user code

Could not cast or convert from System.Int64 to System.Nullable`1[System.DateTime].

This don't pass with coolite 0.7.

[dperera]

I Have the same bug with Boolean Fields, but is not a problem for me.

You cannot solve this bug?

[Vladimir]

Hi,

Can you show example which we can test?

[jsemple]

I am also having the same issue in 0.8

Could not cast or convert from System.String to System.DateTime

Dim json As String = e.DataHandler.JsonData
Dim dataHandler As StoreDataHandler = New StoreDataHandler(json)
Dim data As ChangeRecords(Of MinQualification) = dataHandler.ObjectData(Of MinQualification)()

[Vladimir]

Hi guys,

We need a sample which reproduces the problem

[rcaunt]

I have found that if you bind a Store's DataSource to a DataSet that has rows that contain NULL data then an error is also thrown.

[jsemple]

I've got it working with VB.NET, but I'm guessing you're dealing with C#? You can use Rocky Lhotka's CSLA.NET (SafeDataReader class) in C# to ensure type safety of all fields coming back from whatever database.

[rcaunt]

I am working with C# yes. However, having had a quick look at the class I'm not sure it would always be suitable, for instance GetBoolean() returns false in the case of a DBNull which would render the equivelent of a false value into the gridpanel whereas I would like to see an empty cell.

[grmontero]

I have the same problem.
To reproduce this problem is simple.
Only create a Dataset and add a datatable that contains a column with NullValues.
When you want to bind this dataset to a Store. Crash. because the Store Not handle Null values.

I added two Images for an Idea.

Only Try to databind an Store to This datataBle and Crash.

Any Help...!

Thaks.

Atte: Gustavo Montero g.