Ejemplo n.º 1
0
        public Form1()
        {
            InitializeComponent();

            using (var xmlStream = Assembly.GetExecutingAssembly().GetManifestResourceStream("LiveLinqToDataSet.Northwind.xml"))
            {
                System.Diagnostics.Debug.Assert(xmlStream != null);
                XmlReaderSettings settings = new XmlReaderSettings {
                    IgnoreWhitespace = true
                };
                XmlReader reader = XmlReader.Create(xmlStream, settings);
                untypedDataSet.ReadXml(reader);
            }

            using (var xmlStream = Assembly.GetExecutingAssembly().GetManifestResourceStream("LiveLinqToDataSet.Northwind.xml"))
            {
                System.Diagnostics.Debug.Assert(xmlStream != null);
                XmlReaderSettings settings = new XmlReaderSettings {
                    IgnoreWhitespace = true
                };
                XmlReader reader = XmlReader.Create(xmlStream, settings);
                foreach (DataColumn col in typedDataSet.Tables["Orders"].Columns)
                {
                    col.ColumnMapping = MappingType.Attribute; // to make our XML file more compact
                }
                typedDataSet.Namespace = "";                   // need this because our XML file does not have xmlns defined
                typedDataSet.ReadXml(reader);
            }

            untypedCustomers = untypedDataSet.Tables["Customers"].AsIndexed();
            untypedOrders    = untypedDataSet.Tables["Orders"].AsIndexed();

            customers = typedDataSet.Customers.AsIndexed();
            orders    = typedDataSet.Orders.AsIndexed();
        }
Ejemplo n.º 2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            var ds = new NorthwindDataSet();

            ds.ReadXml(Server.MapPath("~/App_data/veri.xml"));

            gv.DataSource = ds;
            gv.DataMember = "Customers";
            gv.DataBind();
        }
Ejemplo n.º 3
0
        public Form1()
        {
            InitializeComponent();

            // Filling the data set with data
            string dataPath = string.Empty;

            foreach (DataColumn col in typedDataSet.Tables["Orders"].Columns)
            {
                col.ColumnMapping = MappingType.Attribute; // to make our XML file more compact
            }
            typedDataSet.Namespace = "";                   // need this because our XML file does not have xmlns defined

            using (var xmlStream = Assembly.GetExecutingAssembly().GetManifestResourceStream("LiveViewsDataSet.Northwind.xml"))
            {
                System.Diagnostics.Debug.Assert(xmlStream != null);
                XmlReaderSettings settings = new XmlReaderSettings {
                    IgnoreWhitespace = true
                };
                XmlReader reader = XmlReader.Create(xmlStream, settings);
                typedDataSet.ReadXml(reader);
            }

            // Creating indexes. It is optional, only for performance optimization.
            // If you delete this, the functionality will be the same and slowdown will be noticeable only on large data sets.
            // If you don't need to create indexes, you can use typedDataSet.Customers.AsLive() below instead of customers.AsLive(), so you don't need the
            // IndexedDataTable<> class, can proceed directly to View<NorthwindDataSet.CustomersRow>.
            IndexedDataTable <NorthwindDataSet.CustomersRow> customers = typedDataSet.Customers.AsIndexed();
            IndexedDataTable <NorthwindDataSet.OrdersRow>    orders    = typedDataSet.Orders.AsIndexed();

            customers.Indexes.Add(c => c.CustomerID, true);
            orders.Indexes.Add(o => o.CustomerID);
            orders.Indexes.Add(o => o.ShipCity);
            //...end of creating indexes

            // Make the tables live:
            customersView = typedDataSet.Customers.AsLive();
            ordersView    = typedDataSet.Orders.AsLive().AsUpdatable(); // AsUpdatable() makes it possible for
            // the user to change data directly in the grid showing the join view below.
            // Order fields can be changed by the user there, Customer fields can't be changed by the user
            // Specifying this argument is needed only if you need to change data directly in the view instead
            // of changing the base data, and then only for query operators with more than one argument such as Join.

            // Creating a live view over the base data
            IListSource view =
                (from o in ordersView
                 where o.ShipCity == "London" || o.ShipCity == "Colchester"
                 select new { OrderID = o.OrderID, CustomerID = o.CustomerID, ShipCity = o.ShipCity }).AsDynamic();

            ShowViewInGrid(view, dataGridView1);

            // Creating another live view over the base data
            customerOrderView =
                from c in customersView
                join o in ordersView on c.CustomerID equals o.CustomerID
                where o.ShipCity == "London" || o.ShipCity == "Colchester"
                // Using a user-defined class like CustomerOrder is not mandatory. Anonymous class could be used instead as in the
                // query above, but in that case we could not assign it to a variable like customerOrderView, defined outside
                // of the scope of this method, because anonymous classes are only available in local scope.
                select new CustomerOrder {
                CustomerID = c.CustomerID, City = c.City, OrderID = o.OrderID, ShipCity = o.ShipCity
            };

            ShowViewInGrid(customerOrderView, dataGridView2);

            // See the readme.txt file in the project folder for a description of the live view functionality you can try in this sample
        }