C#操作SqlDataReader对象

最新推荐文章于 2024-05-15 14:48:22 发布

放开那段代码让我来

最新推荐文章于 2024-05-15 14:48:22 发布

阅读量1w

点赞数 2

分类专栏： net 文章标签： net

本文链接：https://blog.csdn.net/u014424282/article/details/76532178

版权

net 专栏收录该内容

19 篇文章 0 订阅

订阅专栏

  public M_Users UserLogin(M_Users muser, out string roelname)
        {
          SqlDataReader dr=Sqlhelper.ExecuteReader(Common.constr,"select * from Users join Roles on Users.roleid=Roles.roleid where useremail=@useremail and userpassword=@userpassword",
                new SqlParameter("@useremail", muser.Useremail),
                new SqlParameter("@userpassword", muser.Userpassword));
          if (dr.Read())
          {
              muser.Userid = int.Parse(dr["userid"].ToString());
              muser.Username = dr["username"].ToString();
              muser.Useremail = dr["useremail"].ToString();
              muser.Photo = dr["photo"].ToString();
              muser.Sex = bool.Parse(dr["sex"].ToString());
              muser.Age = int.Parse(dr["age"].ToString());
              muser.Qq = dr["qq"].ToString();
              muser.Lastlogindate = DateTime.Parse(dr["lastlogindate"].ToString());
              roelname = dr["rolename"].ToString();
              return muser;
          }
          else
          {
              roelname = "";
              return null;
          }
        }