mercoledì 30 maggio 2012

MS: 70-516 Samples of chapter 1 Lesson 1 part 3

Questo l'ultima sub legata alla lezione 


static void Sample_17()
        { 
            /* MERGE data ... */
            DataSet ds = new DataSet("Colleghi");

            DataTable dCollega = ds.Tables.Add("Collega");
            dCollega.Columns.Add("IDCollega", typeof(int));
            dCollega.Columns.Add("Cognome", typeof(string));
            dCollega.Columns.Add("Nome", typeof(string));
            dCollega.PrimaryKey = new DataColumn[] { dCollega.Columns["IDCollega"] };
            dCollega.Rows.Add("1", "Arosio", "Fabio");
            dCollega.Rows.Add("2", "Eridani", "Caludio");

            DataSet dsTmp = ds.Copy();

            DataTable dCollega1 = dsTmp.Tables["Collega"];
            dCollega1.Rows.Add("3", "Arosio_A", "Fabio_B");
            dCollega1.Rows.Add("4", "Eridani_A", "Caludio_B");


            ds.Merge(dsTmp, false, MissingSchemaAction.AddWithKey);

            for (int i = 0; i < dCollega.Rows.Count; i++)
            {
                Console.WriteLine(dCollega.Rows[i][0].ToString() + " " + dCollega.Rows[i][1].ToString());
            }
        }

Nessun commento: