dsCustomers.Customers.Rows[0].cCustName.ToString();A typed DataSet allows Intellisense to kick in for both your table names and your column names, which you don't get with just a regular DataSet. Also notice that I used a Rows[0], rather than [1]. Don't forget that the Rows collection is zero-based.
>DataRow myRow ; >myRow = dsCustomers.Tables["Customers"].Rows[1] ; >Console.WriteLine( myRow["cCustName"].ToString() ); >>This works but it has a couple of problems:
dsCustomers.Tables["Customers"].Rows[1].[] ..?>
>>foreach(DataTable tabla in dsCustomers.Tables) >> foreach(DataRow rowCustomer in tabla.Rows ) >> { >> Console.WriteLine(rowCustomer["cCustName"]); >> } >>>>What if I want to just retrieve the value of a field from the current row?
>> MyDataSet.Tables["CUSTOMERS"].Columns["cCustName"] >>>>But that gives me the name of the column, I suppose it's like calling ToString for the Column object. So I looked for a Column property similar to ADO's Value property, and I couldn't find one listed in DataColumn members, strange that you can get all sorts of info about the column except for the actual value.
>> MyRecordSet.Fields("cCustName").Value
>>