DataTable.Select 方法

定義

命名空間:

System.Data

組件:

netstandard.dll, System.Data.Common.dll

會得到一組 DataRow 物件陣列。

多載

名稱	Description
Select()	會得到一個包含所有 DataRow 物件的陣列。
Select(String)	會得到一個包含所有 DataRow 符合篩選條件物件的陣列。
Select(String, String)	會取得一個包含所有 DataRow 符合篩選條件的物件陣列，依照指定的排序順序排列。
Select(String, String, DataViewRowState)	會得到一個陣列，包含所有 DataRow 符合篩選器的物件，依排序順序排列指定狀態。

Select()

來源:

DataTable.cs

會得到一個包含所有 DataRow 物件的陣列。

public:
 cli::array <System::Data::DataRow ^> ^ Select();

public System.Data.DataRow[] Select();

member this.Select : unit -> System.Data.DataRow[]

Public Function Select () As DataRow()

傳回

DataRow[]

DataRow 物件的陣列。

範例

以下範例透過該Select方法回傳一組DataRow物件陣列。

private void GetRows()
{
    // Get the DataTable of a DataSet.
    DataTable table = DataSet1.Tables["Suppliers"];
    DataRow[] rows = table.Select();

    // Print the value one column of each DataRow.
    for(int i = 0; i < rows.Length ; i++)
    {
        Console.WriteLine(rows[i]["CompanyName"]);
    }
}

Private Sub GetRows()
    ' Get the DataTable of a DataSet.
    Dim table As DataTable = DataSet1.Tables("Suppliers")
    Dim rows() As DataRow = table.Select()

    Dim i As Integer
    ' Print the value one column of each DataRow.
    For i = 0 to rows.GetUpperBound(0)
       Console.WriteLine(rows(i)("CompanyName"))
    Next i
End Sub

備註

為確保正確的排序順序，請指定排序條件，並使用 Select(String, String) 或 Select(String, String, DataViewRowState)。

另請參閱

• CaseSensitive
• DataTables
• 零值

Select(String)

來源:

DataTable.cs

會得到一個包含所有 DataRow 符合篩選條件物件的陣列。

public:
 cli::array <System::Data::DataRow ^> ^ Select(System::String ^ filterExpression);

[System.Diagnostics.CodeAnalysis.RequiresUnreferencedCode("Members of types used in the filter expression might be trimmed.")]
public System.Data.DataRow[] Select(string? filterExpression);

[<System.Diagnostics.CodeAnalysis.RequiresUnreferencedCode("Members of types used in the filter expression might be trimmed.")>]
member this.Select : string -> System.Data.DataRow[]

Public Function Select (filterExpression As String) As DataRow()

參數

filterExpression

String

篩選資料列的標準。

傳回

DataRow[]

DataRow 物件的陣列。

屬性

RequiresUnreferencedCodeAttribute

範例

以下範例使用過濾表達式來回傳一組 DataRow 物件陣列。

private void GetRowsByFilter()
{
    DataTable table = DataSet1.Tables["Orders"];
    // Presuming the DataTable has a column named Date.
    string expression;
    expression = "Date > #1/1/00#";
    DataRow[] foundRows;

    // Use the Select method to find all rows matching the filter.
    foundRows = table.Select(expression);

    // Print column 0 of each returned row.
    for(int i = 0; i < foundRows.Length; i ++)
    {
        Console.WriteLine(foundRows[i][0]);
    }
}

Private Sub GetRowsByFilter()
    
    Dim table As DataTable = DataSet1.Tables("Orders")

    ' Presuming the DataTable has a column named Date.
    Dim expression As String
    expression = "Date > #1/1/00#"
    Dim foundRows() As DataRow

    ' Use the Select method to find all rows matching the filter.
    foundRows = table.Select(expression)

    Dim i As Integer
    ' Print column 0 of each returned row.
    For i = 0 to foundRows.GetUpperBound(0)
       Console.WriteLine(foundRows(i)(0))
    Next i
End Sub

備註

要建立filterExpression參數，請使用與類別Expression屬性值相同的DataColumn規則來建立過濾器。

為確保正確的排序順序，請指定排序條件，並使用 Select(String, String) 或 Select(String, String, DataViewRowState)。

如果濾波器上的欄位包含空值，則該值不會包含在結果中。

另請參閱

• CaseSensitive
• DataTables
• 零值

Select(String, String)

來源:

DataTable.cs

會取得一個包含所有 DataRow 符合篩選條件的物件陣列，依照指定的排序順序排列。

public:
 cli::array <System::Data::DataRow ^> ^ Select(System::String ^ filterExpression, System::String ^ sort);

[System.Diagnostics.CodeAnalysis.RequiresUnreferencedCode("Members of types used in the filter expression might be trimmed.")]
public System.Data.DataRow[] Select(string? filterExpression, string? sort);

[<System.Diagnostics.CodeAnalysis.RequiresUnreferencedCode("Members of types used in the filter expression might be trimmed.")>]
member this.Select : string * string -> System.Data.DataRow[]

Public Function Select (filterExpression As String, sort As String) As DataRow()

參數

filterExpression

String

篩選資料列的標準。

sort

String

一個字串，指定欄位與排序方向。

傳回

DataRow[]

一個與濾鏡表達式相符的物件陣列 DataRow 。

屬性

RequiresUnreferencedCodeAttribute

範例

以下範例使用過濾表達式來回傳一組 DataRow 物件陣列。

using System;
using System.Data;

public class A {

   public static void Main() {
      DataTable table = new DataTable("Orders");
      table.Columns.Add("OrderID", typeof(Int32));
      table.Columns.Add("OrderQuantity", typeof(Int32));
      table.Columns.Add("CompanyName", typeof(string));
      table.Columns.Add("Date", typeof(DateTime));

      DataRow newRow = table.NewRow();
      newRow["OrderID"] = 1;
      newRow["OrderQuantity"] = 3;
      newRow["CompanyName"] = "NewCompanyName";
      newRow["Date"] = "1979, 1, 31";

      // Add the row to the rows collection.
      table.Rows.Add(newRow);

      DataRow newRow2 = table.NewRow();
      newRow2["OrderID"] = 2;
      newRow2["OrderQuantity"] = 2;
      newRow2["CompanyName"] = "NewCompanyName1";
      table.Rows.Add(newRow2);

      DataRow newRow3 = table.NewRow();
      newRow3["OrderID"] = 3;
      newRow3["OrderQuantity"] = 2;
      newRow3["CompanyName"] = "NewCompanyName2";
      table.Rows.Add(newRow3);

      // Presuming the DataTable has a column named Date.
      string expression = "Date = '1/31/1979' or OrderID = 2";
      // string expression = "OrderQuantity = 2 and OrderID = 2";

      // Sort descending by column named CompanyName.
      string sortOrder = "CompanyName ASC";
      DataRow[] foundRows;

      // Use the Select method to find all rows matching the filter.
      foundRows = table.Select(expression, sortOrder);

      // Print column 0 of each returned row.
      for (int i = 0; i < foundRows.Length; i++)
         Console.WriteLine(foundRows[i][2]);
   }
}

Imports System.Data

Public Class A

   Public Shared Sub Main()
      Dim table As New DataTable("Orders")
      table.Columns.Add("OrderID", GetType(Int32))
      table.Columns.Add("OrderQuantity", GetType(Int32))
      table.Columns.Add("CompanyName", GetType(String))
      table.Columns.Add("Date", GetType(DateTime))

      Dim newRow As DataRow = table.NewRow()
      newRow("OrderID") = 1
      newRow("OrderQuantity") = 3
      newRow("CompanyName") = "NewCompanyName"
      newRow("Date") = "1979, 1, 31"

      ' Add the row to the rows collection.
      table.Rows.Add(newRow)

      Dim newRow2 As DataRow = table.NewRow()
      newRow2("OrderID") = 2
      newRow2("OrderQuantity") = 2
      newRow2("CompanyName") = "NewCompanyName1"
      table.Rows.Add(newRow2)

      Dim newRow3 As DataRow = table.NewRow()
      newRow3("OrderID") = 3
      newRow3("OrderQuantity") = 2
      newRow3("CompanyName") = "NewCompanyName2"
      table.Rows.Add(newRow3)

      ' Presuming the DataTable has a column named Date.
      Dim expression As String = "Date = '1/31/1979' or OrderID = 2"
      ' Dim expression As String = "OrderQuantity = 2 and OrderID = 2"

      ' Sort descending by column named CompanyName.
      Dim sortOrder As String = "CompanyName ASC"
      Dim foundRows As DataRow()

      ' Use the Select method to find all rows matching the filter.
      foundRows = table.[Select](expression, sortOrder)

      ' Print column 0 of each returned row.
      For i As Integer = 0 To foundRows.Length - 1
         Console.WriteLine(foundRows(i)(2))
      Next
   End Sub
End Class

備註

要形成 filterExpression 論證，請使用相同的規則來建立 DataColumn 類別的 Expression 屬性值。 該 Sort 論證也使用相同的規則來建立類別的 Expression 字串。

如果濾波器上的欄位包含空值，則該值不會包含在結果中。

另請參閱

• CaseSensitive
• DataTables
• 零值

Select(String, String, DataViewRowState)

來源:

DataTable.cs

會得到一個陣列，包含所有 DataRow 符合篩選器的物件，依排序順序排列指定狀態。

public:
 cli::array <System::Data::DataRow ^> ^ Select(System::String ^ filterExpression, System::String ^ sort, System::Data::DataViewRowState recordStates);

[System.Diagnostics.CodeAnalysis.RequiresUnreferencedCode("Members of types used in the filter expression might be trimmed.")]
public System.Data.DataRow[] Select(string? filterExpression, string? sort, System.Data.DataViewRowState recordStates);

[<System.Diagnostics.CodeAnalysis.RequiresUnreferencedCode("Members of types used in the filter expression might be trimmed.")>]
member this.Select : string * string * System.Data.DataViewRowState -> System.Data.DataRow[]

Public Function Select (filterExpression As String, sort As String, recordStates As DataViewRowState) As DataRow()

參數

filterExpression

String

篩選資料列的標準。

sort

String

一個字串，指定欄位與排序方向。

recordStates

DataViewRowState

這是其中一項 DataViewRowState 價值。

傳回

DataRow[]

DataRow 物件的陣列。

屬性

RequiresUnreferencedCodeAttribute

範例

以下範例使用過濾表達式與記錄狀態來回傳一組 DataRow 物件。

private static void GetRowsByFilter()
{
    DataTable customerTable = new DataTable("Customers");
    // Add columns
    customerTable.Columns.Add("id", typeof(int));
    customerTable.Columns.Add("name", typeof(string));

    // Set PrimaryKey
    customerTable.Columns[ "id" ].Unique = true;
    customerTable.PrimaryKey = new DataColumn[]
        { customerTable.Columns["id"] };

    // Add ten rows
    for(int id=1; id<=10; id++)
    {
        customerTable.Rows.Add(
            new object[] { id, string.Format("customer{0}", id) });
    }
    customerTable.AcceptChanges();

    // Add another ten rows
    for(int id=11; id<=20; id++)
    {
        customerTable.Rows.Add(
            new object[] { id, string.Format("customer{0}", id) });
    }

    string expression;
    string sortOrder;

    expression = "id > 5";
    // Sort descending by column named CompanyName.
    sortOrder = "name DESC";
    // Use the Select method to find all rows matching the filter.
    DataRow[] foundRows =
        customerTable.Select(expression, sortOrder,
        DataViewRowState.Added);

    PrintRows(foundRows, "filtered rows");

    foundRows = customerTable.Select();
    PrintRows(foundRows, "all rows");
}

private static void PrintRows(DataRow[] rows, string label)
{
    Console.WriteLine("\n{0}", label);
    if(rows.Length <= 0)
    {
        Console.WriteLine("no rows found");
        return;
    }
    foreach(DataRow row in rows)
    {
        foreach(DataColumn column in row.Table.Columns)
        {
            Console.Write("\table {0}", row[column]);
        }
        Console.WriteLine();
    }
}

Private Sub GetRowsByFilter()

    Dim customerTable As New DataTable("Customers")

    ' Add columns
    customerTable.Columns.Add("id", GetType(Integer))
    customerTable.Columns.Add("name", GetType(String))

    ' Set PrimaryKey
    customerTable.Columns("id").Unique = True
    customerTable.PrimaryKey = New DataColumn() _
        {customerTable.Columns("id")}

    ' add ten rows
    Dim id As Integer
    For id = 1 To 10
        customerTable.Rows.Add( _
        New Object() {id, String.Format("customer{0}", id)})
    Next id
    customerTable.AcceptChanges()

    ' add another ten rows
    For id = 11 To 20
        customerTable.Rows.Add( _
        New Object() {id, String.Format("customer{0}", id)})
    Next id

    Dim expression As String
    Dim sortOrder As String

    expression = "id > 5"
    ' Sort descending by CompanyName column.
    sortOrder = "name DESC"

    ' Use the Select method to find all rows matching the filter.
    Dim foundRows As DataRow() = _
        customerTable.Select(expression, sortOrder, _
        DataViewRowState.Added)

    PrintRows(foundRows, "filtered rows")

    foundRows = customerTable.Select()
    PrintRows(foundRows, "all rows")
End Sub

Private Sub PrintRows(ByVal rows() As DataRow, ByVal label As String)
    Console.WriteLine("\n{0}", label)
    If rows.Length <= 0 Then
        Console.WriteLine("no rows found")
        Exit Sub
    End If

    Dim row As DataRow
    Dim column As DataColumn
    For Each row In rows
        For Each column In row.Table.Columns
            Console.Write("\table {0}", row(column))
        Next column
        Console.WriteLine()
    Next row
End Sub

備註

要形成 filterExpression 論證，請使用相同的規則來建立 DataColumn 類別的 Expression 屬性值。 該 Sort 論證也使用相同的規則來建立類別的 Expression 字串。

如果濾波器上的欄位包含空值，則該值不會包含在結果中。

另請參閱

• DataTables
• 零值