Naomi
I've faced that many times and I've always wound up looping through the rows of the first data table and adding modified rows to the new data table.

I tried LINQ several times, but the looping approach always seemed more straightforward.



>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.