Merge two DataSet : DataSet « ADO.Net « C# / CSharp Tutorial

1. C# / CSharp Tutorial
2. ADO.Net
3. DataSet

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.OleDb;

public class MainClass {
  public static void Main(){
    OleDbConnection conn = new OleDbConnection();
    string strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Northwind.mdb";
    conn.ConnectionString = strDSN;
    conn.Open();

    string sql = "SELECT * FROM orders ";
    OleDbDataAdapter da = new OleDbDataAdapter(sql, conn);
    DataSet ds1 = new DataSet("ds1");
    da.Fill(ds1);

    sql = "SELECT * FROM Customers ";
    da = new OleDbDataAdapter(sql, conn);
    DataSet ds2 = new DataSet("ds2");
    da.Fill(ds2);

    ds1.MergeFailed += new MergeFailedEventHandler(OnMergeFailed);

    ds1.Merge(ds2);
  }

  protected static void OnMergeFailed  (object sender, MergeFailedEventArgs args)
  {
    MessageBox.Show(args.Conflict.ToString());
  }
}