Naomi,

you already have some answers on how to do it client side in dotnet. But as you probably have some SQL code doing it, why not keep munging in SQL and do the stuff server side ? IMO Dotnet munging sucks...

>Hi everybody,
>
>In VFP I have code that first gets data from SQL Server into a cursor and then does extra select from that cursor into another cursor applying some extra formatting.
>
>I am wondering what is the best way to simulate this in C#? I understand I can get dataset (or reader) and loop through every row and generate a new dataset.
>
>Is there another way using LINQ, for example? If yes, can you show a sample, please?
>
>Thanks in advance.