新手问题：列名 'ADDRES' 无效。

j_hunter 2008-05-05 09:53:31

private SqlConnection NewStuConn;
private SqlCommand NewStuComd;
private String NewStuStrConn="Data Source=WWW-F9EEA54BDCA;Initial Catalog=STUDENT;User ID=sa;Pwd=jxlsqd;Integrated Security=False";
private string NewStuStrComd;

private void button6_Click(object sender, EventArgs e)
{

string date = this.birthday.Value.Date.ToString();

NewStuStrComd = "insert into STUDENT(ID,NAME,SEX,BIRTHDAY,BIRTHPLACE,CLASS,ADDRES,TELEPHONE,DEPARTMENT)values" +
"(" + " '" + this.id.Text.ToString().Trim() + " '" + "," + " '" + this.nam.Text.ToString().Trim() + " '" + "," + " '" + this.sex.Text.ToString().Trim() + " '" + "," + " '" + date + " '" + "," + " '" + this.birthplace.Text.ToString().Trim
() + " '" + "," + " '" + this.clsnam.Text.ToString().Trim() + " '" + "," + "'" + this.address.Text.ToString().Trim() + " '" + ", " + " '" + this.telephone.Text.ToString().Trim() + " '" + "," + " '" + this.department.Text.ToString().Trim() + " '" + ")";

NewStuConn = new SqlConnection(NewStuStrConn);
NewStuConn.Open();
NewStuComd = new SqlCommand(NewStuStrComd, NewStuConn);
int Succnum = NewStuComd.ExecuteNonQuery();
if (Succnum > 0) MessageBox.Show("录入成功");
}

能运行成功添加数据就报错：列名 'ADDRES' 无效。

本人数据库菜鸟请大家帮我看看

...全文