C# 如何对数据绑定的 DataGridView 列进行排序？

How to sort databound DataGridView column?

提问by Pratik Deoghare

I know that there are a lot of questions on this topic. I have been through all of them but nothing seems to help.

我知道关于这个话题有很多问题。我经历了所有这些，但似乎没有任何帮助。

How to sort by clicking on column header?

如何通过单击列标题进行排序？

How should I modify this code to do the job?

我应该如何修改此代码来完成这项工作？

public partial class Form1 : Form
{

    public Form1()
    {

        List<MyClass> list = new List<MyClass>();
        list.Add(new MyClass("Peter", 1202));
        list.Add(new MyClass("James", 292));
        list.Add(new MyClass("Bond", 23));

        BindingSource bs = new BindingSource();
        bs.DataSource = list;

        DataGridView dg = new DataGridView();

        DataGridViewTextBoxColumn c = new DataGridViewTextBoxColumn();
        c.Name = "name";
        c.DataPropertyName = "Name";
        dg.Columns.Add(c);

        c = new DataGridViewTextBoxColumn();
        c.Name = "number";
        c.DataPropertyName = "Number";
        dg.Columns.Add(c);

        dg.DataSource = bs;

        this.Controls.Add((Control)dg);

    }

}

class MyClass:IComparable<MyClass>
{
    public string Name { get; set; }
    public int Number { get; set; }

    public MyClass(){}

    public MyClass(string name,int number)
    {
        Name = name;
        Number = number;
    }

    public override string ToString()
    {
        return string.Format("{0}:{1}",Name,Number);
    }

    #region IComparable<MyClass> Members

    public int CompareTo(MyClass other)
    {
        return Name.CompareTo(other.Name);
    }

    #endregion
}

采纳答案by Rhys Jones

I recall having issues finding something that would work when I added sorting to my datagrids too. You can implement a sortable bindable list by first adding the following class to your project. It is a list implementation that implements BindingList<T>, so that you can bind your datagrid to it, and it also supports sorting. A better explanation of the details than I could give is on MSDN here

我记得当我也向数据网格添加排序时，在寻找可以工作的东西时遇到了问题。您可以通过首先将以下类添加到您的项目来实现可排序的可绑定列表。它是一个实现 的列表实现BindingList<T>，因此您可以将数据网格绑定到它，并且它还支持排序。比我能给出的细节更好的解释是在MSDN here

public class SortableBindingList<T> : BindingList<T>
{
    private ArrayList sortedList;
    private ArrayList unsortedItems;
    private bool isSortedValue;

public SortableBindingList()
{
}

public SortableBindingList(IList<T> list)
{
    foreach (object o in list)
    {
        this.Add((T)o);
    }
}

protected override bool SupportsSearchingCore
{
    get
    {
        return true;
    }
}

protected override int FindCore(PropertyDescriptor prop, object key)
{
    PropertyInfo propInfo = typeof(T).GetProperty(prop.Name);
    T item;

    if (key != null)
    {
       for (int i = 0; i < Count; ++i)
        {
            item = (T)Items[i];
            if (propInfo.GetValue(item, null).Equals(key))
                return i;
        }
    }
    return -1;
}

public int Find(string property, object key)
{
    PropertyDescriptorCollection properties =
        TypeDescriptor.GetProperties(typeof(T));
    PropertyDescriptor prop = properties.Find(property, true);

    if (prop == null)
        return -1;
    else
        return FindCore(prop, key);
}

protected override bool SupportsSortingCore
{
    get { return true; }
}


protected override bool IsSortedCore
{
    get { return isSortedValue; }
}

ListSortDirection sortDirectionValue;
PropertyDescriptor sortPropertyValue;

protected override void ApplySortCore(PropertyDescriptor prop,
    ListSortDirection direction)
{
    sortedList = new ArrayList();

   Type interfaceType = prop.PropertyType.GetInterface("IComparable");

    if (interfaceType == null && prop.PropertyType.IsValueType)
    {
        Type underlyingType = Nullable.GetUnderlyingType(prop.PropertyType);

         if (underlyingType != null)
        {
            interfaceType = underlyingType.GetInterface("IComparable");
        }
    }

    if (interfaceType != null)
    {
        sortPropertyValue = prop;
        sortDirectionValue = direction;

        IEnumerable<T> query = base.Items;
        if (direction == ListSortDirection.Ascending)
        {
            query = query.OrderBy(i => prop.GetValue(i));
        }
        else
        {
            query = query.OrderByDescending(i => prop.GetValue(i));
        }
        int newIndex = 0;
        foreach (object item in query)
        {
            this.Items[newIndex] = (T)item;
            newIndex++;
        }
        isSortedValue = true;
        this.OnListChanged(new ListChangedEventArgs(ListChangedType.Reset, -1));

    }
    else
    {
        throw new NotSupportedException("Cannot sort by " + prop.Name +
            ". This" + prop.PropertyType.ToString() +
            " does not implement IComparable");
    }
}

protected override void RemoveSortCore()
{
    int position;
    object temp;

    if (unsortedItems != null)
    {
        for (int i = 0; i < unsortedItems.Count; )
        {
            position = this.Find("LastName",
                unsortedItems[i].GetType().
                GetProperty("LastName").GetValue(unsortedItems[i], null));
            if (position > 0 && position != i)
            {
                temp = this[i];
                this[i] = this[position];
                this[position] = (T)temp;
                i++;
            }
            else if (position == i)
                i++;
            else
                unsortedItems.RemoveAt(i);
        }
        isSortedValue = false;
        OnListChanged(new ListChangedEventArgs(ListChangedType.Reset, -1));
    }
}

public void RemoveSort()
{
    RemoveSortCore();
}
protected override PropertyDescriptor SortPropertyCore
{
    get { return sortPropertyValue; }
}

protected override ListSortDirection SortDirectionCore
{
    get { return sortDirectionValue; }
}

}

With that in place, the only changes you need to make to the code that you have posted above is to create a SortableBindingList based on your list and bind to the sortable list, rather than the standard one, like so:

有了这个，您需要对上面发布的代码进行的唯一更改是根据您的列表创建一个 SortableBindingList 并绑定到可排序列表，而不是标准列表，如下所示：

List<MyClass> list = new List<MyClass>();
list.Add(new MyClass("Peter", 1202));
list.Add(new MyClass("James", 292));
list.Add(new MyClass("Bond", 23));

// Added sortable list...
SortableBindingList<MyClass> sortableList = new SortableBindingList<MyClass>(list);

BindingSource bs = new BindingSource();
bs.DataSource = sortableList;   // Bind to the sortable list

And that will be enough to get you going.

这足以让你继续前进。

回答by Pratik Deoghare

Here is the blog post that really really helped me.

这是真正帮助我的博客文章。

Presenting the SortableBindableList

呈现 SortableBindableList

Also, check out How do I implement automatic sorting of DataGridView?which has examples of this and another library.

另外，请查看如何实现 DataGridView 的自动排序？其中有这个和另一个图书馆的例子。