public zp_User GetUserAllInfo(string userID)
{
zp_User be = new zp_User();
sql = "select user_ID,user_Email,user_IsOpen,user_Name,user_Pwd,user_Type,user_RegistTime,user_LoginNum,user_LastLoginTime from zp_User where user_ID=@user_ID "; SqlDataReader dr = SqlHelper.ExecuteReader(sql, CommandType.Text, new SqlParameter("@user_ID", userID));
if (dr.Read())
{
be.User_ID = Convert.ToInt32(dr["user_ID"].ToString());
be.User_Email = dr["user_Email"].ToString();
be.User_IsOpen = Convert.ToInt32(dr["user_IsOpen"].ToString());
be.User_Name = dr["user_Name"].ToString();
be.User_Pwd = dr["user_Pwd"].ToString();
be.User_Type = Convert.ToInt32(dr["user_Type"].ToString());
be.User_RegistTime = dr["user_RegistTime"].ToString();
be.User_LastLoginTime = dr["user_LastLoginTime"].ToString();
be.User_LoginNum = Convert.ToInt32(dr["user_LoginNum"].ToString());
}
dr.Close();
dr.Dispose();
return be;最后一个user_LoginNum 的值取不出,如果将user_LoginNum换成user_ID 反而可以取到ID;为什么登陆的次数取不出?
{
zp_User be = new zp_User();
sql = "select user_ID,user_Email,user_IsOpen,user_Name,user_Pwd,user_Type,user_RegistTime,user_LoginNum,user_LastLoginTime from zp_User where user_ID=@user_ID "; SqlDataReader dr = SqlHelper.ExecuteReader(sql, CommandType.Text, new SqlParameter("@user_ID", userID));
if (dr.Read())
{
be.User_ID = Convert.ToInt32(dr["user_ID"].ToString());
be.User_Email = dr["user_Email"].ToString();
be.User_IsOpen = Convert.ToInt32(dr["user_IsOpen"].ToString());
be.User_Name = dr["user_Name"].ToString();
be.User_Pwd = dr["user_Pwd"].ToString();
be.User_Type = Convert.ToInt32(dr["user_Type"].ToString());
be.User_RegistTime = dr["user_RegistTime"].ToString();
be.User_LastLoginTime = dr["user_LastLoginTime"].ToString();
be.User_LoginNum = Convert.ToInt32(dr["user_LoginNum"].ToString());
}
dr.Close();
dr.Dispose();
return be;最后一个user_LoginNum 的值取不出,如果将user_LoginNum换成user_ID 反而可以取到ID;为什么登陆的次数取不出?
查看dr["user_LoginNum"]是否有值
//如果在WEB端的话Response.Write(dr["user_LoginNum"].ToString());be.User_LoginNum = Convert.ToInt32(dr["user_LoginNum"].ToString());
select user_ID,user_Email,user_IsOpen,user_Name,user_Pwd,user_Type,user_RegistTime,user_LoginNum,user_LastLoginTime from zp_User where user_ID=@user_ID
结果是什么
user_LoginNum 有值吗。