row validating not letting form to close if a new row added

anna john

after validating if all fields are available in a datagridview row, using RowValidating event; if the user accidently clicks on a new row, then the validations are triggered and not letting form to close.

Below is the code

private void dgv1_RowValidating(object sender, DataGridViewCellCancelEventArgs e)

{

if (dgv1.CurrentRow != null)

{

DataGridViewRow dgvRow = dgv1.CurrentRow;

if (dgvRow.Cells["txtEmpName"].Value == DBNull.Value)

{

MessageBox.Show("Employee Name cannot be empty");

e.Cancel = true;

}

the user enters one row successfully and clicks on next row. then row validation triggers and not letting form to close.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

anna john7y ago
used this code which i got from somewhere else. hopefully can help someone else
protected override void WndProc(ref Message m)
{
switch (((m.WParam.ToInt64() & 0xffff) & 0xfff0))
{
case 0xf060:
this.dataGridView1.CausesValidation = false;
break;
}
base.WndProc(ref m);
}
anna john7y ago
out of the 5 columns , i need name field not to be empty. The adress fields could be empty. so i added code to Row Validating event of the datagrid view, to check if name column is not null. if its null, there is a messagebox to alert it cannot be empty. but in case after entering a correct row, user clicks tab and new row came up in the datagrid view; and user want to close the form; it alerts "name cannot be empty" and unable to close the form. how can we handle this ?

Below is the code
private void dgv1_RowValidating(object sender, DataGridViewCellCancelEventArgs e)
{
if (dgv1.CurrentRow != null)
{
DataGridViewRow dgvRow = dgv1.CurrentRow;
if (dgvRow.Cells["txtEmpName"].Value == DBNull.Value)
{
MessageBox.Show("Employee Name cannot be empty");
e.Cancel = true;
}
}
}
Dinesh Gabhane7y ago
Can you please post Validation code and where you apply means on which event you applied validation?