Jim,
Yeah, it looks like it should work ok (my VB is not good though, I would do it in C#). Have you tried it at all?
~~Bonnie
>Some Catagory different spin on the same question.
>
>From an ActiveX object I get two text stings.
>1. Field.name
>2. Field.Text
>I need to save the Field.text into a dataset DsTasks.Tasks."FieldName"
>I would have done this as &Macro in VFP.
>mymacro = "REPLACE " + Field.Name + " with " + Field.text
>&Macro
>
>I have read Ricks article and downloaded the code and it was extremely helpful.
>
>My question is this...
>Am I missing something not being that familiar with the dataset object?
>
>Would something like this work?
>
>
Dim DTC As DataColumnCollection
>DTC = dsTasks.Tasks.Columns
>Dim DT As DataColumn
>For Each DT In DTC
> If DT.ColumnName = Field.Name Then
> ' Change the text value here
> End If
>Next
>
>thanks