為DataTable設定主鍵

來源:互聯網
上載者:User
Gets or sets an array of columns that function as primary keys for the data table.

[Visual Basic]
<Serializable>
Public Property PrimaryKey As DataColumn ()
[C#]
[Serializable]
public DataColumn[] PrimaryKey {get; set;}
[C++]
[Serializable]
public: __property DataColumn* get_PrimaryKey();
public: __property void set_PrimaryKey(DataColumn*[]);
[JScript]
public
   Serializable
function get PrimaryKey() : DataColumn[];
public function set PrimaryKey(DataColumn[]);
Property Value
An array of DataColumn objects.

Exceptions
Exception Type Condition
DataException The key is a foreign key.

Remarks
The primary key of a table must be unique to identify the record in the table. It's also possible to have a table with a primary key made up of two or more columns. This occurs when a single column can't contain enough unique values. For example, a two column primary key might consist of a "FirstName" and "LastName" column. Because primary keys can be made up of more than one column, the PrimaryKey property consists of an array of DataColumn objects.

Example
[Visual Basic, C#] The first example shows how to return the primary key columns for a DataTable displayed in a DataGrid. The second example demonstrates how to set the primary key columns for a DataTable.

[Visual Basic]
Private Sub GetPrimaryKeys(myTable As DataTable)
   ' Create the array for the columns.
   Dim colArr() As DataColumn
   colArr = myTable.PrimaryKey
   ' Get the number of elements in the array.
   Console.WriteLine("Column Count: " & colArr.Length.ToString())
   Dim i As Integer
   For i = 0 To colArr.GetUpperBound(0)
      Console.WriteLine(colArr(i).ColumnName & colArr(i).DataType.ToString())
   Next i
End Sub

Private Sub SetPrimaryKeys()
   ' Create a new DataTable and set two DataColumn objects as primary keys.
   Dim myTable As DataTable = new DataTable()
   Dim keys(2) As DataColumn
   Dim myColumn  As DataColumn
   ' Create column 1.
   myColumn = New DataColumn()
   myColumn.DataType = System.Type.GetType("System.String")
   myColumn.ColumnName= "FirstName"
   ' Add the column to the DataTable.Columns collection.
   myTable.Columns.Add(myColumn)
   ' Add the column to the array.
   keys(0) = myColumn

   ' Create column 2 and add it to the array.
   myColumn = New DataColumn()
   myColumn.DataType = System.Type.GetType("System.String")
   myColumn.ColumnName = "LastName"
   myTable.Columns.Add(myColumn)
   ' Add the column to the array.
   keys(1) = myColumn
   ' Set the PrimaryKeys property to the array.
   myTable.PrimaryKey = keys
End Sub
[C#]
private void GetPrimaryKeys(DataTable myTable){
   // Create the array for the columns.
   DataColumn[] colArr;
   colArr = myTable.PrimaryKey;
   // Get the number of elements in the array.
   Console.WriteLine("Column Count: " + colArr.Length);
   for(int i = 0; i < colArr.Length; i++){
      Console.WriteLine(colArr[i].ColumnName + colArr[i].DataType);
   }
}

private void SetPrimaryKeys(){
   // Create a new DataTable and set two DataColumn objects as primary keys.
   DataTable myTable = new DataTable();
   DataColumn[] keys = new DataColumn[2];
   DataColumn myColumn;
   // Create column 1.
   myColumn = new DataColumn();
   myColumn.DataType = System.Type.GetType("System.String");
   myColumn.ColumnName= "FirstName";
   // Add the column to the DataTable.Columns collection.
   myTable.Columns.Add(myColumn);
   // Add the column to the array.
   keys[0] = myColumn;

   // Create column 2 and add it to the array.
   myColumn = new DataColumn();
   myColumn.DataType = System.Type.GetType("System.String");
   myColumn.ColumnName = "LastName";
   myTable.Columns.Add(myColumn);
   // Add the column to the array.
   keys[1] = myColumn;
   // Set the PrimaryKeys property to the array.
   myTable.PrimaryKey = keys;
}
[C++, JScript] No example is available for C++ or JScript. To view a Visual Basic or C# example, click the Language Filter button  in the upper-left corner of the page.

Requirements
Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows .NET Server family


相關文章

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。