>
>I tried things like DS.id and ds.id(1) and all I get are errors saying "member not found". I also tried x = xmltocursor(ds). VFP was not happy.


ADO is a colleciton of objects. DataSet contains tables which contains columns and rows:

MyDataSet.Tables[0] is the first table;
MyDataSet.Tables[0].Columns[0] .. [end] shows the defined columns.
MyDataSet.Tables[0].Rows[0] .. [end] shows the defined rows.

So you can get the field values for your data by saying: mydataSet.Tables[0].Rows["mycolumn"] (which is an object that has to be converted to display the correct type):

string - mydataSet.Tables[0].Rows["mycolumn"].ToString()
int - Convert.ToInt32(mydataSet.Tables[0].Rows["mycolumn"])

etc. Hope this helps.