Foreign Key Constriant error.

Question

Hi,

{MySql.Data.MySqlClient.MySqlException: Cannot delete or update a parent row: a foreign key constraint fails

When i try to run;

delete from childtable where column=100;
cmd.executnonquery();

delete from parenttable where column=100;
cmd.executnonquery();

Am trying to delete child entry first before parent. Any thoughts.

Thanks.