Mega Code Archive

 

Categories / C# by API / System Data

 

DataViewManager CreateDataView

using System;         using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data; using System.Data.OleDb; using System.Data.SqlClient; public class DataViewManagerDemo : System.Windows.Forms.Form {   private System.Windows.Forms.DataGrid dataGrid1;   public DataViewManagerDemo()   {     InitializeComponent();   }   private void InitializeComponent()   {     this.dataGrid1 = new System.Windows.Forms.DataGrid();     ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();     this.SuspendLayout();     //      this.dataGrid1.DataMember = "";     this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;     this.dataGrid1.Location = new System.Drawing.Point(8, 8);     this.dataGrid1.Size = new System.Drawing.Size(448, 328);     //      this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);     this.ClientSize = new System.Drawing.Size(480, 341);     this.Controls.AddRange(new System.Windows.Forms.Control[] {                                     this.dataGrid1});     this.Load += new System.EventHandler(this.DataViewManagerDemo_Load);     ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();     this.ResumeLayout(false);   }   [STAThread]   static void Main()    {     Application.Run(new DataViewManagerDemo());   }   private void DataViewManagerDemo_Load(object sender, System.EventArgs e)     {         string ConnectionString ="Integrated Security=SSPI;Initial Catalog=Northwind;Data Source=localhost;";         SqlConnection conn = new SqlConnection(ConnectionString);         conn.Open();         DataSet ds = new DataSet("Orders");         SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM Orders", conn);         adapter.Fill(ds, "Orders");         DataViewManager dvm = new DataViewManager(ds);         dvm.DataViewSettings["Orders"].RowFilter = "EmployeeID = 4";         dvm.DataViewSettings["Orders"].Sort = "ShippedDate ASC";         DataView dataView1 = dvm.CreateDataView(ds.Tables["Orders"]);         dataGrid1.DataSource = dataView1;     } }