Ultragrid Exception thrown: 'System.FormatException' in mscorlib.dll

Hello,

I have a problem with the grid where it throws alot of “Exception thrown: ‘System.FormatException'” in mscorlib.dll exceptions.

It throws it alot so the grid gets really slow.

I think it has something to do with empty date columns but I don’t know how to solve it, I tried to fill my entire database so the dates wouldn’t be empty anymore and I still got the exceptions.

I’m using version 18.2 and a MSSQL database that fills the grid with an sqladapter and datatable. The column is a smalldatetime, I also tried changing it in a regular datetime.

I hope someone can help me.

Thanks in advance!

Kind Regards,

Robbe

Hello Rudy,

Thank you for posting. I followed the steps you suggested and was unable to reproduce the behavior you’re describing.

As you are getting FormatException, may I know which format did you set for the date column?

I created a sample of UltraGrid having a date column and bind it with a dataTable, for the date column I set the format “d” or “hh:mm:ss” but not getting any exception. I have attached the sample project I used to test this. Please test this project on your PC; whether or not it works correctly may help indicate the nature of this problem.

If the project does not work correctly, this indicates either a problem possibly specific to your environment, or a difference in the DLL versions we are using. My test was performed using version 18.2.20182.175.

If the project does show the product feature working correctly, this indicates a possible problem in the code of your application. It will help if you can provide a small, isolated sample application that demonstrates the behavior you are seeing.

Or, if this sample project is not an accurate demonstration of what you’re trying to do, please feel free to modify it and send it back, or send a small sample project of your own if you have one.

Please let me know if I can provide any further assistance.

Sincerely,Divya JainAssociate Software Developer

 

Attachments:

1. 6470.Sample.zip

Hello Divya Jain,

Thanks for the sample, in your sample it didn't have the format exceptions. But I searched some more and I found the problem. The dates where empty but that only gave some of the format exceptions. The real problem was because I had changed a valuemember of a dropdown grid-column to a different database-column and the values that where currently in the linked database-column where different (so not in the dropdownvaluelist anymore) and gave all the format exceptions.

Thanks for the help

Robbe