>>>- If you can apply SQL commands to a DataTable, then for each column in each DataTable you might be able to build an UPDATE statement. Fox pseudocode:
>>>

>>>UPDATE SomeDataTable SET ;
>>>  SomeColumn = SomeDefaultValue ;
>>>  WHERE ISNULL( SomeColumn )
>>>

>>
>>Is there a way to apply some SQL command on the dataset? I do not want to change the existing data itself.
>
>Hmm, I did a quick Google and couldn't find any references for how to do this. Maybe KG or BB can jump in and let us know.


Nope, AFAIK, there's no way to do an Update on a DataTable. I don't think they've put that capability in LINQ either.

Looks like Michel is stuck using Rick's and Thomas' suggestions for optimizing his loops.

~~Bonnie


>
>I did run into a link that might speed things up a bit if you still have to loop: http://www.knowdotnet.com/articles/adoenums.html