获取所有 DataRow 对象的数组。
[Visual Basic] Overloads Public Function Select() As DataRow() [C#] public DataRow[] Select(); [C++] public: DataRow* Select() []; [JScript] public function Select() : DataRow[];
返回值
DataRow 对象的数组。
备注
该方法按照主键顺序返回当前行(如果没有主键,则按照添加顺序)。
示例
[Visual Basic, C#, C++] 以下示例通过 Select 方法返回 DataRow 对象的数组。
[Visual Basic] Private Sub GetRows() Dim myRows() As DataRow Dim myTable As DataTable ' Get the DataTable of a DataSet. myTable = DataSet1.Tables("Suppliers") myRows = myTable.Select() Dim i As Integer ' Print the value one column of each DataRow. For i = 0 to myRows.GetUpperBound(0) Console.WriteLine(myRows(i)("CompanyName")) Next i End Sub [C#] private void GetRows(){ DataRow[] myRows; DataTable myTable; // Get the DataTable of a DataSet. myTable = DataSet1.Tables["Suppliers"]; myRows = myTable.Select(); // Print the value one column of each DataRow. for(int i = 0; i < myRows.Length ; i++){ Console.WriteLine(myRows[i]["CompanyName"]); } } [C++] private: void GetRows(){ DataRow* myRows[]; DataTable* myTable; // Get the DataTable of a DataSet. myTable = DataSet1->Tables->Item[S"Suppliers"]; myRows = myTable->Select(); // Print the value one column of each DataRow. for(int i = 0; i < myRows->Length ; i++){ Console::WriteLine(myRows[i]->Item[S"CompanyName"]); } }
[JScript] 没有可用于 JScript 的示例。若要查看 Visual Basic、C# 或 C++ 示例,请单击页左上角的“语言筛选器”按钮 。
要求
平台: Windows 98, Windows NT 4.0, Windows ME, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 系列, .NET Framework 精简版
请参见
DataTable 类 | DataTable 成员 | System.Data 命名空间 | DataTable.Select 重载列表 | CaseSensitive | DataRow