public DataTable GetSubCategoryAllByCategoryID(int CategoryID) { DataTable dt = new DataTable(); using (AustraliaDAL.DataSet1TableAdapters.tblSubCategoryTableAdapter objSubCategory = new AustraliaDAL.DataSet1TableAdapters.tblSubCategoryTableAdapter()) { dt = objSubCategory.GetSubCategoryAllByCategoryID(CategoryID); } return(dt); }