Multiple DataAdapter : DataAdapter : 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.SqlClient;

public  class  MainClass  :  System.Windows.Forms.Form
{
    private  System.Windows.Forms.DataGrid  dataGrid1;
    private  System.Windows.Forms.DataGrid  dataGrid2;
    public  MainClass()
    {
        InitializeComponent();
                string  ConnectionString  ="Integrated  Security=SSPI;Initial  Catalog=Northwind;Data  Source=localhost;";
                SqlConnection  conn  =  new  SqlConnection(ConnectionString);

                conn.Open();

                DataSet  ds  =  new  DataSet("CustomersOrders");

                SqlDataAdapter  adapter1  =  new  SqlDataAdapter("SELECT  *  FROM  Orders",  conn);
                SqlDataAdapter  adapter2  =  new  SqlDataAdapter("SELECT  *  FROM  Customers",  conn);

                adapter1.Fill(ds,  "Orders");
                adapter2.Fill(ds,  "Customers");

                DataViewManager  dvm  =  new  DataViewManager(ds);

                dvm.DataViewSettings["Orders"].RowFilter  =  "EmployeeID  =  4";
                dvm.DataViewSettings["Orders"].Sort  =  "ShippedDate  ASC";

                dvm.DataViewSettings["Customers"].RowFilter  =  "ContactName  Like  'C%'";
                dvm.DataViewSettings["Customers"].Sort  =  "ContactName  ASC";

                DataView  dataView1  =  dvm.CreateDataView(ds.Tables["Orders"]);
                DataView  dataView2  =  dvm.CreateDataView(ds.Tables["Customers"]);

                dataGrid1.DataSource  =  dataView1;
                dataGrid2.DataSource  =  dataView2;        

    }

    private  void  InitializeComponent()
    {
        this.dataGrid1  =  new  System.Windows.Forms.DataGrid();
        this.dataGrid2  =  new  System.Windows.Forms.DataGrid();
        ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
        ((System.ComponentModel.ISupportInitialize)(this.dataGrid2)).BeginInit();
        this.SuspendLayout();
        //  
        this.dataGrid1.DataMember  =  "";
        this.dataGrid1.HeaderForeColor  =  System.Drawing.SystemColors.ControlText;
        this.dataGrid1.Location  =  new  System.Drawing.Point(0,  8);
        this.dataGrid1.Size  =  new  System.Drawing.Size(256,  264);
        //  
        this.dataGrid2.DataMember  =  "";
        this.dataGrid2.HeaderForeColor  =  System.Drawing.SystemColors.ControlText;
        this.dataGrid2.Location  =  new  System.Drawing.Point(272,  8);
        this.dataGrid2.Size  =  new  System.Drawing.Size(256,  264);
        //  
        this.AutoScaleBaseSize  =  new  System.Drawing.Size(5,  13);
        this.ClientSize  =  new  System.Drawing.Size(536,  273);
        this.Controls.AddRange(new  System.Windows.Forms.Control[]  {
                                                                        this.dataGrid2,
                                                                        this.dataGrid1});
        ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
        ((System.ComponentModel.ISupportInitialize)(this.dataGrid2)).EndInit();
        this.ResumeLayout(false);

    }

    [STAThread]
    static  void  Main()  
    {
        Application.Run(new  MainClass());
    }

}