Thank you for your recent inquiry regarding binding Intersoft ClientUI controls to IEnumerable object.

I created a simple sample of UXGridView bind to collection of customers based on your description. The Customers’s data is obtained from Customers table of Northwind.mdb (MS Access database).

The project is enclosed as attachment. Please have the project tested on your end and let us hear your feedback whether this helps or not.

PS: before run/build the sample project, please open CustsViewModel.cs file and set the OleDbConnection to the correct path

Yudi,

I have your cust example working just fine.  Yes, Intersoft controls work great with ObservableCollection.  That is NOT the problem.

I have a DataView object, which is also IEnumerable and works fine with other control bindings, just not intersoft.  WHY WHY WHY??  According to the documentation, if its IEnumerable, it should work, BUT it does NOT work. WHY?

I am using an Access Db as local db.  I am using Visual Studio Data Source Designer to bring in all the data model and hibernate all the needed interface.  Why would I want to manually create all my data models using ModelBase.cs and create all new ViewModel functions using ObservableCollection??? 

This would take a lot of time and effort. Yes!!!

The problem remains, Intersoft does NOT bind to DataView or CollectionViewSource objects.  Most everything on the PLANT EARTH DOES.

Yes I know this must be a bug.  If you simply acknowlegde this as a bug and let me know of any workarounds and tell me you all are working on a solution and it will be out in some hotfix or release, you will make me happier.

I apologize for any inconvenience this problem may have caused you.

I modified the CustsViewModel ViewModel class by adding a property called DataTableWithData which is DataView type.

namespace BindAccess.ViewModels
{
    public class CustsViewModel : ViewModelBase
    {
        private DataTable _dataTableWithData;
        public DataView DataTableWithData
        {
            get
            {
                if (_dataTableWithData == null)
                    LoadData();
                return _dataTableWithData.DefaultView;
            }
        }
        public IEnumerable ItemsSource
        {
            get { return new PagedCollectionView(DataTableWithData); }
        }
        private void LoadData()
        {
            _dataTableWithData = new DataTable();
            _dataTableWithData.Columns.Add("ID");
            _dataTableWithData.Columns.Add("Name");
            _dataTableWithData.Columns.Add("Age");
            for (int i = 0; i < 10; i++)
            {
                _dataTableWithData.Rows.Add(i.ToString(), "Name" + i.ToString(), i);
            }
        }
    }
}

Exception happen when I tried to bind the ItemsSource property from CustsViewModel to ItemsSource property of UXGridView. I was able to bind the DataView to other controls such as UXListBox; UXComboBox; or UXPageableComboBox.

Currently, our team is investigating this issue. Should I heard any news regarding this, I will let you know.

Thank you so much Hans for looking into this!!!  Yes, I was going to UXGridView with no success.  Good to know that other controls are working!  I will try this out.  Let me know of a solution to UXGridView if you find one.  Again, many thanks!

I found that when AutoGenerateColumns is disabled (AutoGenerateColumns=”False”) and UXGridView columns are defined, I can successfully display the items. I will keep you updated with anything I found.

Edited on: January 2, 2012 03:03 AM
Reason: Update information

You need to specify each column of UXGridView if bind the ItemsSource property to DataView object. For example:

ViewModel

using System.Collections;
using System.Data;
using Intersoft.Client.Data.ComponentModel;
namespace BindAccess.ViewModels
{
    public class CustsViewModel : ViewModelBase
    {
        private DataTable _dataTableWithData;
        public DataView DataTableWithData
        {
            get
            {
                if (_dataTableWithData == null)
                    LoadData();
                return _dataTableWithData.DefaultView;
            }
        }
        public IEnumerable ItemsSource
        {
            get { return new PagedCollectionView(DataTableWithData); }
        }
        private void LoadData()
        {
            _dataTableWithData = new DataTable();
            _dataTableWithData.Columns.Add("ID");
            _dataTableWithData.Columns.Add("Name");
            _dataTableWithData.Columns.Add("Age");
            for (int i = 0; i < 10; i++)
            {
                _dataTableWithData.Rows.Add(i.ToString(), "Name" + i.ToString(), i);
            }
        }
    }
}

View

<Intersoft:UXPage.DataContext>
    <ViewModels:CustsViewModel />
</Intersoft:UXPage.DataContext>
<Grid x:Name="LayoutRoot">
    <Intersoft:UXGridView ItemsSource="{Binding ItemsSource}" AutoGenerateColumns="False">
        <Intersoft:UXGridView.Columns>
            <Intersoft:UXGridViewTextColumn Header="ID" Binding="{Binding ID}"/>
            <Intersoft:UXGridViewTextColumn Header="Name" Binding="{Binding Name}"/>
            <Intersoft:UXGridViewTextColumn Header="Age" Binding="{Binding Age}"/>
        </Intersoft:UXGridView.Columns>
    </Intersoft:UXGridView>
</Grid>

If you need UXGridView to automatically generate its columns (by enabling the AutoGenerateColumns property), it is suggested to use the WCF RIA service or DevForce.

Hope this helps.