No, AFAIK you can't do SELECTs and UNIONs and stuff like that with a DataSet. I'm still unclear as to what your data structure is, so maybe you can elaborate a little more.
~~Bonnie
>>OK, so if I understand you correctly, your WS is returning a new set of speakers for every call to it and you want to add those all together?
>>
>>How about using ImportRow to append to your table or your view? Something like this:
>>
>>DataRow row;
>>dsMySpeakers = oWS.MyWebServiceCall();
>>for (int i=0; i < dsMySpeakers.Tables["Speakers"].Rows.Count; i++)
>>{
>> row = dsMySpeakers.Tables["Speakers"].Rows[i];
>>
>> // If your full list of speakers is a Table
>> ds.Tables["AllSpeakers"].ImportRow(row);
>>
>> // If your full list of speakers is a View
>> dvAllSpeakers.Table.ImportRow(row);
>>}
>>>
>I'll keep this sample for further references. But, for now, in one method call, the DataSet contains, for example, 10 meetings. In each meetings, I usually have one speaker but sometimes we have three. So, 10 records but, in reality, I might have 16 speakers. So, from the DataSet, I need to be able to do another SELECT on it with a UNION approach. We do that in VFP. I guess we can do that in here as well. :)
