[CLOSED] Datecolumn: Unable to cast object of type 'System.DateTime' to type 'System.String'

[atroul]

I have a sql table with a column [WelcomeSent] with type: Datetime and null values existing in this column

I have this code to get the values from my DB and store them in a grid:

    var result = (from i in dc.vw_Users where i.id == id select i).ToList(); //error line
    storeUsers.DataSource = result;
    storeUsers.DataBind();

In my grid there is a column:

<ext:DateColumn runat="server" ID="ColUsersWelcomeSent"     DataIndex="WelcomeSent"     Text="WelcomeSent"  Width="80"  Format="dd/MM/yyyy" Hidden="true"></ext:DateColumn>

But when I run it I receive this error:

Unable to cast object of type 'System.DateTime' to type
'System.String'

Anyone know how I can fix that?

[atroul]

Please marked it as closed I found the solution:

Solved it by getting each column separately and parsing Date Column:

    var result = (from i in dc.vw_Users where i.id == id select new { UserId = i.UserId, id = i.id, SiId = i.SiId, FullName = i.FullName, UserName = i.UserName, RoId = i.RoId, Ro = i.Ro, Email = i.Email, WelcomeSent = (i.WelcomeSent != null && i.WelcomeSent.ToString().Length > 0 ? DateTime.Parse(i.WelcomeSent.ToString()) : new DateTime()), Signed = i.Signed, IsPri = i.IsPri, IsApproved = i.IsApproved, IsLocked = i.IsLockedOut, LoginStatus = i.LoginStatus, LastLoginDate = i.LastLoginDate, SignRights = i.SignRights, LastPasswordChangedDate = i.LastPasswordChangedDate, FailedPasswordAttemptCount = i.FailedPasswordAttemptCount, CompleteDate = i.CompleteDate, AccessDate = i.AccessDate, CertificationDate = i.CertificationDate, CertificateId = i.CertificateId, progress = i.progress });

[fabricio.murta]

Hello @atroul!

The most likely reason you are having this problem is you are not mapping the model correctly between the database and grid store, and the field is getting to the wrong column. The DateColumn works just fine with DateTime as you can see on most of our GridPanel examples in Examples Explorer. Some use DateColumn as a string value but several others use DateColumn as a DateTime object.

Here a couple examples:
- GridPanel from an array with local paging + remote loading
- Grid Panel cell editor with directMethod

I hope this helps!

[fabricio.murta]

Well, thanks for the feedback! Guess that was really an issue with the mapping then.