Datatable Merge

if the schema is the same it will work as a union , if it has a different schema then that depends on

for e.g.

            DataTable t1 = new DataTable();

            t1.Columns.Add("key1");

            t1.Columns.Add("c1");

            t1.PrimaryKey = new[] { t1.Columns["key1"] };

            t1.Rows.Add(1, "data1");

            DataTable t2 = new DataTable();

            t2.Columns.Add("key1");

            t2.Columns.Add("c2");

            t2.PrimaryKey = new[] { t2.Columns["key1"] };

            t2.Rows.Add(1, "data2");

            t1.Merge(t2, false, MissingSchemaAction.Add);

            t1.Merge(t2);

             

            will produce

         

           while 

            DataTable t3 = t1.Clone();

            t3.Rows.Add("key2", "datablah", "datablah2"); 

            t1.Merge(t3);

            

           will produce