IP Address Parameter in ASP.Net

Question

I have a stored procedure that inserts a few columns into a database, IP Address, Name, Comments. I am not sure how to get the ip address of the users machine. Perhaps I am to create a variable of the same type (INT) and then store the IP Address in there. I am kinda of lost on this one.

static int IPAddress()
{ 
get { return Request.UserHostAddress; }; 
}//How do I pass from here into my stored procedure?


                cmdI.Parameters.Add(new SqlParameter("@IPAddress", cmdI));
                cmdI.Parameters.Add(new SqlParameter("@Name", cmdI));
                cmdI.Parameters.Add(new SqlParameter("@Comments", cmdI));

UserHostAddress is a string. What is the data tpe of IPAddress in the database? — Richard Schneider, Jul 04 '11 at 22:21
What about IPv6? See [Returning an IPv4 Address in an IPv6-Enabled Environment](http://www.4guysfromrolla.com/articles/071807-1.aspx) — John Saunders, Jul 04 '11 at 22:27

score 1 · Accepted Answer · edited May 23 '17 at 12:19

1

You need to convert the IP Address from a string to an int; see How to convert an IPv4 address into a integer in C#?

However, I would change the DB to store IP address as a string. This way you will support IPv6.

edited May 23 '17 at 12:19

Community

1
1

answered Jul 04 '11 at 22:26

Richard Schneider

33,296
8
52
68

Thats because you are storing them as an `int`. – Richard Schneider Jul 04 '11 at 23:14
i converted the db to nvarchar(50) and still get it – jpavlov Jul 04 '11 at 23:23

score -1 · Answer 2 · answered Jul 04 '11 at 22:23

-1

IP address is indeed a representation of a 32bit int and can be stored in the db as such

answered Jul 04 '11 at 22:23

Variant

16,291
4
37
64

1

Have a look here: http://stackoverflow.com/questions/461742/how-to-convert-an-ipv4-address-into-a-integer-in-c – Variant Jul 04 '11 at 22:27

IP Address Parameter in ASP.Net

2 Answers2