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

LINQ has a foreach capability built in..