How to pass an IP address in connection string?

[ajinkya ragalwa]

I have a database that is stored on a remote machine.
In my application i have used connection string with
IP address of that remote machine. Now, the problem is
every time the remote machine is turned on it has a new
IP address. Is there any way that i can get that newly
generated IP address stored in connection string automatically
every time i try to connect to database.

Here's my connection string :
(Toggle Plain Text)

Data Source=xxx.xxx.xxx.xxx,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;
 

NOTE : Its not a web application.

[maddyromeo]

why don't u try getting IPADDRESS of remote machine into ur application using the remote machines HOSTNAME...

using System.Net;

string reotemachinename = "ur_reotemachinename";
IPHostEntry addresslist = Dns.GetHostByName(reotemachinename );

foreach (IPAddress theaddress in addresslist.AddressList)
{
MessageBox.Show(theaddress.ToString());
}