请帮忙，thx

[hailinshan]

请看在c＃中连接sql2000后的语句：
sqlDeleteCommand1.CommandText="DELETE FROM ADDRESSswheresNAME='" +TextBox5.Text+"'";
是否有错啊?我run后会提示：
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll

Additional information: System error.
的错误啊！请高手帮忙啊！

[hjhing]

sqlDeleteCommand1.CommandText="DELETE FROM ADDRESS where NAME='" + TextBox5.Text+ "'";

注意空格

[pengdali]

TextBox5.Text="'"+TextBox5.Text+"'";
sqlDeleteCommand1.CommandText="DELETE FROM ADDRESSswheresNAME=" +TextBox5.Text;

[hailinshan]

不行啊！该源程序如下,请看看好么？ 谢谢大哥大姐了,


private void button2_Click(object sender, System.EventArgs e)
{
//sqlCommand.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();

　　//声明Sql Command类对象

　　this.sqlDataAdapter1.DeleteCommand = sqlDeleteCommand1;

　　//sqlDeleteCommand1.CommandText="DELETE FROM student WHERE sno='"+textBox6.Text+"'";
//sqlDeleteCommand1.CommandText="DELETE FROM student WHERE sname=xie";
　　//SQL语句
sqlDeleteCommand1.CommandText="DELETE FROM student where sno='" + textBox6.Text+ "'";


　　sqlDeleteCommand1.Connection = this.sqlConnection1;

　　//声明使用的数据连接

　　sqlDeleteCommand1.Connection.Open();

　　sqlDeleteCommand1.ExecuteNonQuery();

　　//执行该SQL语句

　　sqlDeleteCommand1.Connection.Close();
//sqlConnection1.Close();
}

[hailinshan]

急ing

[KnowLittle]

你把这个变量print出来，一下就能发现问题所在sqlDeleteCommand1.CommandText