protected void btnClearFilter_Click(object sender, EventArgs e)
    {
        DDLFleet.ClearSelection();
        DDLVessel.ClearSelection();

        DDLRank.ClearSelection();
        DDLNationality.ClearSelection();
        DDLManningOffice.ClearSelection();
        DDLCommentedBy.ClearSelection();


        DDLStatus.SelectedValue = "1";

        txtSearch.Text          = "";
        txtCommentFromDate.Text = "";
        txtCommentToDate.Text   = "";

        BindFleetDLL();
        BindVesselDDL();

        Load_RankList();
        Load_CountryList();
        Load_ManningAgentList();

        BindUserList();

        BindGrid();
    }
    public void BindUserList()
    {
        DataTable dt     = objUser.Get_UserList();
        string    filter = "User_type ='OFFICE USER' ";


        dt.DefaultView.RowFilter = filter;

        DDLCommentedBy.DataSource     = dt.DefaultView.ToTable();
        DDLCommentedBy.DataTextField  = "UserName";
        DDLCommentedBy.DataValueField = "UserID";
        DDLCommentedBy.DataBind();
    }