make datarow unique on multiple columns in csharp

main.cs
// create a DataTable
DataTable table = new DataTable("myTable");

// add columns
table.Columns.Add("Column1", typeof(int));
table.Columns.Add("Column2", typeof(string));
table.Columns.Add("Column3", typeof(bool));

// create a unique constraint on columns Column1 and Column2
table.Constraints.Add(new UniqueConstraint(new DataColumn[] { table.Columns["Column1"], table.Columns["Column2"] }));

// create a DataRow that violates the unique constraint
DataRow row1 = table.NewRow();
row1["Column1"] = 1;
row1["Column2"] = "Value";
row1["Column3"] = true;

// add the row to the table
table.Rows.Add(row1);

// create another DataRow with the same values for columns Column1 and Column2
DataRow row2 = table.NewRow();
row2["Column1"] = 1;
row2["Column2"] = "Value";
row2["Column3"] = false;

// try to add the second row to the table
try
{
    table.Rows.Add(row2); // this will throw a constraint violation exception
}
catch (Exception ex)
{
    Console.WriteLine(ex.Message);
}
979 chars
36 lines