May I have calculate field in typedlists

select code,qty,cost,qty*cost as netamount from parts

That is not possible, you might consider using a creating a view in the database itself and using that, however views can't be used in typed lists.

nopchan wrote:

May I have calculate field in typedlists

select code,qty,cost,qty*cost as netamount from parts

You should be able to add an expression to a dynamic list that will give you the desired results.

Take a look at this page in the LLBLGen User Manual:

Generated code - Field expressions and aggregates

Actually, you can, with a workaround: derive a class from your typedlist class and override the routine which builds the resultset (this depends on what you're using: adapter or selfservicing), then add the expression object as Paul suggested, to the field.