Fastreport + Microsoft Compact Sql
Всем привет!
Никто не сталкивался с задачей использования FR.NET с MS SQL Compact?
По инструкции написал свой коннектор, все работает, кроме передачи параметров в отчет (( постоянно ругается на неверный формат параметра:
Никто не сталкивался с задачей использования FR.NET с MS SQL Compact?
По инструкции написал свой коннектор, все работает, кроме передачи параметров в отчет (( постоянно ругается на неверный формат параметра:
System.FormatException: mid : - Input string was not in a correct format.
at System.Data.SqlServerCe.SqlCeCommand.FillParameterDataBindings()
at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
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(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at XKassa.Reports.CompactSQLConnection.FillTableData(DataTable table, String selectCommand, CommandParameterCollection parameters) in D:\Projects\XKаssa\XKаssa\XKаssa\Reports\CompactSQLConnection.cs:line 176
at FastReport.Data.DataConnectionBase.FillTable(TableDataSource source)
at FastReport.Data.TableDataSource.LoadData(ArrayList rows)
at FastReport.Data.DataSourceBase.iyBP2hsNn()
at FastReport.Data.DataSourceBase.Init(Relation relation, String filter, SortCollection sort)
at FastReport.Data.DataSourceBase.Init(DataSourceBase parentData, String filter, SortCollection sort)
at FastReport.DataBand.InitDataSource()
at FastReport.Engine.ReportEngine.pvnx1RX5p(DataBand )
at FastReport.Engine.ReportEngine.UyFbX3nilX(BandCollection )
at FastReport.Engine.ReportEngine.khgbGuQrA3(ReportPage )
at FastReport.Engine.ReportEngine.x95btWK1rj()
at FastReport.Engine.ReportEngine.LEyXJ46li(ReportPage )
at FastReport.Engine.ReportEngine.DMAQhZaqp(Boolean , Boolean , ReportPage )
at FastReport.Engine.ReportEngine.TcpwDk5F4(Boolean , Boolean )
at FastReport.Report.Prepare(Boolean append)
at FastReport.Report.Show(Boolean modal, Form owner)
at FastReport.Report.Show()
at XKassa.Operations.toolStripMenuItem5_Click(Object sender, EventArgs e) in D:\Projects\XKassa\XKassa\XKassa\Operations.cs:line 126
at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ToolStrip.WndProc(Message& m)
at System.Windows.Forms.ToolStripDropDown.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Комментарии
Ответил в тикете.