private void dgv_GiaoVien_CellValidating(object sender, DataGridViewCellValidatingEventArgs e)
{
string headerText =
dgv_Teachers.Columns[e.ColumnIndex].HeaderText;
if (headerText.Equals("MAGV"))
{
string valCurrent = e.FormattedValue.ToString();
if (SqlRequestFunction.TeacherIsExists(valCurrent))
{
//dgv_Teachers.Rows[e.RowIndex].ErrorText = "Had error";
//dgv_Teachers.Rows[e.RowIndex].Cells[e.ColumnIndex].ErrorText = "Teacher Code Is Exists.";
//dgv_Teachers.CurrentCell = dgv_Teachers.Rows[e.RowIndex].Cells[e.ColumnIndex];
//e.Cancel = true;
}
}
}
private void Dgv_Teachers_RowValidating(object sender, DataGridViewCellCancelEventArgs e)
{
try
{
bool isFirst = true;
int index = 0;
foreach (DataGridViewCell drv in dgv_Teachers.Rows[e.RowIndex].Cells)
{
if (String.IsNullOrEmpty(drv.Value.ToString()))
{
e.Cancel = true;
dgv_Teachers.Rows[e.RowIndex].ErrorText = "Had error";
dgv_Teachers.Rows[e.RowIndex].Cells[index].ErrorText = "Dose not empty.";
dgv_Teachers.CurrentCell = drv;
}
else
{
dgv_Teachers.Rows[e.RowIndex].Cells[index].ErrorText = null;
}
if (isFirst)
{
string valCurrent = drv.FormattedValue.ToString();
if (SqlRequestFunction.TeacherIsExists(valCurrent))
{
dgv_Teachers.Rows[e.RowIndex].ErrorText = "Had error";
dgv_Teachers.Rows[e.RowIndex].Cells[index].ErrorText = "Teacher Code Is Exists.";
dgv_Teachers.CurrentCell = drv;
}
else
{
dgv_Teachers.Rows[e.RowIndex].Cells[index].ErrorText = null;
}
isFirst = false;
}
index++;
}
}
catch { }
}
