how to validate user with (userid,password,IP address)

Question

Hi

I have a problem of login on the basis of IP.

Suppose we have two table

1) contains: Username,Pass

2) Contains : UserName, IP

Single user can have multiple IP Assign

when the user enters Username and Password I have to check out IP address matches with

Ip provided to user in table 2

If Username,Ip,and Pass matches there will be successful login

I have created a function to get IP :

public void GetIPAddress(out string userip)
{
userip = Request.UserHostAddress;
if (Request.UserHostAddress != null)
{
Int64 macinfo = new Int64();
string macsrc = macinfo.ToString("X");
if (macsrc == "0")
{
Label1.Text = userip;
}
}
}

but further I don't know that how to do it

thanks in advance

Sreekanth Reddy · Answer

@Vandana Post Your "GetIpAddress()" function returns the user's current IP Address. Hold it in a variable. ("UserLoggedInIPis") Anyhow you can get the Username & Password from the user input while login. Now Firstly : Step 1 : Check whether user exists with same username & password. (select * from table1 where username='' and password='') Step 2 : If the above query returns data then user exists. Step 3 : Now check the IP address in the second table (select ipaddress from secondtable where username='') (You can use ExecuteScalar) It will fetch the IP address. Store this value in one variable "uservalidIPis" Step 4 : Compare the "UserLoggedInIPis" & "uservalidIPis" If both are same then say user is valid. Else user is logging with another ID.