DataView.Sort Propiedad

Definición

Espacio de nombres:
System.Data
Ensamblado:
System.Data.dll
Ensamblado:
netstandard.dll

Obtiene o establece la columna o columnas de ordenación y el criterio de ordenación de DataView.

public:
 property System::String ^ Sort { System::String ^ get(); void set(System::String ^ value); };
[System.Data.DataSysDescription("DataViewSortDescr")]
public string Sort { get; set; }
public string Sort { get; set; }
[<System.Data.DataSysDescription("DataViewSortDescr")>]
member this.Sort : string with get, set
member this.Sort : string with get, set
Public Property Sort As String

Valor de propiedad

String

Cadena que contiene el nombre de columna seguido de "ASC" (ascendente) o "DESC" (descendente). Las columnas se ordenan de forma ascendente de forma predeterminada. Varias columnas se pueden separar por comas.

Atributos
DataSysDescriptionAttribute

Ejemplos

En el ejemplo siguiente se indica a que ordene DataView la tabla por dos columnas.

using System.Data;
using System;
public class A {
   static void Main(string[] args) {
      DataTable locationTable = new DataTable("Location");
      // Add two columns
      locationTable.Columns.Add("State");
      locationTable.Columns.Add("ZipCode");

      // Add data
      locationTable.Rows.Add("Washington", "98052");
      locationTable.Rows.Add("California", "90001");
      locationTable.Rows.Add("Hawaii", "96807");
      locationTable.Rows.Add("Hawaii", "96801");
      locationTable.AcceptChanges();

      Console.WriteLine("Rows in original order\n State \t\t ZipCode");
      foreach (DataRow row in locationTable.Rows) {
         Console.WriteLine(" {0} \t {1}", row["State"], row["ZipCode"]);
      }

      // Create DataView
      DataView view = new DataView(locationTable);

      // Sort by State and ZipCode column in descending order
      view.Sort = "State ASC, ZipCode ASC";

      Console.WriteLine("\nRows in sorted order\n State \t\t ZipCode");
      foreach (DataRowView row in view) {
         Console.WriteLine(" {0} \t {1}", row["State"], row["ZipCode"]);
      }
   }
}

Imports System.Data
Public Class A
   Public Shared Sub Main(args As String())
      Dim locationTable As New DataTable("Location")
      ' Add two columns
      locationTable.Columns.Add("State")
      locationTable.Columns.Add("ZipCode")

      ' Add data 
      locationTable.Rows.Add("Washington", "98052")
      locationTable.Rows.Add("California", "90001")
      locationTable.Rows.Add("Hawaii", "96807")
      locationTable.Rows.Add("Hawaii", "96801")
      locationTable.AcceptChanges()

      Console.WriteLine("Rows in original order" & vbLf & " State " & vbTab & vbTab & " ZipCode")
      For Each row As DataRow In locationTable.Rows
         Console.WriteLine(" {0} " & vbTab & " {1}", row("State"), row("ZipCode"))
      Next

      ' Create DataView
      Dim view As New DataView(locationTable)

      ' Sort by State and ZipCode column in descending order
      view.Sort = "State ASC, ZipCode ASC"

      Console.WriteLine(vbLf & "Rows in sorted order" & vbLf & " State " & vbTab & vbTab & " ZipCode")
      For Each row As DataRowView In view
         Console.WriteLine(" {0} " & vbTab & " {1}", row("State"), row("ZipCode"))
      Next
   End Sub
End Class

Comentarios

Si no especifica explícitamente criterios de ordenación para DataView, los DataRowView objetos de DataView se ordenan en función del índice de su correspondiente DataRow en .DataTable.RowsDataRowCollection

Para obtener más información, consulte DataViews.

Se aplica a

Consulte también