All--

Please help.

Can someone post a some simple code sample, (with a well-known database instance, such as Northwind), that shows how to use ExecuteMultiRowDataTableRetrievalQuery?

Function ExecuteMultiRowDataTableRetrievalQuery( _
   ByVal queryToExecute As IRetrievalQuery, _
   ByVal dataAdapterToUse As DbDataAdapter, _
   ByVal fieldsPersistenceInfo As IFieldPersistenceInfo() _
) As DataTable

I am new to LLBLGen and, unfortunately, I missing something in the explanation of ExecuteMultiRowDataTableRetrievalQuery and cannot get it to work.

FYI, I am using VB.NET, LLBLGen Adatpter Templates, SQL Server 2000, VS.NET 2003, Remoting, with both a WindowsForms client and an ASP.NET client.

Any help is appreciated.

Thank you.

--Mark Kamoski

Try using FetchTypedList to do what you are wanting instead. Take a look at the Generated code - Using the typed list classes, Adapter section in the documentation for some examples. If you have any problems with implementing it just post your questions with detail and the code that isn't working.

bclubb wrote:

Try using FetchTypedList to do what you are wanting instead. Take a look at the Generated code - Using the typed list classes, Adapter section in the documentation for some examples. If you have any problems with implementing it just post your questions with detail and the code that isn't working.

I appreciate the reply.

I am aware of the solution that you pose and, indeed, it is a good one.

While I grant that that solution does solve the technical issue, with all due respect, that solution does not actually answer the specific question regarding ExecuteMultiRowDataTableRetrievalQuery.

Judging from your answer, am I to guess that ExecuteMultiRowDataTableRetrievalQuery does not work or something like that?

What do you think?

Please advise.

Thank you.

--Mark Kamoski

This function is meant to be used internally by the system.

So please use TypedList, TypedView or dynamicList to return dataTable object. And their corresponding Fetch methods.