Merge two DataSet : DataSet : ADO.Net C# Examples

    
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());
    }
}