//判断用户密码是否可以登录
public static bool CheckUser(string name,string pwd)
{
bool result = False;
SqlConnection conn = new SqlConnection("连接字符串");
string sql = "select count(*) from User where UserName=@UserName and Password=@Password";
SqlCommand cmd = new SqlCommand(sql,conn);
cmd.Parameters.AddWithValue("@UserName",name);
cmd.Parameters.AddWithValue("@Password",pwd);
conn.open();
result = Int32.Part(cmd.ExecuteScalar()) > 0;
return result;
}