• What is the 'best' way to auto populate "UDF" City and "UDF" State from "UDF" Zip Code

    I am currently using the following (which works), but is there a 'better' way to do this? (I don't like hardcoding the connection string with username and password.) '-------------------------------------------------------------------------------…