[ DataGridView not enfocing foreign key constraint ]
I am trying to develop a business application however i am running into some problems.
I have a
DBDataSet that is using my database as its source.
I am using VS to automatically generate DataGridView by dragging from the datasource window and onto the form.
I have two tables.
Sales. There is a one-to-one relationship between them with the id column of
Sales Referencing id column of
However whenever i enter a value in id column of
Sales that is not in the id Column of
Customer the DataGridView doesn't do throw an exception but instead allows the data to be entered.
However when i try to enter a duplicate primary key in the same table the datagridview responds by throwing an exception.
How can i do the same for foreign key constraints.
ForeignKeyConstraint is not created during the import from database. Right click on Sales table in dataset view -> Add -> Relation... Select your primary and foreign key. "Choose what to create" first or second option. Or you can do it in code: this.DBDataSet.Sales.Constraints.Add( new ForeignKeyConstraint(this.DBDataSet.Customer.IdColumn, this.DBDataSet.Sales.IdColumn));