Server Error in '/' Application.

The data value could not be converted for reasons other than sign mismatch or data overflow. For example, the data was corrupted in the data store but the row was still retrievable.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidCastException: The data value could not be converted for reasons other than sign mismatch or data overflow. For example, the data was corrupted in the data store but the row was still retrievable.

Source Error:


Line 82:         string orderby = ItemsColumns.DicreatedateColumn + " desc ";
Line 83: 
Line 84:         DataTable dt = GroupsItems.GetAllData(maxRow, "*", condition, orderby);
Line 85:         return BindItemsToHTML(dt);
Line 86:     }

Source File: d:\vhosts\pro14.tatthanh.vn\thietbidienschneider.net.vn\cms\display\News\SubControls\SubNewsHot.ascx.cs Line: 84

Stack Trace:


[InvalidCastException: The data value could not be converted for reasons other than sign mismatch or data overflow. For example, the data was corrupted in the data store but the row was still retrievable.]
   System.Data.OleDb.ColumnBinding.Value() +1285849
   System.Data.OleDb.OleDbDataReader.GetValues(Object[] values) +88
   System.Data.ProviderBase.CommonLanguageSubsetDataReader.GetValues(Object[] values) +13
   System.Data.ProviderBase.SchemaMapping.LoadDataRow() +38
   System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) +201
   System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) +201
   System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) +422
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +219
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +138
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +89
   TatThanhJsc.Database.SQLDatabase.GetData(OleDbCommand cmd) +599
   TatThanhJsc.Database.GroupsItems.GetAllData(String top, String fields, String condition, String orderby) +511
   cms_display_News_SubControls_SubNewsHot.GetLastest(String maxRow) in d:\vhosts\pro14.tatthanh.vn\thietbidienschneider.net.vn\cms\display\News\SubControls\SubNewsHot.ascx.cs:84
   cms_display_News_SubControls_SubNewsHot.GetGroups(String position) in d:\vhosts\pro14.tatthanh.vn\thietbidienschneider.net.vn\cms\display\News\SubControls\SubNewsHot.ascx.cs:60
   cms_display_News_SubControls_SubNewsHot.Page_Load(Object sender, EventArgs e) in d:\vhosts\pro14.tatthanh.vn\thietbidienschneider.net.vn\cms\display\News\SubControls\SubNewsHot.ascx.cs:23
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +52
   System.Web.UI.Control.OnLoad(EventArgs e) +97
   System.Web.UI.Control.LoadRecursive() +61
   System.Web.UI.Control.LoadRecursive() +134
   System.Web.UI.Control.LoadRecursive() +134
   System.Web.UI.Control.LoadRecursive() +134
   System.Web.UI.Control.LoadRecursive() +134
   System.Web.UI.Control.LoadRecursive() +134
   System.Web.UI.Control.LoadRecursive() +134
   System.Web.UI.Control.LoadRecursive() +134
   System.Web.UI.Control.LoadRecursive() +134
   System.Web.UI.Control.LoadRecursive() +134
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +693

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.9287.0