这是哪出错了,郁闷
页面上有一个button1; 两个textbox, 分别命名为uname,pwd, 也就是一个用户登陆的页面,有如下代码 string a = uname.Text;
string mystring = "server=localhost;database=course;Trusted_Connection=yes";
SqlConnection conn = new SqlConnection(mystring);
conn .Open ();
string sel = "select * from grade where uid=" + a;
SqlCommand comm = new SqlCommand(sel, conn);
SqlDataReader dr = comm.ExecuteReader();
while (dr.Read())
{
if (uname.Text==dr["uid"].ToString ())
{
if (pwd.Text == dr["pwd"].ToString())
Label1.Text = dr["name"].ToString ();
}
}
说明:在数据库course中有一个名为grade的表,表中有一列为uid,一列为pwd,有条记录的uid 值为xiaoyang,pwd值为24549984
运行时,在uname中输入xiaoyang,在pwd中输入24549984,总是出错,出错信息为“列名xiaoyang无效,”这是怎么回事呢