Data Look up from SQL Server on a Form

There needs to be a way to pull/show data on the Form using the Data Lookup from a SQL Database. Many Forms we have information that users can pick or we show users in a label the information that come out of SQL Databases instead of having to hardcode the choices into the drop down choice especially when this data can change or not show them important information they might need to make a decision on the form in a label.

EX.
Approved Vendors
Buildings
Information pertaining to that specific user