Datetimestamp Into Db

as you can see i am trying to figure out how to get the users IP address and a datetimestamp into my db. can anyone assist. i tried to comment out the datetimestamp but the iprequest does not work either.

The site i am workingon is papertrailinvites.com the newsleter on the left hand side there. i am trying to collect the email address, ip address and a datetimestamp. inserting the email address works now i just need to get the ipaddress and the datetimestamp in the db

code is below

Thanks 

 

using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["cardsConnectionString1"].ConnectionString)) {

String newemail = Newsletter_Email.Text;

 

SqlCommand cmd = new SqlCommand("INSERT INTO Email (EmailAddress, IPAddress, DateTimeStamp) Values (@EmailAddress, @IPAddress, @DateTimeStamp)", conn);

cmd.CommandType = CommandType.Text;

cmd.Parameters.AddWithValue("@EmailAddRess", newemail);

cmd.Parameters.AddWithValue("@IPAddress", HttpContext.Current.Request.UserHostAddress);

//cmd.Parameters.AddWithValue("@DateTimeStamp",

conn.Open();

cmd.ExecuteNonQuery();