How to connect to different levels of front end environments (UAT,DEV,PROD, etc) to respective back end environment ?

I want to know if there's any way to programatically set the UAT website to connect to UAT sql server, DEV website to DEV SQL servers.. etc., Please share if you have any information on this. ASP.NET. Thank you.
...