Asp.Mvc 2.0用户登录实例讲解---(2)用户登录与注销(6)

            SqlConnection con = new SqlConnection(conStr); 
            con.Open(); 
            SqlCommand cmd = new SqlCommand(strUserExist, con); 
            SqlDataAdapter adp = new SqlDataAdapter(cmd); 
            DataSet ds = new DataSet(); 
            adp.Fill(ds); 
            con.Close(); 
            if (ds != null && ds.Tables[0].Rows.Count > 0) 
            { 
                return true; 
            } 
            return false; 
        } 
/// <summary>
        /// 判断用户登录是否成功
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UserLogin(Login model)
        {
            strUserExist = string.Format(strUserExist, model.UserName, model.UserPwd);
            SqlConnection con = new SqlConnection(conStr);
            con.Open();
            SqlCommand cmd = new SqlCommand(strUserExist, con);
            SqlDataAdapter adp = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            adp.Fill(ds);
            con.Close();
            if (ds != null && ds.Tables[0].Rows.Count > 0)
            {
                return true;
            }