lastinsertid mysql_mysql错误，帮忙看看

“/”应用程序中的服务器错误。--------------------------------------------------------------------------------YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondsto...

“/”应用程序中的服务器错误。

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

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'danxuanti_id=5' at line 1

说明: 执行当前 Web 请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: MySql.Data.MySqlClient.MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'danxuanti_id=5' at line 1

源错误:

行 84: Dim cmd2 As New MySqlCommand(str,conn)

行 85: conn.Open()

行 86: Dim dr2 As MySqlDataReader = cmd2.ExecuteReader()

行 87: DataList_danxuanti.DataSource = dr2

行 88: DataList_danxuanti.DataBind()

源文件: c:\inetpub\wwwroot\kaoshi.aspx.vb 行: 86

堆栈跟踪:

[MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'danxuanti_id=5' at line 1]

MySql.Data.MySqlClient.MySqlStream.OpenPacket() +238

MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) +60

MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() +49

MySql.Data.MySqlClient.MySqlDataReader.NextResult() +724

MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +930

MySql.Data.MySqlClient.MySqlCommand.ExecuteReader() +6

students_kaoshi.shengchengshiti_danxuanti() in c:\inetpub\wwwroot\kaoshi.aspx.vb:86

students_kaoshi.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\kaoshi.aspx.vb:310

System.Web.UI.Control.OnLoad(EventArgs e) +99

System.Web.UI.Control.LoadRecursive() +50

System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

代码是

我在命令提示符下执行mysql> select * from danxuanti where danxuanti_id=7 or danxuanti_id=5 or danxuanti_id=6;

返回数据正常啊！

Dim str As String

str = "select * from duoxuanti where duoxuanti_id=" & tihao_duoxuanti(1)

For i = 2 To nn

str &= "or duoxuanti_id=" & tihao_duoxuanti(i)

Next

Dim cmd2 As New MySqlCommand(str, conn)

conn.Open()

Dim dr2 As MySqlDataReader = cmd2.ExecuteReader()

DataList_duoxuanti.DataSource = dr2

DataList_duoxuanti.DataBind()

conn.Close()

End Sub

展开