condition for add new row in datagridview

[Firas2014]

I have two table the first is called Imprrests and the second is called ]IprestsPays. There is an Imprest_ID column that is primary key in [icode]Imprests[/code] table and foreign key in ImprestsPays table

Imprests table consists the following columns:

Imprest_ID,  Impres_value,  Imprest_date,    Employee_ID

Where Employee_ID column is primary key in Employees table and foreign key in Imprests table.

ImprestsPays table consists the following columns:

ID,  Payment_value,  Payment_date,  Imprest_ID

My problem is in the buttonadd_click event in Imprsts form.

I want to prevent user from insert any new imprest for employee in Imprests table if employee haven't paid all payments in ImprestsPays table for old imprest

How can I solve this problem?
What is the code to do that?

[Frinavale]

I would write a SQL stored procedure that would return a true/false value that do the work to determine whether or not the employee has paid all payments (in your ImprestsPays table).

If it returns true, do the insert, otherwise do not do the insert.

It may actually be better to do the whole "create" in a stored procedure that does all the work for you in SQL instead of C#.

-Frinny