DataView.Sort DataView.Sort DataView.Sort DataView.Sort Property

定義

名前空間:
System.Data System.Data System.Data System.Data
Assemblies:
System.Data.dll, netstandard.dll, System.Data.Common.dll

1 つ以上の並べ替え列、および DataView の並べ替え順序を取得または設定します。Gets or sets the sort column or columns, and sort order for the DataView.

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

プロパティ値

String String String String

列名の後に "ASC" (昇順) または "DESC" (降順) を含む文字列。A string that contains the column name followed by "ASC" (ascending) or "DESC" (descending). 既定では列は昇順で並べ替えられます。Columns are sorted ascending by default. 複数の列をコンマで区切ることができます。Multiple columns can be separated by commas.

例

次の例の指示、 DataView 2 つの列によってテーブルの並べ替えにします。The following example instructs the DataView to sort the table by two columns. 

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

注釈

並べ替え条件を明示的に指定しない場合DataView、DataRowViewオブジェクトDataViewは、対応するインデックスに基づいて並べ替えられますDataRowで、 DataTable.Rows DataRowCollectionします。If you do not explicitly specify sort criteria for DataView, the DataRowView objects in DataView are sorted based on the index of its corresponding DataRow in the DataTable.Rows DataRowCollection.

詳細については、次を参照してください。 Dataviewします。For more information, see DataViews.

適用対象

こちらもご覧ください