帮忙看一下出错原因!!!!!!
cyndi 2003-03-27 08:11:27 web service:
[WebMethod(Description="用户注册")]
public bool Register()
{
string myConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("..//QQ//netdb.mdb");
OleDbConnection myConnection=new OleDbConnection(myConnectionString);
myConnection.Open ();
//写入信息
string strInsert="DELETE * FROM user WHERE id='6000'";
OleDbCommand myInsert=new OleDbCommand (strInsert,myConnection);
myInsert.ExecuteNonQuery ();
myConnection.Close ();
return true;
}
出错信息是:
System.Web.Services.Protocols.SoapException: 服务器无法处理请求。 ---> System.Data.OleDb.OleDbException: FROM 子句语法错误。 at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at QQ.Service1.Register(String[] user) in d:\inetpub\wwwroot\net\qq\qq.asmx.cs:line 104 --- 内部异常堆栈跟踪的结尾 ---