Link lb = new Link();
lb.lk();
string selectCmd;
selectCmd = "select * from user where username='"+tb_user.Text+"'+userpass='"+tb_pwd.Text+"'";
SqlConnection conn;
SqlCommand cmd;
SqlDataReader reader;
conn = new SqlConnection(lb.lk());
conn.Open();
cmd = new SqlCommand(selectCmd,conn);
reader = cmd.ExecuteReader();
if(! reader.Read())
{
MessageBox.Show("??入正?的用?名和密?");
}
else
{
Form2 f = new Form2();
f.Show();
cmd.Connection.Close();
}
这个是个用户登录窗口中的代码,运行到reader = cmd.ExecuteReader();就出错,大家帮解决一下阿 谢谢阿!!急急
lb.lk();
string selectCmd;
selectCmd = "select * from user where username='"+tb_user.Text+"'+userpass='"+tb_pwd.Text+"'";
SqlConnection conn;
SqlCommand cmd;
SqlDataReader reader;
conn = new SqlConnection(lb.lk());
conn.Open();
cmd = new SqlCommand(selectCmd,conn);
reader = cmd.ExecuteReader();
if(! reader.Read())
{
MessageBox.Show("??入正?的用?名和密?");
}
else
{
Form2 f = new Form2();
f.Show();
cmd.Connection.Close();
}
这个是个用户登录窗口中的代码,运行到reader = cmd.ExecuteReader();就出错,大家帮解决一下阿 谢谢阿!!急急
{
reader = cmd.ExecuteReader();
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);//看是什么异常信息
}
selectCmd = "select * from user where username='"+tb_user.Text+"' and userpass='"+tb_pwd.Text+"'";
selectCmd = string.Format("select * from user where username='{0}' and userpass='{1}'", tb_user.Text, tb_pwd.Text);这样清晰,再复杂些也没关系,刚开始就要养成好习惯。