private void LoadCompany()
        {
            try
            {
                CMSBL cmsBL = new CMSBL();
                DataTable companyDT = cmsBL.GetAllCompany();
                ddlCompany.Items.Clear();
                ddlCompany.Items.Add(new ListItem("Select Company", "Select Company"));
                foreach (DataRow companyDR in companyDT.Rows)
                {
                    ddlCompany.Items.Add(new ListItem(companyDR["COMPANYNAME"].ToString(), companyDR["COMPANYID"].ToString()));
                }
            }
            catch (Exception ex)
            {

            }
        }