How to set connectionstring value from .xml file in asp.net

https://social.msdn.microsoft.com/Forums/vstudio/en-US/0a776159-3de0-4893-b214-93799163d121/read-connection-string-from-xml-file-c-aspnet?forum=csharpgeneral

 

 

Above link hope you help

thanks 

var connection = new SqlConnection(string.Format("Data Source={0},{1};Initial Catalog={2};User Id={3};Password={4};"

, serverName,serverport,database,username,password));