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