Try this
protected void ip_addr()
{
string sIPAddress = null;
sIPAddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
if (string.IsNullOrEmpty(sIPAddress))
sIPAddress =Request.ServerVariables["REMOTE_ADDR"];
SqlConnection con = new SqlConnection(conn);
try
{
con.Open();
string str = "insert into IPADDR_LOGIN(ipaddr,date_time,uname) values('" + Convert.ToString(sIPAddress) + "','" + Convert.ToString(DateTime.Now) + "','" + txt_usr.Text.ToString().Trim() + "')";
SqlCommand cmd = new SqlCommand(str, con);
cmd.ExecuteNonQuery();
}
finally
{
con.Close();
}
}