What is the cause of the following exception?

companymj

Exported data: System.InvalidOperationException: Conversion failed because the DateTime data value overflowed the type specified for the DateTime value part in the consumer's buffer.
   at System.Data.OleDb.ColumnBinding.Value ()
   at System.Data.OleDb.OleDbDataReader.GetValues ​​(Object [] values)
   at System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataReader.GetValues ​​(Object [] values)
   at System.Data.ProviderBase.SchemaMapping.LoadDataRow ()
   at System.Data.Common.DataAdapter.FillLoadDataRow (SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader (DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
   at System.Data.Common.DataAdapter.Fill (DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   at System.Data.Common.DbDataAdapter.FillInternal (DataSet dataset, DataTable [] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill (DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill (DataSet dataSet, String srcTable)
   at MsaFluxC_2.Service_C.myTimer_Elapsed (Object sender, ElapsedEventArgs e)

5teawty

Incorrect date format or out of range

wudi1982

Date format conversion failed! ~

bellonxcc

As above, you can only see these, the code is posted to see

qwer000

Very likely:
You are in the database, the value of the date column is empty, and you use Convert.toDateTime () when you bind the page

Add a conditional judgment

companymj

Convert.toDateTime () is not used when querying Fill. Will it be related to the client's date and time zone configuration?

companymj

The tips in Chinese are as follows:
An exception occurred in the MsaFluxC export data: System.InvalidOperationException: The conversion failed because the DateTime data value overflowed the type specified for the DateTime value part in the user buffer.
   In System.Data.OleDb.ColumnBinding.Value ()
   At System.Data.OleDb.OleDbDataReader.GetValues ​​(Object [] values)
   At System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataReader.GetValues ​​(Object [] values)
   At System.Data.ProviderBase.SchemaMapping.LoadDataRow ()
   At System.Data.Common.DataAdapter.FillLoadDataRow (SchemaMapping mapping)
   At System.Data.Common.DataAdapter.FillFromReader (DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
   At System.Data.Common.DataAdapter.Fill (DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   At System.Data.Common.DbDataAdapter.FillInternal (DataSet dataset, DataTable [] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   At System.Data.Common.DbDataAdapter.Fill (DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   At System.Data.Common.DbDataAdapter.Fill (DataSet dataSet, String srcTable)
   At MsaFluxC_2.Service_C.myTimer_Elapsed (Object sender, ElapsedEventArgs e) position E:\zxp\MyProgram\MsaFlux\Src\MsaFlux_2.0\MsaFluxC\Service_C.cs: line number 186
 Table_Log: select * from DTYW_CBSBGT where MRUT> = '2016-1-1 0:00:00' and MRUT <'2017-1-3 9:51:41' and GXBZ <> 'D'

targetking

Put select * from DTYW_CBSBGT where MRUT> = '2016-1-1 0:00:00' and MRUT <'2017-1-3 9:51:41' and GXBZ <> 'D'
Take a look in the query analyzer.

江南小色

.net datetime and database datetime, smalldatetime value range is different, it is different.
Check the specific value.

companymj

The specific value of datetime is the default 1900-01-01 of Sybase database

MsaFluxC export data has an exception: System.InvalidOperationException: The provider could not determine the DateTime value. For example, the row was just created, the default for the DateTime column was not available, and the consumer had not yet set a new DateTime value.
   at System.Data.OleDb.ColumnBinding.Value ()
   at System.Data.OleDb.OleDbDataReader.GetValues ​​(Object [] values)
   at System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataReader.GetValues ​​(Object [] values)
   at System.Data.ProviderBase.SchemaMapping.LoadDataRow ()
   at System.Data.Common.DataAdapter.FillLoadDataRow (SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader (DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
   at System.Data.Common.DataAdapter.Fill (DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   at System.Data.Common.DbDataAdapter.FillInternal (DataSet dataset, DataTable [] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill (DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill (DataSet dataSet, String srcTable)
   at MsaFluxC_2.Service_C.myTimer_Elapsed (Object sender, ElapsedEventArgs e)
 Table_Log: select * from DTYW_CBSBYT where MRUT> = '2016-1-1 0:00:00' and MRUT <'2017-1-3 10:22:27' and GXBZ <> 'D'