>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.
oEmployee = CLRCreateObject("PenSoftx.Employee",1) ds = oEmployee.GetEmployees oTable = ds.Tables.item(0) For nRow = 0 to oTable.Rows.Count -1 ? oRow = ds.Tables.item(0).Rows.Item(nRow) FOR nCol = 0 to oTable.Columns.Count -1 eData = oRow.Item(nCol) && Data in each column in a Row (record) ?? eData ?? ', ' ENDFOR ENDFOR