This documentation is archived and is not being maintained.

UniqueConstraint Constructor (String, DataColumn[])

Initializes a new instance of the UniqueConstraint class with the specified name and array of DataColumn objects.

Namespace: System.Data
Assembly: System.Data (in system.data.dll)

public UniqueConstraint (
	string name,
	DataColumn[] columns
)
public UniqueConstraint (
	String name, 
	DataColumn[] columns
)
public function UniqueConstraint (
	name : String, 
	columns : DataColumn[]
)

Parameters

name

The name of the constraint.

columns

The array of DataColumn objects to constrain.

The following example creates a DataTable with two columns, and adds a new UniqueConstraint to the ConstraintCollection.

static private void MakeTableWithUniqueConstraint()
{
    // Create a DataTable with 2 DataColumns.
    DataTable dataTable = new DataTable("dataTable");
    DataColumn idColumn = new DataColumn(
        "id", System.Type.GetType("System.Int32"));
    DataColumn nameColumn = new DataColumn(
        "Name", System.Type.GetType("System.String"));
    dataTable.Columns.Add(idColumn);
    dataTable.Columns.Add(nameColumn);

    // Run procedure to create a constraint.
    AddUniqueConstraint(dataTable);

    // Add one row to the table.
    DataRow dataRow;
    dataRow = dataTable.NewRow();
    dataRow["id"] = 1;
    dataRow["Name"] = "John";
    dataTable.Rows.Add(dataRow);

    // Display the constraint name. 
    Console.WriteLine(
        dataTable.Constraints[0].ConstraintName);

    // Try to add an identical row, 
    // which throws an exception.
    try
    {
        dataRow = dataTable.NewRow();
        dataRow["id"] = 1;
        dataRow["Name"] = "John";
        dataTable.Rows.Add(dataRow);
    
    catch (Exception ex)
    {
        Console.WriteLine(
            "Exception Type: {0", ex.GetType());
        Console.WriteLine(
            "Exception Message: {0", ex.Message);
    

static private void AddUniqueConstraint(
    DataTable dataTable)
{
    // Create the DataColumn array.
    DataColumn[] dataColumns = new DataColumn[2];
    dataColumns[0] = dataTable.Columns["id"];
    dataColumns[1] = dataTable.Columns["Name"];

    // Create the constraint on both columns.
    UniqueConstraint uniqueConstraint =
        new UniqueConstraint("idNameConstraint", dataColumns);
    dataTable.Constraints.Add(uniqueConstraint);


Windows 98, Windows 2000 SP4, Windows CE, Windows Millennium Edition, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.

.NET Framework

Supported in: 2.0, 1.1, 1.0

.NET Compact Framework

Supported in: 2.0, 1.0
Show: