开发者

error on ExecuteNoQuery()

开发者 https://www.devze.com 2023-01-01 04:53 出处:网络
i\'am trying to update a row in a table using : 开发者_如何学编程command.ExecuteNoQuery() it\'s not giving me an error but it\'s not updating the row

i'am trying to update a row in a table using :

开发者_如何学编程command.ExecuteNoQuery()

it's not giving me an error but it's not updating the row

This is my code :

Dim req As String = "Update Table Set Id= 5"
Dim cmd As New OleDb.OleDbCommand(req, connect())
cmd.ExecuteNonQuery()
disconnect()

thanks


Make sure that ID isn't an IDENTITY column.


the problem is that the query was too slow with MS Access.

Now it's working fine MS SQL Server.

0

精彩评论

暂无评论...
验证码 换一张
取 消