DAL Creation (TableAdapters)

Database Connections

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

Lorem ipsum

SELECT    SiteID, [Address 1], SiteName, [Address 2], City, Status, PostCode
FROM      Site
SELECT    LocationTypeID, LocationTypeCaption
FROM      LocationTypes
SELECT    BuildingID, BuildingName, SiteID
FROM      Buildings
SELECT    LocationID, LocationEasyName, LocationTypeID, BuildingID
FROM      Locations

Well done.

Database Connections