protected void gvDentist_RowCommand(object sender, GridViewCommandEventArgs e)
 {
     if (e.CommandName == "cmdedit")
     {
         Dentist d = new Dentist();
         d.Dentist_ID1 = Convert.ToInt32(e.CommandArgument);
         d.getDentistDataByID();
         txtfirstname.Text            = d.FirstName1;
         txtlastName.Text             = d.LastName1;
         txtMiddleName.Text           = d.LastName1;
         txtssn.Text                  = d.SSN1;
         txtworkexp.Text              = Convert.ToString(d.Workexp1);
         ddldentistType.SelectedValue = d.DentistType1;
         ddlgender.SelectedValue      = d.Gender1;
         hfdentistID.Value            = Convert.ToString(d.Dentist_ID1);
     }
     if (e.CommandName == "cmddelete")
     {
         Dentist d = new Dentist();
         d.Dentist_ID1 = Convert.ToInt32(e.CommandArgument);
         d.removeDentist();
         bindGrid();
     }
 }