protected void gdvDept_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string strEmpID = gdvDept.Rows[e.RowIndex].Cells[0].Text;
try
{
/*string strExistQry = "select count(*) from emp_mst where department = " + strdeptID;
* object objExist = objPayroll.GetScalar(strExistQry);
* if (Convert.ToInt32(objExist) > 0)
* {
* lblMessage.Text = "Can't Delete This Value becoz it Contains Record...";
* SqlDSdept.DeleteCommand = "Delete from dept_mst WHERE dept_no=0";
* SqlDSdept.Delete();
* gdvDept.DataBind();
* return;
* }*/
SqlDSdept.DeleteCommand = "Delete from emp_mst WHERE [emp_no] = " + strEmpID;
SqlDSdept.Delete();
lblMessage.Text = "RECORD DELETED SUCCESSFULLY...";
gdvDept.DataBind();
}
catch (Exception ex1)
{
lblMessage.Text = "Access Denied... :: " + ex1.Message;
}
}
