>Hi friend :
> I have the following code in Foxpro and now, could you please show me how to convert it to .NET language ?
>
>create cursor v_templetA( date d, product_code c(15),product_name c(50))
>create cursor v_templetB( date d, product_code c(15),product_name c(50),grpcode c(15),grpname c(50))
>
>select v_templetA
>append from dbf('v_templetB')
>
>thank you very much.
Is there a reason you don't want to do this as a stored procedure and just call the stored procedure from .NET? That's what I would do. If these are views that you only create on the fly, you would probably want to look at table variables and/or common table expressions. If you are using existing views, that would simplify things.