>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(); > > } > > } > } >} >>