BindingSource.Sort BindingSource.Sort BindingSource.Sort BindingSource.Sort Property

Definición

Obtiene o establece los nombres de columna utilizados para ordenar y el criterio de ordenación para ver las filas del origen de datos.Gets or sets the column names used for sorting, and the sort order for viewing the rows in the data source.

public:
 property System::String ^ Sort { System::String ^ get(); void set(System::String ^ value); };
public string Sort { get; set; }
member this.Sort : string with get, set
Public Property Sort As String

Valor de propiedad

Cadena con distinción entre mayúsculas y minúsculas que contiene el nombre de columna seguido de "ASC" (para el orden ascendente) o "DESC" (para el orden descendente).A case-sensitive string containing the column name followed by "ASC" (for ascending) or "DESC" (for descending). De manera predeterminada, es null.The default is null.

Ejemplos

En el ejemplo siguiente se muestra cómo utilizar Sort la propiedad para realizar una DataViewordenación básica con.The following example shows how to use the Sort property to perform basic sorting with a DataView. Para ejecutar este ejemplo, pegue el código en un Windows Form y llame PopulateDataViewAndSort a desde el constructor del formulario Load o el método de control de eventos.To run this example, paste the code into a Windows Form and call PopulateDataViewAndSort from the form's constructor or Load event-handling method. El formulario debe importar los System.Xml espacios System.IO de nombres y.Your form should import the System.Xml and System.IO namespaces.

private void PopulateDataViewAndSort()
{
    DataSet set1 = new DataSet();

    // Some xml data to populate the DataSet with.
    string musicXml =
        "<?xml version='1.0' encoding='UTF-8'?>" +
        "<music>" +
        "<recording><artist>Coldplay</artist><cd>X&amp;Y</cd></recording>" +
        "<recording><artist>Dave Matthews</artist><cd>Under the Table and Dreaming</cd></recording>" +
        "<recording><artist>Dave Matthews</artist><cd>Live at Red Rocks</cd></recording>" +
        "<recording><artist>Natalie Merchant</artist><cd>Tigerlily</cd></recording>" +
        "<recording><artist>U2</artist><cd>How to Dismantle an Atomic Bomb</cd></recording>" +
        "</music>";

    // Read the xml.
    StringReader reader = new StringReader(musicXml);
    set1.ReadXml(reader);

    // Get a DataView of the table contained in the dataset.
    DataTableCollection tables = set1.Tables;
    DataView view1 = new DataView(tables[0]);

    // Create a DataGridView control and add it to the form.
    DataGridView datagridview1 = new DataGridView();
    datagridview1.AutoGenerateColumns = true;
    this.Controls.Add(datagridview1);

    // Create a BindingSource and set its DataSource property to
    // the DataView.
    BindingSource source1 = new BindingSource();
    source1.DataSource = view1;

    // Set the data source for the DataGridView.
    datagridview1.DataSource = source1;

    source1.Sort = "cd";
}
Private Sub PopulateDataViewAndSort() 
    Dim set1 As New DataSet()
    
    ' Some xml data to populate the DataSet with.
    Dim musicXml As String = "<?xml version='1.0' encoding='UTF-8'?>" & _
        "<music>" & _
        "<recording><artist>Coldplay</artist><cd>X&amp;Y</cd></recording>" & _
        "<recording><artist>Dave Matthews</artist><cd>Under the Table and Dreaming</cd></recording>" & _
        "<recording><artist>Dave Matthews</artist><cd>Live at Red Rocks</cd></recording>" & _
        "<recording><artist>Natalie Merchant</artist><cd>Tigerlily</cd></recording>" & _
        "<recording><artist>U2</artist><cd>How to Dismantle an Atomic Bomb</cd></recording>" & _
         "</music>"
    
    ' Read the xml.
    Dim reader As New StringReader(musicXml)
    set1.ReadXml(reader)
    
    ' Get a DataView of the table contained in the dataset.
    Dim tables As DataTableCollection = set1.Tables
    Dim view1 As New DataView(tables(0))
    
    ' Create a DataGridView control and add it to the form.
    Dim datagridview1 As New DataGridView()
    datagridview1.AutoGenerateColumns = True
    Me.Controls.Add(datagridview1)
    
    ' Create a BindingSource and set its DataSource property to
    ' the DataView.
    Dim source1 As New BindingSource()
    source1.DataSource = view1
    
    ' Set the data source for the DataGridView.
    datagridview1.DataSource = source1
    
    source1.Sort = "cd"

End Sub

En el ejemplo siguiente se muestra cómo utilizar Sort la propiedad para realizar una ordenación avanzada DataViewcon un.The following example shows how to use the Sort property to perform advanced sorting with a DataView. Para ejecutar este ejemplo, pegue el código en un Windows Form y llame PopulateDataViewAndAdvancedSort a desde el constructor del formulario Load o el método de control de eventos.To run this example, paste the code into a Windows Form and call PopulateDataViewAndAdvancedSort from the form's constructor or Load event-handling method. El formulario debe importar los System.Xml espacios System.IO de nombres y.Your form should import the System.Xml and System.IO namespaces.

private void PopulateDataViewAndAdvancedSort()
{
    DataSet set1 = new DataSet();

    // Some xml data to populate the DataSet with.
    string musicXml =
        "<?xml version='1.0' encoding='UTF-8'?>" +
        "<music>" +
        "<recording><artist>Dave Matthews</artist><cd>Under the Table and Dreaming</cd></recording>" +
        "<recording><artist>Coldplay</artist><cd>X&amp;Y</cd></recording>" +
        "<recording><artist>Dave Matthews</artist><cd>Live at Red Rocks</cd></recording>" +
        "<recording><artist>U2</artist><cd>Joshua Tree</cd></recording>" +
        "<recording><artist>U2</artist><cd>How to Dismantle an Atomic Bomb</cd></recording>" +
        "<recording><artist>Natalie Merchant</artist><cd>Tigerlily</cd></recording>" +
        "</music>";

    // Read the xml.
    StringReader reader = new StringReader(musicXml);
    set1.ReadXml(reader);

    // Get a DataView of the table contained in the dataset.
    DataTableCollection tables = set1.Tables;
    DataView view1 = new DataView(tables[0]);

    // Create a DataGridView control and add it to the form.
    DataGridView datagridview1 = new DataGridView();
    datagridview1.AutoGenerateColumns = true;
    this.Controls.Add(datagridview1);

    // Create a BindingSource and set its DataSource property to
    // the DataView.
    BindingSource source1 = new BindingSource();
    source1.DataSource = view1;

    // Set the data source for the DataGridView.
    datagridview1.DataSource = source1;

    source1.Sort = "artist ASC, cd ASC";
}
Private Sub PopulateDataViewAndAdvancedSort() 
    Dim set1 As New DataSet()
    
    ' Some xml data to populate the DataSet with.
    Dim musicXml As String = "<?xml version='1.0' encoding='UTF-8'?>" & _
        "<music>" & _
        "<recording><artist>Dave Matthews</artist><cd>Under the Table and Dreaming</cd></recording>" & _
        "<recording><artist>Coldplay</artist><cd>X&amp;Y</cd></recording>" & _
        "<recording><artist>Dave Matthews</artist><cd>Live at Red Rocks</cd></recording>" & _
        "<recording><artist>U2</artist><cd>Joshua Tree</cd></recording>" & _
        "<recording><artist>U2</artist><cd>How to Dismantle an Atomic Bomb</cd></recording>" & _
        "<recording><artist>Natalie Merchant</artist><cd>Tigerlily</cd></recording>" & _
        "</music>"
    
    ' Read the xml.
    Dim reader As New StringReader(musicXml)
    set1.ReadXml(reader)
    
    ' Get a DataView of the table contained in the dataset.
    Dim tables As DataTableCollection = set1.Tables
    Dim view1 As New DataView(tables(0))
    
    ' Create a DataGridView control and add it to the form.
    Dim datagridview1 As New DataGridView()
    datagridview1.AutoGenerateColumns = True
    Me.Controls.Add(datagridview1)
    
    ' Create a BindingSource and set its DataSource property to
    ' the DataView.
    Dim source1 As New BindingSource()
    source1.DataSource = view1
    
    ' Set the data source for the DataGridView.
    datagridview1.DataSource = source1
    
    source1.Sort = "artist ASC, cd ASC"

Comentarios

La Sort propiedad es una cadena que distingue entre mayúsculas y minúsculas y que especifica los nombres de columna utilizados para ordenar las filas, junto con la dirección de ordenación.The Sort property is a case-sensitive string that specifies the column names used to sort the rows, along with the sort direction. Las columnas están ordenadas por orden ascendente de forma predeterminada.Columns are sorted ascending by default. Puede haber varias columnas separadas por comas, "State, ZipCode DESC"como.Multiple columns can be separated by commas, such as "State, ZipCode DESC".

Para admitir la ordenación, la lista subyacente debe implementar IBindingList las IBindingListView interfaces o.To support sorting, the underlying list must implement the IBindingList or IBindingListView interfaces. Esta capacidad se puede consultar a través SupportsSorting de la propiedad.This capability can be queried through the SupportsSorting property. La ordenación de varias columnas está disponible SupportsAdvancedSorting cuando la truepropiedad es.Multicolumn sorting is available when the SupportsAdvancedSorting property is true.

Al establecer Sort la propiedad, se cambiará la lista interna en función de su tipo:Setting the Sort property will change the internal list depending on its type:

Las propiedades de ordenación de la lista interna solo cambian cuando la cadena de nullordenación no es.The internal list's sort properties are only changed when the sort string is not null. El get descriptor de acceso de esta propiedad no recuperará el valor de ordenación de la lista interna; en set su lugar, devolverá el valor del descriptor de acceso.The get accessor for this property will not retrieve the sort value of the internal list; instead, it will return the set accessor value. El valor de la Sort propiedad se conservará cuando cambie el origen de datos.The value of the Sort property will persist when the data source changes.

Se aplica a

Consulte también: