Asp – Sorting by multiple fields using DisplayColumnAttribute in Asp.Net Dynamic Data App

asp.netdynamic-data

I've got a dynamic data app, and I want to sort based on multiple fields like so..

<DisplayColumn("FieldName", "Field1, Field2")> _

DisplayColumn doesn't seem to support more than one field?

Best Answer

The DisplayColumn attribute's SortColumn param specifies the column that will be used to sort this entity when it is used as a foreign key (ex: in a DropDownList), not when it is being sorted in the GridView (or being sorted in the DB).

see SO here as well: ASP.NET Dynamic Data DisplayColumn Attribute Causing Sorting Issue

msdn: http://msdn.microsoft.com/en-us/library/system.componentmodel.dataannotations.displaycolumnattribute.aspx

If this is still what you are looking for (sorting in DropDownLists only, not the DB) you can sort on multiple columns by creating a custom property in the entity that combines those two columns.

example:

[DisplayColumn("FieldName", "SortColumn")]
public partial class Employee
{
    public string SortColumn
    {
        get { return Field1 + Field2; }
    }
}

Related Solutions

Asp – Using ASP.NET Dynamic Data / LINQ to SQL, how do you have two table fields have a relationship to the same foreign key

The solution is to delete and re-add BOTH tables to the LINQ to SQL diagram, not just the one you have added the second field and keys to.

Alternatively, it appears you can make two associations using the LINQ to SQL interface - just don't try and bundle them into a single association.

Asp – Use a Computed Property as DisplayColumn in ASP.Net Dynamic Data

I'm not sure if you are binding to a DataTable/DataSet returned from the database, or if you are binding to a Release object itself. Nor which kind of control.

If you are binding to a DataSet/DataTable, simply change your SQL to return the version as one field:

SELECT table1.Major + '.' + table1.Minor + '.' + table1.Build AS Version ....

However, if you are binding to an object to, say, a DropDownList, I think that if you override the ToString method, it will become the Display value in the DropDownList:

Public Overrides Function ToString() As String
    Return _major.ToString & '.' & _minor.ToString & '.' & _build.ToString
End Sub

Best Answer

Related Solutions

Asp – Using ASP.NET Dynamic Data / LINQ to SQL, how do you have two table fields have a relationship to the same foreign key

Asp – Use a Computed Property as DisplayColumn in ASP.Net Dynamic Data

Related Topic