public DataTable GetSubCategoryByCategoryID(int CategoryID, bool IsActive)
        {
            DataTable dt = new DataTable();

            using (AustraliaDAL.DataSet1TableAdapters.tblSubCategoryTableAdapter objSubCategory = new AustraliaDAL.DataSet1TableAdapters.tblSubCategoryTableAdapter())
            {
                dt = objSubCategory.GetSubCategoryByCategoryID(CategoryID, IsActive);
            }
            return(dt);
        }