Hii,
Devextreme datagrid filter row , When I search with the date I selected, "Conversion failed when converting date and/or time from character string" error,
Grid settings , our database date format and "datasourceloadoptions DataSource" of the filter type information is included in the attached screenshot, due to the date filter problem, we receive errors on our grids, we request your support,
Best regards
Hi,
Entity Framework 4.6.1 doesn't support .NET Core 2.2. (see Entity Framework 6). So, it looks like you're using EF Core in your application. I tested the same config using .NET Core 2 and the Northwind database and reproduced the same error. Then I found the following issue:
https://github.com/aspnet/EntityFrameworkCore/issues/12797
https://github.com/aspnet/EntityFrameworkCore/issues/14095
The problem is not directly related to DevExtremeAspNet.Data and occurs in the EF Core library if nullable DateTime fields are used. According to that thread, it should be possible to overcome the issue using the following workaround:
C#protected override void OnModelCreating(ModelBuilder modelBuilder){
modelBuilder.Entity<Order>(entity =>
{
....
entity.Property(e => e.YourCoumnName).HasColumnType("datetime");
});
}
I've also attached an example of my web service and DataGrid where the issue is not reproducible.
Let us know if this suggestion helps.
Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.
Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.
Hi,
The issue is quite strange. In a common case, our grid should work fine in this situation. For instance, check our Web API Service demo.
Make sure that the required field has the DateTime type in a model. If this part is correct, please specify the following information for further research:
2. The DevExtremeAspNet.Data version and DB Provider you're using.
Hi,
Thanks for Answer ,
We are sure that you have a DateTime type,
attached to the information you want,
DevExtremeAspNet.Data version = 18.2, sql management studio 2017
Hi,
Thank you for the update. By "Db Provider" I mean Entity Framework, EF Core, etc. Please specify which one you have.
Also the "DevExtremeAspNet.Data" doesn't have v18.2 (see releases). Please double-check this part and specify the exact version you have. If your version is older than 2.0, I recommend you update to v2.0+ and check if the problem persists.
Your time and cooperation are greatly appreciated.
Hi,
Thank you for answer ,
Db Provider = Entity Framework 4.6.1
Api = .net Core 2.2
Typscript versiyon 2.8
DevExtremeAspNet.Data = v2.2.1
Hi,
Our problem continues, do you have a suggestion for the solution,
Thank you for your help