>>>- 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.
>
>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.htmlKeywords: kevin goff member id 21028
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up