Hi I am using LLBLGEN PRO 1.0 with VB.NET and database as SQL server. I want to know how to specify and execute a database view at runtime. Similerly i should able to specify the table name and columns at runtime.

Apparently you would need Dynamic Lists. Please read the LLBLGen Pro v1.0.x Documentation at sections: Generated code - Adapter - Using views and lists - Usings dynamic lists (for Adapter) and Generated code - SelfServicing - Using views and lists - Usings dynamic lists (for SelfServicing)

Good luck!

Please elaborate more.

And specify which LLBLGen Pro runtimeLibrary you are using. Guidelines: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=7722

Also post the database view SQL code.

LLBLGEN PRO Version 1.0.2005.1 Database Sql server 2000 Runtime version v1.1.4322

I have a list of views in the database. I want to specify(From frontend) the name of the view and the conditions only at runtime.

For example the view: Customer_Details_VW has the SQL

SELECT CUSTOMERCODE,CUSTOMERNAME,ADDRESS FROM TBL_CUSTOMER_DETAILS

For this view i will specify the name (Customer_Details_VW ) at runtime.So the code has to be in such a way that it should take the view name at runtime and execute.

A similar issue was discussed here: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=4594