Question

C#做学生成绩管理系统，可是出现函数fill（）异常。向高手求救。

private void button1_Click(object sender, EventArgs e)//学生登录按钮
{
if (textBox1.Text == "" || textBox2.Text == "")
{
MessageBox.Show("输入登录信息不完整，请重新输入！", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
string Constr = @"server=(local);user id=081842216;pwd=123456;database=20101207-2134";
SqlConnection con = new SqlConnection(Constr);
string SqlStr = "select * from slogin where sno = '" + textBox1.Text + "' and spwd = '" + textBox2.Text + "'";
SqlDataAdapter ada = new SqlDataAdapter(SqlStr,con);
DataTable dt = new DataTable();
ada.Fill(dt);
//int i = dt.Rows.Count;
// if (i >= 1)
//{
Form2 myf = new Form2();
myf.Show();
// Form5 ff = new Form5();
// ff.Show();
// }
// else
{
// MessageBox.Show("用户名或密码不正确，请重新输入！", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}

Answer 1

你的连接语句写的不对，userid登陆不进去