Hi,

In our project we have this data-driven combo box which opens in new web page with datasource based on the field which it has be clicked, whats that mean is if it is opened for txtCustomer it will show Customer data.

There is table contains all rows (data) for all type of possible combo box going to be used by the application. Table design is something like -

SysComboBox ComboID : 1 SQL: Select CustomerID, CustomerName from Customers

When I retrieve the record, I want to pass this SQL to LLBL Gen Pro to retrieve the Datasource.

Is there any way to pass raw SQL to LLBL Gen Pro. We can do it thru many other ways, but we want to have LLBL Gen Pro as standard for all our data access.

any help would be highly appreciated

thanks

Khuzema WISDOM

Hi,

You can use DataAcessAdapterBase.ExecuteMultiRowRetrievalQuery() witch executes the passed in retrieval query and retrieve the results in an EntityCollection.

HI,

Is there any pointer to an example, how it can be done with SQL String.

thanks

Khuzema

Similar issues was discussed here: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=7165 http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=3809

Hello

Go to thread, I managed to get it working. The thread will explain how to get it working.

Regards, Simon

http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=9173

Thanks Simon,

thats is what I exactly wanted.

thanks

Khuzema