DataView.Sort Eigenschap

Definitie

Naamruimte:
System.Data
Assembly:
System.Data.dll
Assembly:
netstandard.dll

Hiermee haalt u de sorteerkolom of -kolommen op of stelt u deze in en sorteervolgorde voor 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

Waarde van eigenschap

String

Een tekenreeks die de kolomnaam bevat, gevolgd door 'ASC' (oplopend) of 'DESC' (aflopend). Kolommen worden standaard oplopend gesorteerd. Meerdere kolommen kunnen worden gescheiden door komma's.

Kenmerken
DataSysDescriptionAttribute

Voorbeelden

In het volgende voorbeeld wordt de DataView tabel gesorteerd op twee kolommen.

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

Opmerkingen

Als u niet expliciet sorteercriteria DataViewopgeeft, worden de DataRowView objecten in DataView gesorteerd op basis van de index van de bijbehorende DataRow objecten in de DataTable.RowsDataRowCollection.

Zie DataViews voor meer informatie.

Van toepassing op

Zie ook