Use [] instead of () in c#.


>>>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?
>
>TRow("CustName") gives an error, "TRow is a 'variable' but is used like a 'method'."