string connString = "Data Source=(local);Initial catalog=News_Students;User id=sa;Password=admin";
SqlConnection conn = new SqlConnection();
conn.ConnectionString = connString;
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select UserName,UserPassword,Description from UserInfo";
cmd.CommandText += "where UserId =" + ID;
cmd.Connection = conn;
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
this.TextName.Text = reader.GetString(0);
this.TextPassword.Text = reader.GetString(1);
this.TextDes.Text = reader.GetString(2);
reader.Close();
conn.Close();提示:
SqlDataReader reader = cmd.ExecuteReader();
'=' 附近有语法错误。
SqlConnection conn = new SqlConnection();
conn.ConnectionString = connString;
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select UserName,UserPassword,Description from UserInfo";
cmd.CommandText += "where UserId =" + ID;
cmd.Connection = conn;
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
this.TextName.Text = reader.GetString(0);
this.TextPassword.Text = reader.GetString(1);
this.TextDes.Text = reader.GetString(2);
reader.Close();
conn.Close();提示:
SqlDataReader reader = cmd.ExecuteReader();
'=' 附近有语法错误。
最后少了个空格
where 前面加空格