请帮忙,thx

请看在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.
的错误啊!请高手帮忙啊!
---------------------------------------------------------------

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

注意空格
---------------------------------------------------------------

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

---------------------------------------------------------------

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

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus