>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?