protected void MedicalServiceDetailsFormView_ItemUpdating(object sender, FormViewUpdateEventArgs e)
    {
        // set the MedicalServiceGroupID
        // get the control from the formview
        var groupNameControl = (DropDownList)MedicalServiceDetailsFormView.FindControl("MedicalServiceGroupNameDropdownList");

        // set the value to be updated
        e.NewValues["MedicalServiceGroupID"] = groupNameControl.SelectedValue;
    }
    protected void BindData()
    {
        long ID = long.Parse(Request.QueryString["ID"]);

        // select the medical service from database
        var ctx            = new DataClassesDataContext();
        var medicalService = from m in ctx.MedicalServices
                             join g in ctx.MedicalServiceGroups
                             on m.MedicalServiceGroupID equals g.ID
                             where m.ID == ID
                             select new
        {
            ID    = m.ID,
            Name  = m.Name,
            Price = m.Price,
            Group = g.Name
        };

        MedicalServiceDetailsFormView.DataSource = medicalService;
        MedicalServiceDetailsFormView.DataBind();
    }
 protected void ClearForm()
 {
     ((TextBox)MedicalServiceDetailsFormView.FindControl("NameTextBox")).Text  = "";
     ((TextBox)MedicalServiceDetailsFormView.FindControl("PriceTextBox")).Text = "";
 }