数据库操作代码
/// <summary>
/// 查询所有在职用户
/// </summary>
const string sqlselect2 = "SELECT UserID,UserName FROM Users Where TypeID=1";
public DataSet GetAllInUsers()
{
DataSet ds = SQLHelper.ExDataSet(CommandType.Text, Users.sqlselect2, null);
return ds;
}
BLL层 public DataSet GetAllInUsers()
{
return dal.GetAllInUsers();
}
private void DropDownListBind()
{
BLL.Users Usersbll = new BLL.Users();
DataSet ds1 = Usersbll.GetAllInUsers();
this.UserName.DataSource = ds1.Tables[0];
this.UserName.DataTextField = "UserName";
DataSet ds2 = Usersbll.GetUserID(this.UserName.DataTextField.ToString().Trim());
this.UserName.DataValueField = "UserID";//这种写法会将value的ID值作为用户的ID值,会造成用户登录失败。
this.UserName.DataBind();
}选择用户名登陆后,实际登录名和选择的不一样,代码跟踪后发现,dropdownlist的DataValueField的值和UserID不一致,不知道大神们有什么好的办法解决,小弟在此谢过
/// <summary>
/// 查询所有在职用户
/// </summary>
const string sqlselect2 = "SELECT UserID,UserName FROM Users Where TypeID=1";
public DataSet GetAllInUsers()
{
DataSet ds = SQLHelper.ExDataSet(CommandType.Text, Users.sqlselect2, null);
return ds;
}
BLL层 public DataSet GetAllInUsers()
{
return dal.GetAllInUsers();
}
private void DropDownListBind()
{
BLL.Users Usersbll = new BLL.Users();
DataSet ds1 = Usersbll.GetAllInUsers();
this.UserName.DataSource = ds1.Tables[0];
this.UserName.DataTextField = "UserName";
DataSet ds2 = Usersbll.GetUserID(this.UserName.DataTextField.ToString().Trim());
this.UserName.DataValueField = "UserID";//这种写法会将value的ID值作为用户的ID值,会造成用户登录失败。
this.UserName.DataBind();
}选择用户名登陆后,实际登录名和选择的不一样,代码跟踪后发现,dropdownlist的DataValueField的值和UserID不一致,不知道大神们有什么好的办法解决,小弟在此谢过
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货