>>> For lnCounter = 0 To lnYourRecordCountOfTheDataSetHere >>> loRow = loDataProvider.oDataSet.Tables(YourAlias).Rows(lnCounter) >>> lnAmount = loRow("MaxOrdAmt") >>> Next >>>>>
>>using System; >>using System.Text; >>using System.Data; >>using System.Data.OleDb; >> >>namespace MyPlayCode >>{ >> class Program >> { >> static void Main(string[] args) >> { >> string ConnectionString = @"Provider=VFPOLEDB;Data source=C:\Program Files\Microsoft Visual FoxPro 8\Samples\Data\testdata.dbc;"; >> >> string CommandString = "SELECT * FROM customer where country = 'USA'"; >> >> OleDbDataAdapter DataAdapter = new OleDbDataAdapter(CommandString, ConnectionString); >> >> DataSet sDataSet = new DataSet(); >> >> DataAdapter.Fill(sDataSet); >> >> DataTable DTable = sDataSet.Tables[0]; >> int nMaxAmt = 0; >> >> string sDispStr = ""; >> foreach (DataRow TRow in DTable.Rows) >> { >> sDispStr += TRow[0] + ", " + TRow[1] + " – " + TRow[2] + TRow[11].ToString() + "\n"; >> Console.WriteLine(sDispStr); >> Console.ReadLine(); >> >> } >> >> } >> } >>} >>>>