/// <summary>
    /// load lookup data.
    /// </summary>
    private void LoadLookups()
    {
        GOVERNORATE objGov = new GOVERNORATE();
        objGov.LoadAll();

        drpState.DataSource = objGov.DefaultView;
        drpState.DataTextField = GOVERNORATE.ColumnNames.DESCR;
        drpState.DataValueField = GOVERNORATE.ColumnNames.CD;
        drpState.DataBind();

        ListItem item = new ListItem("-----", "0");
        drpState.Items.Insert(0, item);
        drpSubSection.Items.Insert(0, item);
        dropSection.Items.Insert(0, item);
        drpState.SelectedIndex = 0;

        Jobs jobs = new Jobs ();
        jobs.LoadAll();

        uiDropDownListJob.DataSource = jobs.DefaultView;
        uiDropDownListJob.DataTextField = Jobs.ColumnNames.Name;
        uiDropDownListJob.DataValueField = Jobs.ColumnNames.Id;
        uiDropDownListJob.Items.Insert(0, item);
        uiDropDownListJob.DataBind();
    }