>>I'm playing with the following piece of code.
>>
>>

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

>>
>>I think I setup the DataAdpater correctly. But I want to access my field by field name like TRow("custname") or TRow("MaxOrdAmt") like you.
>>
>>How do I get there from this code? Am I close?
>
>I believe you only have to change to TRow("CustName"). In VB.NET, you also have to use parentheses. Is it working up until the foreach loop?

Yes... at least I don't get any errors.