From a DataSet, I have dumped everything into a view. So, I have this:

      ' Get it into a view
      Dim loView As DataView
      loView = loData.Tables("Temp").DefaultView

This view contains fields such as Speaker1, Speaker2 and Speaker3. So, for each meeting, there can be up to three speakers.

Now, I need to take that and select everything, by the use of union, into one view which will list all speakers. In VFP, I would do something like this:

SELECT Speaker1 AS Speaker From Temp WHERE SpeakerID1>0;
 UNION;
 SELECT Speaker2 AS Speaker From Temp WHERE SpeakerID2>0;
 UNION;
 SELECT Speaker3 AS Speaker From Temp WHERE SpeakerID3>0;
 INTO CURSOR Temp2

How would I go from the VB.NET code, with the view, to obtain this?