public bool CheckLogin(string userName, string password)
{
bool flag = false;
if (userName.Equals("") || password.Equals(""))
{
return;
}
SqlConnection conn=null;
try
{
conn = new SqlConnection("连接字符串");
conn.Open();
SqlCommand cmd = new SqlCommand("select count(1) from UserInfo where UserName=@UserName and Password=@Password", conn);
cmd.Parameters.Add(new SqlParameter("@UserName", SqlDbType.VarChar, 40));
cmd.Parameters["UserName"].Value = userName;
cmd.Parameters.Add(new SqlParameter("@Password", SqlDbType.VarChar, 40));
cmd.Parameters["Password"].Value = password;
if (cmd.ExecuteScalar().ToString() != "0")
{
flag = true;
}
}
catch
{ }
finally
{
conn.Close();
}
}
{
bool flag = false;
if (userName.Equals("") || password.Equals(""))
{
return;
}
SqlConnection conn=null;
try
{
conn = new SqlConnection("连接字符串");
conn.Open();
SqlCommand cmd = new SqlCommand("select count(1) from UserInfo where UserName=@UserName and Password=@Password", conn);
cmd.Parameters.Add(new SqlParameter("@UserName", SqlDbType.VarChar, 40));
cmd.Parameters["UserName"].Value = userName;
cmd.Parameters.Add(new SqlParameter("@Password", SqlDbType.VarChar, 40));
cmd.Parameters["Password"].Value = password;
if (cmd.ExecuteScalar().ToString() != "0")
{
flag = true;
}
}
catch
{ }
finally
{
conn.Close();
}
}
首先要登录不同的网站必须有不同的ip地址解析。本地的登陆想要解析网上面x个域名、地址,简直是想做个域名服务器,太夸张了。
如果连服务器都找不到,更谈不上用户名和地址问题啦。