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); }