Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Multiple DataAdapter

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