Hi,
I am creating an object of FbDataAdapter, passing the constructor an object
of FbCommand . The CommandText of this FbCommand object is a stored
procedure.
This worked fine. Recently calling Fill method of FbDataAdapter reports
error [appended at the end of mail]. The copied CommandText, during debug,
runs fine in Flamerobin. Also when i change the code to restrict the number
of rows to say 50, it runs fine. Changed this in two ways (both ways it
worked):
(1) In the querry used " SELECT first 50 ... "
(2) Passed arguments to Fill method: da.*Fill*(ds, 0, 50, "Table");
Please help me to fetch all records using Fill method of FbDataAdapter.
THE ERROR reported:
System.IO.IOException: I/O error occurred.
at Byte[] FirebirdSql.Data.Client.Managed.XdrStream.ReadBytes(System.Int32
count)
at Int32 FirebirdSql.Data.Client.Managed.XdrStream.ReadInt32()
at Int32 FirebirdSql.Data.Client.Managed.XdrStream.ReadNextOperation()
at Int32
FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.NextOperation()
at Int32
FirebirdSql.Data.Client.Managed.Version11.GdsDatabase.NextOperation()
at DbValue[] FirebirdSql.Data.Client.Managed.Version10.GdsStatement.Fetch()
at DbValue[] FirebirdSql.Data.FirebirdClient.FbCommand.Fetch()
at Boolean FirebirdSql.Data.FirebirdClient.FbDataReader.Read()
at Boolean System.Data.ProviderBase.DataReaderContainer.Read()
at Int32
System.Data.Common.DataAdapter.FillLoadDataRow(System.Data.ProviderBase.SchemaMapping
mapping)
at Int32 System.Data.Common.DataAdapter.FillFromReader(System.Data.DataSet
dataset, System.Data.DataTable datatable, System.String srcTable,
System.Data.ProviderBase.DataReaderContainer dataReader, System.Int32
startRecord, System.Int32 maxRecords, System.Data.DataColumn
parentChapterColumn, System.Object parentChapterValue)
at Int32 System.Data.Common.DataAdapter.Fill(System.Data.DataSet dataSet,
System.String srcTable, System.Data.IDataReader dataReader, System.Int32
startRecord, System.Int32 maxRecords)
at Int32 System.Data.Common.DbDataAdapter.FillInternal(System.Data.DataSet
dataset, System.Data.DataTable[] datatables, System.Int32 startRecord,
System.Int32 maxRecords, System.String srcTable, System.Data.IDbCommand
command, System.Data.CommandBehavior behavior)
at Int32 System.Data.Common.DbDataAdapter.Fill(System.Data.DataSet dataSet,
System.Int32 startRecord, System.Int32 maxRecords, System.String srcTable,
System.Data.IDbCommand command, System.Data.CommandBehavior behavior)
at Int32 System.Data.Common.DbDataAdapter.Fill(System.Data.DataSet dataSet,
System.String srcTable)
at static DataTable HMSLib.Ctrls.DtFromObjArray(System.Object arg)
at static Object HMSLib.Ctrls.DgvDtFromObjArray(System.Object args)
at static System.Void HMSLib.Ctrls.DgvDtProc(System.Object args)
at static System.Void
System.Threading.ThreadHelper.ThreadStart_Context(System.Object state)
at static System.Void
System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext
executionContext, System.Threading.ContextCallback callback, System.Object
state, System.Boolean preserveSyncCtx)
at static System.Void
System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext
executionContext, System.Threading.ContextCallback callback, System.Object
state, System.Boolean preserveSyncCtx)
at static System.Void
System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext
executionContext, System.Threading.ContextCallback callback, System.Object
state)
at System.Void System.Threading.ThreadHelper.ThreadStart(System.Object obj)
Regards,
Rajiv
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
