protected void btnDelete_Click(object sender, EventArgs e)
 {
     try
     {
         clsEmployeeDetails obj = new clsEmployeeDetails();
         if (obj.UpDelEmp(empid, txtfname.Text, txtlname.Text, txtPhoneno.Text, txtEmail.Text, txtAddress.Text, txtCity.Text, txtState.Text) > 0)
         {
             lblMessage.Text = "Updated successfully";
         }
         else
         {
             lblMessage.Text = "request failed";
         }
     }
     catch (Exception ex)
     {
         lblMessage.Text = ex.Message;
     }
 }
    public void GetData()
    {
        Session["EID"] = Session["EmpId"];
        empid          = Convert.ToInt32(Session["EID"]);

        if (empid == 0)
        {
            return;
        }
        clsEmployeeDetails obj = new clsEmployeeDetails();
        DataSet            ds  = obj.GetEmp(empid);

        txtfname.Text    = ds.Tables[0].Rows[0]["FirstName"].ToString();
        txtlname.Text    = ds.Tables[0].Rows[0]["LastName"].ToString();
        txtPhoneno.Text  = ds.Tables[0].Rows[0]["PhoneNo"].ToString();
        txtEmail.Text    = ds.Tables[0].Rows[0]["Email"].ToString();
        txtAddress.Text  = ds.Tables[0].Rows[0]["Address"].ToString();
        txtCity.Text     = ds.Tables[0].Rows[0]["City"].ToString();
        txtState.Text    = ds.Tables[0].Rows[0]["State"].ToString();
        txtDeptName.Text = ds.Tables[0].Rows[0]["DeptName"].ToString();
    }