using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.SqlClient;namespace HypCRM { public partial class frmLogin : Form { public static string H_str_name;//记录登录用户名字 public static string H_str_pwd;//记录登录用户密码 public static string H_str_right;//记录登录用户的权限 HypCRM.BaseClass.BaseOperate boperate = new HypCRM.BaseClass.BaseOperate(); HypCRM.BaseClass.OperateAndValidate opAndvalidate = new HypCRM.BaseClass.OperateAndValidate(); public frmLogin() { InitializeComponent(); } private void frmLogin_Load(object sender, EventArgs e) { opAndvalidate.cboxBind("select UserName from tb_User", "tb_User", "UserName", cboxUName); } private void cboxUName_SelectedIndexChanged(object sender, EventArgs e) { SqlDataReader sqlread = boperate.getread("select UserName,UserRight from tb_User where UserName='"+cboxUName.Text+ "'"); if (sqlread.Read()) { labURight.Text = sqlread["UserRight"].ToString(); H_str_right = labURight.Text;
证明你加载值的时候加载的是对象.你需要把对象转换为.ToString()来试试
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;namespace HypCRM
{
public partial class frmLogin : Form
{
public static string H_str_name;//记录登录用户名字
public static string H_str_pwd;//记录登录用户密码
public static string H_str_right;//记录登录用户的权限
HypCRM.BaseClass.BaseOperate boperate = new HypCRM.BaseClass.BaseOperate();
HypCRM.BaseClass.OperateAndValidate opAndvalidate = new HypCRM.BaseClass.OperateAndValidate(); public frmLogin()
{
InitializeComponent();
} private void frmLogin_Load(object sender, EventArgs e)
{
opAndvalidate.cboxBind("select UserName from tb_User", "tb_User", "UserName", cboxUName);
} private void cboxUName_SelectedIndexChanged(object sender, EventArgs e)
{
SqlDataReader sqlread = boperate.getread("select UserName,UserRight from tb_User where UserName='"+cboxUName.Text+ "'");
if (sqlread.Read())
{
labURight.Text = sqlread["UserRight"].ToString();
H_str_right = labURight.Text;
}
sqlread.Close();
} private void btnLogin_Click(object sender, EventArgs e)
{
SqlDataReader sqlread = boperate.getread("select UserName,UserPwd from tb_user where UserName='"+cboxUName.Text.Trim()+"'and UserPwd='"+txtPwd.Text.Trim()+"'");
sqlread.Read();
if (sqlread.HasRows)
{
H_str_name = cboxUName.Text;
H_str_pwd = txtPwd.Text.Trim();
frmMain fmain = new frmMain();
this.Hide();
fmain.Show(); }
else
{
MessageBox.Show("用户名或密码错误!","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
txtPwd.Text = "";
cboxUName.Focus();
}
sqlread.Close(); } private void btnExit_Click(object sender, EventArgs e)
{
Application.Exit();
} private void frmLogin_FormClosing(object sender, FormClosingEventArgs e)
{
Application.Exit();
}
}
}
this.ComboBox.DisplayMember = "显示字段";
this.cboxUName.ValueMember="ta_User";
this.cboxUName.DisplayMember="UserName";
或者在你上面的代码下面加个
this.cboxUName.ValueMember="ta_User";
this.cboxUName.DisplayMember="UserName";嘿嘿~问题解决了,相当激动!感谢,QQ号码多少呢?加个好友吧!
结贴吧
private void button1_Click(object sender, EventArgs e)
{
SqlConnection myConn = new SqlConnection("strConnection");
SqlDataAdapter sqlda = new SqlDataAdapter("select * from 数据表名称 where 条件 ", myConn);
DataTable dt = new DataTable("tb_User");
sqlda.Fill(dt);
cboxUName.DataSource = dt;
cboxUName.DisplayMember = "UserName";
//cboxUName.ValueMember = ""; // 如果返回值存另一个表,加上这行. 登录验证,感觉没必要
}