Devart Forums

Hi,

For a column returning interval data type of postgresql interval.
Datagridview shows weird data e.g is displayed as Is that right ?

Please send me (alexeyman*crlab*com) or post here a small test project to reproduce the problem.
Include the definition of your own database objects.
We will investigate the problem.

test data send. Please acknowledge

We have received the test data.
We are investigating this problem now.
I will contact you by email in the nearest time.
Could you please specify the versions/editions of:
- PostgreSQLDirect .NET;
- PostgreSQL server;
- OS;
- .NET Framework installed (is it MONO?).

Could you please specify the versions/editions of:

- PostgreSQLDirect .NET 3.50.25
- PostgreSQL server; 8.2.4
- OS; windows xp pro sp3 , tried the same on sp2 results the same
- .NET Framework installed (is it MONO?) , MS .NET 2.0 sp1

and VS 2005

Hello,

I have sent you an email with solution.
Let me know if the problem is solved.

No , the problem is stilll their . The interval comes with a trialling time . check the e-mail I have send you.

should I expect something new ?

I mean is something cooking ,as far as this problem is concerned.

Please check you email.
The solution is to set a proper format for the column in the DataGridView.

I have already tried that , moreover to best of my knowledge if no formatting is used in DefaultCellStyle property it should return the data as it is .


moreover you have the test case and you could have tried that yourself

later we could have discussed, how to make it work.

Unfortunately, we cannot provide a general advice on using formatting in DataGridView because this topic is beyond the scope of our support program.
TimeSpan struct doesn't have native implemented formatting