1:
2:
3:
4:
5:
6:
7:
8:

for (int i = 0; i != j; i++)
            {
                string Name = Convert.ToString(dataGridView1[0, i].Value);
                if ((Name != "") && (Name != @"W/R/St.") && (Name != "Kategorie"))
                {
                    RoboterManager Roboter = new RoboterManager(i,dataGridView1);
                }
            }					

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:

public class RoboterManager 
    {
        public RoboterManager(int i,DataGridView dataGridView1)
        {
            bool vorhanden = false;
            //Code der überprüft ob Roboter mit diesem Namen bereits vorhanden
            if (vorhanden == false)
            {
            Roboter Rob = new Roboter();
            //Rob.IDRoboter = ID des vorherigen Robs+1;
            //Rob.PositionRoboter = Pos letzter Rob+1;
            }
            //Anlegen eines neuen Vorgangs
            Vorgang Vor = new Vorgang();
            Vor.NameVorgang = Convert.ToString(dataGridView1[1, i].Value);
            Vor.Description = Convert.ToString(dataGridView1[2, i].Value);
            Vor.Bemerkung = Convert.ToString(dataGridView1[3, i].Value);
            string test = Convert.ToString(dataGridView1[6, i].Value);
            if (test == "")
                Vor.StartPlan = 0.0;
            else
                Vor.StartPlan = Convert.ToDouble(dataGridView1[6, i].Value);
            test = Convert.ToString(dataGridView1[8, i].Value);
            if (test == "")
                Vor.EndePlan = 0.0;
            else
                Vor.EndePlan = Convert.ToDouble(dataGridView1[8, i].Value);
            test = Convert.ToString(dataGridView1[7, i].Value);
            if (test == "")
                Vor.LaengePlan = 0.0;
            else
                Vor.LaengePlan = Convert.ToDouble(dataGridView1[7, i].Value);
            test = Convert.ToString(dataGridView1[4, i].Value);
            if (test == "")
                Vor.SchaltdauerVorPlan = 0.0;
            else
                Vor.SchaltdauerVorPlan = Convert.ToDouble(dataGridView1[4, i].Value);
            test = Convert.ToString(dataGridView1[5, i].Value);
            if (test == "")
                Vor.SchaltdauerRueckPlan = 0.0;
            else
                Vor.SchaltdauerRueckPlan = Convert.ToDouble(dataGridView1[5, i].Value);
      }
}					

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:

    public class Roboter
    {
        public string NameRoboter { get; set; }
        public string VorgaengerRoboter { get; set; }
        public int PositionRoboter { get; set; }
        public int IdRoboter { get; set; }
    }
    public class Vorgang
    {
        public string NameVorgang { get; set; } //im BFW Beschreibung genannt
        public string Description { get; set; }
        public string Bemerkung { get; set; }
        public double StartPlan { get; set; }
        public double EndePlan { get; set; }
        public double LaengePlan { get; set; }
        public double SchaltdauerVorPlan { get; set; }
        public double SchaltdauerRueckPlan { get; set; }
        public double StartProz { get; set; }
        public double EndeProz { get; set; }
        public double LaengeProz { get; set; }
        public double SchaltdauerVorProz { get; set; }
        public double SchaltdauerRueckProz { get; set; }
        public string VorgaengerVorgang { get; set; }
        public string VorgaengerRoboter { get; set; }
        public int PositionVorgang { get; set; }
        public int IdVorgang { get; set; }
    }					

1:
2:
3:
4:
5:
6:
7:

            List<Roboter> robotics = new List<Robotoer>();
            DataGridViewRoboterFactory robotFactory = new DataGridViewRoboterFactory();

            foreach (DataGridViewRow row in dataGridView1.Rows)
            {
                robotics .Add(robotFactory.CreateRobot(row));
            }					

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:

class DataGridViewRobotoerFactory : IRobotFactory
{
    public Robot CreateRobot(DataGridViewRow row)
    {
       return new Robot{ 
           NameVorgang = row.Cells["NameVorgang"].Value,
           Description = row.Cells["Description"].Value,
           Bemerkung = row.Cells["Bemerkung "].Value,
           ...
           };
    }
}					

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:

                    dataGridView1.Visible = true;   //dataGridView einblenden
                    System.Data.OleDb.OleDbConnection MyConnection;
                    System.Data.DataSet DtSet;
                    System.Data.OleDb.OleDbDataAdapter MyCommand;
                    MyConnection = new System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + fullPathname + "';Extended Properties=Excel 8.0;");
                    
                    MyCommand = new System.Data.OleDb.OleDbDataAdapter("select * from [Funktionsdiagramm$A:Y]", MyConnection);
                    MyCommand.TableMappings.Add("Table", "TestTable");
                    DtSet = new System.Data.DataSet();
                    MyCommand.Fill(DtSet);
                    dataGridView1.DataSource = DtSet.Tables[0];
                    MyConnection.Close();					

1:

if (column[j].Value == NameRoboter)					

1:

public DataColumn column;					

1:
2:
3:

myTable.Rows[7][2] = "Robot1";
// oder auch:
myTable.Rows[7]["Spaltenname"] = "Robot1";					

1:

if ( (string)myTable.Rows[7]["Spaltenname"] == myRobotName )