Negative. I did not encounter this problem as you described.
I have tried your database structure and insert a few rows as sample data:
INSERT INTO `userlogindetails` (`LoginId`,`UserName`,`LastLoginDateTime`,`LastLogoutDateTime`,`LoginStatus`,`LastUsageTime`) VALUES
(1,'aaa','2013-01-01 01:01:01','2013-01-01 01:02:02','active',30),
(2,'user1','2013-01-01 01:01:01','2013-01-01 01:31:00','ACTIVE',0.3),
and I am able to export and import the data with no error.
However, I did notice there is one common issue regarding the usage of zero date time in MySQL:
.NET Framework does not have zero date time value.
The possible minimum value of date time in .NET Framework is
In order for MySql.Data.DLL
(MySQL Connect/Net) which is the default connector used by
to retrieve zero date time
value from MySQL, you need to specify an extra connection option of
in your connection string.
Example of normal connection string:
Example of normal connection string with allowzerodatetime
If you initiate the connection without
parameter, you will receive the exception/error of
MySql.Data.Types.MySqlConversionException: Unable to convert MySQL data/time value to System.DateTime
This is not a bug, it is an expected behaviour. This exception is created by
If you initiate the connection with
, MySQL Dot Net Connector (Connector/NET) will store the datetime value in a new data type, called
. In other words, if the value in
field is zero date time (
), the Connector/NET will return data in
. However, this is already been handled by
You won't have to care about the data conversion, as long as you specify
in the connection string,
will work as normal.
Read more at here:
Frequently Asked Questions (FAQ) - Commonly Seen Error
If this is does solve your problem, perhaps you have to provide more details that will lead to the error described by you.
Try to upload a C# or VB.NET project that will create the error.