Fill Method of FbDataAdapter fails

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Fill Method of FbDataAdapter fails

LtColRDSChauhan

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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|

Re: Fill Method of FbDataAdapter fails

Jiří Činčura-2
What's the inner exception?

--
Mgr. Jiří Činčura
Independent IT Specialist


------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider