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:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:

namespace H20_List
{
    public partial class GrdStart : Form
    {
        public GrdStart()
        {
            InitializeComponent();
        }

        string Project1;

        private void GrdStart_Load(object sender, EventArgs e)
        {
            OleDbDataAdapter da;
            OleDbConnection cnn;
            //----------------------------------------------------------------------------------------
            cnn = new OleDbConnection();
            OleDbConnectionStringBuilder csb = new OleDbConnectionStringBuilder();
            csb.Provider = "Microsoft.Jet.OLEDB.4.0";
            csb.DataSource = @"C:\H20\db1.mdb";
            cnn.ConnectionString = csb.ConnectionString;

            OleDbCommand cmd = new OleDbCommand();
            cmd.Connection = cnn;
            cmd.CommandText = "Delete * FROM DT_H20";

            da = new OleDbDataAdapter();
            da.SelectCommand = cmd;
            da.Fill(ds, "Loeschen");
            //----------------------------------------------------------------------------------------
            cmd.Connection = cnn;
            cmd.CommandText = "Select * FROM AB_H20_ALL";

            da = new OleDbDataAdapter();
            da.SelectCommand = cmd;
            da.Fill(ds, "Quelle");

            //----------------------------------------------------------------------------------------
            cmd.Connection = cnn;
            cmd.CommandText = "Select * FROM DT_H20";

            da = new OleDbDataAdapter();
            da.SelectCommand = cmd;

            OleDbCommandBuilder cmb = new OleDbCommandBuilder(da);
            da.UpdateCommand = cmb.GetUpdateCommand();
            da.InsertCommand = cmb.GetInsertCommand();

            da.Fill(ds, "Ziel_1");

            foreach (DataRow row in ds.Tables["Quelle"].Rows)
            {
                if (row["BOM1"].ToString() == "1........")
                {
                    if (row["Project"].ToString() == "")
                        Project1 = "-";
                    else
                        Project1 = row["Project"].ToString();
                }

                string BOM = row["BOM1"].ToString();
                string Material = row["Material1"].ToString();
                string Description = row["Description1"].ToString();

                ds.Tables["Ziel_1"].Rows.Add(ds.Tables["Ziel_1"].NewRow());               

                foreach (DataRow row1 in ds.Tables["Ziel_1"].Rows)
                {
                    row1["BOM1"] = BOM;
                    row1["Material1"] = Material;
                    row1["Description1"] = Description;
                    row1["Project1"] = Project1;
                    break;
                }
            }
            da.Update(ds, "Ziel_1");
        }
    }