登录问题,谢谢大侠们

[qq756791021]

private void button1_Click(object sender, EventArgs e)
{
Login();
}
private void Login()
{
string sql;
sql = "Select * from [User] where account='+textBox1.Text.Trim()+'";
SqlConnection sqlcon = new SqlConnection("server=.;database=Example;Uid=sa;Pwd=123456");
SqlCommand sqlcom = new SqlCommand(sql, sqlcon);
sqlcon.Open();
SqlDataReader dr = sqlcom.ExecuteReader();
string uid ="";
string pwd ="";
if (dr.Read())
{
uid = dr["account"].ToString();//调试出来这里面没值，不知道怎么弄
pwd = dr["passward"].ToString();
}
if (pwd == textBox2.Text.Trim())
{
MessageBox.Show("登录成功");
}
else
{
MessageBox.Show("密码错误");
}
}

[幕夜]

sql = "Select * from [User] where account='+textBox1.Text.Trim()+'";你这个应该错了吧
应该是sql = "Select * from [User] where account='"+textBox1.Text.Trim()+"'";

[saraphwind163]

[Quote=引用 1 楼 feng03 的回复:]
sql = "Select * from [User] where account='+textBox1.Text.Trim()+'";你这个应该错了吧
应该是sql = "Select * from [User] where account='"+textBox1.Text.Trim()+"'";
[/Quote]
+1

[qq756791021]

谢谢大侠们,菜鸟不懂只能多问了