C#

foreach (DataRow r in ds.Tables["TableName"].Rows)
            {
                String surname = r.ItemArray[2].ToString();
            }

foreach(MyTableRow row in MyTable.Rows)
    string surname = row.SurName;

peropata wrote:

I would also like to be able to open any number of ChildForms and change properties for each individual ChildForm object (so each could display graph with different settings ) ...

peropata wrote:

Now I want to add a setup form (shown when pressing button on ChildForm), from which I could change properties of my myGrid object from myGraphGridClass.

SetupForm sf = new SetupForm(this.myGraph)

SetupForm sf = new SetupForm(this.myGraph)

class MyGraphGridClass
    {
        private int myProperty;

        public int Property
        {
            get { return myProperty; }
            set { myProperty = value; }
        }

        .
        .
        .

    }

    class MyDivisionClass
    {
        private MyGraphGridClass objMyGraphGrid = new MyGraphGridClass();

        internal MyGraphGridClass MyGraphGrid
        {
            get { return objMyGraphGrid; }
            set { objMyGraphGrid = value; }
        }

        .
        .
        .

    }

// In chid form class 

       MyDivisionClass Graph_01 = new MyDivisionClass();
       MyDivisionClass Graph_02 = new MyDivisionClass();

       Graph_01.MyGraphGrid.Property = 5;
       Graph_02.MyGraphGrid.Property = 3;
       
       // and then use as suggested
       SetupForm sf = new SetupForm(Graph_01.MyGraphGrid);

//the method that gets the data connecxtion string
public static string GetConnection(){
 try{
    System.Xml.Linq.XDocument doc = System.Xml.Linq.XDocument.Load("confix.xml");
    return doc.Element("Connection").Value;
 }
 catch{
   return "failure";
 } 
}

//and the xml file
<?xml version="1.0" encoding="utf-8" ?>
<Connection>"MyConnectionWithoutPassHere"</Connection>

public SortedList<Animal, Zoo> map = new SortedList<Animal, Zoo>();
...
...
...
//and linq
zoo.animals = (from animal in animalList   
            where map[animal].Id == zoo.Id
            select animal).ToList();
}

public SortedList<int, int> map = new SortedList<int, int>();
...
...
...
//fill the sortedList from the DReader
//and linq
zoo.animals = (from animal in animalList   
            where map[animal.Id] == zoo.Id
            select animal).ToList();

class Animal{
   public int Id{get;set;}
   public string Name{get;set;}
}

class Zoo{
   public int Id{get;set;}
   public string Name{get;set;}
}

//and a sortedList or a class that represnts the AnimalZoo jonction table, but why bother to implement
//IComparable, IEqutable ... when you already have it.
SortedList<int,int> animalZooJonction = new SortedList<int, int>();
//the animalI.Id is key and zoo.Id is value

//Now when he wants to get the animals for a given zoo:

var animalsInSpecifiedZoo = (from rec in animals
                             where animalZooJonction[rec.Id] == zoo//zoo specified as a param
                             select rec).ToList();