Hi,

The following code sample is from the Book "Professional ADO.NET with VB.NET (Wrox)". I am getting the following error for the foreach loop. The error is "'System.Data.DataSet.Tables' denotes a 'property' where a 'method' was expected"

The Code is:


using System;
using System.Data;
using System.Data.SqlClient;
namespace PublicTest
{
    class myClass
    {
        [STAThread]
        static void Main(string[] args)
        {
            string strCon = "Server=LOGICON-SERVER1,1433;Database=pubs;integrated security=SSPI;persist security info=False;Connection Timeout=10000;";
            string strSQL = "Select au_fname, au_lname, phone from authors where city = 'Oakland'";

            SqlConnection myCon = new SqlConnection(strCon);
            SqlCommand myCom = new SqlCommand(strSQL, myCon);

            SqlDataAdapter da = new SqlDataAdapter(myCom);
            DataSet ds = new DataSet();
            da.Fill(ds, "authors");
            Console.WriteLine("gjjhhj", ds.Tables(0).ToString());
            foreach (DataColumn dc in ds.Tables
            {
                Console.Write("{0,15}", dc.ColumnName);
            }
            Console.ReadLine();
        }
    }
}


Please help me.


Thanks and Regards,
Ravi

Hi all,

There was a mistake in foreach loop. I am again posting my code. Pleasae help me.

==============================
using System;
using System.Data;
using System.Data.SqlClient;
namespace PublicTest
{
    /// <summary>
    /// Summary description for Class1.
    /// </summary>
    class myClass
    {

        /// <summary>
        /// The main entry point for the application.
        /// </summary>
        [STAThread]
        static void Main(string[] args)
        {
            //
            // TODO: Add code to start application here
            //
            string strCon = "Server=LOGICON-SERVER1,1433;Database=pubs;integrated security=SSPI;persist security info=False;Connection Timeout=10000;";
            string strSQL = "Select au_fname, au_lname, phone from authors where city = 'Oakland'";

            SqlConnection myCon = new SqlConnection(strCon);
            SqlCommand myCom = new SqlCommand(strSQL, myCon);

            SqlDataAdapter da = new SqlDataAdapter(myCom);
            DataSet ds = new DataSet();
            da.Fill(ds, "authors");

            foreach (DataColumn dc in ds.Tables(0).Column)
            {
                Console.Write("{0,15}", dc.ColumnName);
            }

        }
    }
}

====================

Thanks & Regards,
Ravi

Try this code

 foreach(DataTable myTable in myDataSet.Tables){
       foreach(DataColumn myColumn in myTable.Columns){
          Console.WriteLine(myColumn.ColumnName);
       }
    }


Also see this link

http://msdn.microsoft.com/library/de...nnametopic.asp