....... strSql = "Delete from news where id=" & intId cmd = New OleDbCommand(strSql, con) con.Open() Try intCount = cmd.ExecuteNonQuery Catch ex As Exception lblErrMessage.Text = ex.Message Finally con.Close() End Try ....... 你的程序中@id从哪里来的??呵呵!上面的应该可以吧,你试一下
strSql = "DELETE FROM 表名 WHERE id=@id";另外,看看你的表名有没有问题!
nk912114 我同样觉的你的办法可以 但还是不行 intId 来自于 Private Sub dlstNews_DeleteCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataListCommandEventArgs) Handles dlstNews.DeleteCommand Dim intId As Integer intId = CInt(dlstNews.DataKeys(e.Item.ItemIndex)) bindNews_delete(intId) End Sub 对了 我用的是access 数据库
哦!access数据库不支持delete from ... 请写成 strSql = "Delete from news where id="+intId
strSql = "Delete from news where id=" & intId
cmd = New OleDbCommand(strSql, con)
con.Open()
Try
intCount = cmd.ExecuteNonQuery
Catch ex As Exception
lblErrMessage.Text = ex.Message
Finally
con.Close()
End Try
.......
你的程序中@id从哪里来的??呵呵!上面的应该可以吧,你试一下
Private Sub dlstNews_DeleteCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataListCommandEventArgs) Handles dlstNews.DeleteCommand
Dim intId As Integer
intId = CInt(dlstNews.DataKeys(e.Item.ItemIndex))
bindNews_delete(intId)
End Sub
对了 我用的是access 数据库
请写成
strSql = "Delete from news where id="+intId
上下没区别啊 就是delete from 和Delete from 有区别吗?
你换一个名字就可以了比如说RevordID?=
试试吧