private void TxtDescription_Validating(object sender, CancelEventArgs e) { if (_Tag == "" || this.ActiveControl == TxtDescription) { return; } if (TxtDescription.Enabled == false) { return; } if (string.IsNullOrEmpty(TxtDescription.Text)) { MessageBox.Show("Scheme Description Cannot Left Blank...!", "Mr Solution", MessageBoxButtons.OK, MessageBoxIcon.Information); e.Cancel = true; TxtDescription.Focus(); return; } else if (_Tag == "NEW") { if (_objCommon.CheckDescriptionDuplicateRecord(TxtDescription.Text, "Product", "ProductDesc", "ProductId") == 1) { MessageBox.Show("Scheme Description Already Exist...!", "Mr Solution", MessageBoxButtons.OK, MessageBoxIcon.Information); e.Cancel = true; TxtDescription.Focus(); return; } } else if (_Tag == "EDIT") { if (_objCommon.CheckDescriptionDuplicateRecord(TxtDescription.Text, "Product", "ProductDesc", "ProductId", _SchemeId) != 0) { MessageBox.Show("Scheme Description Already Exist...!", "Mr Solution", MessageBoxButtons.OK, MessageBoxIcon.Information); e.Cancel = true; return; } } }