如何检索从 SQL Server 影响到 VB.NET 的行数?
基本上我是通过运行时检索程序中的所有数据，我想知道如何检索更新后受影响的行数，以便我可以通过 VB.NET 提示用户有关它
Basically I'm retrieving all the data in my program through runtime, I was wondering how will I retrieve the number of rows affected after an update so I could prompt the user about it through VB.NET
我实际做的是，更新后，如果没有其他行更新，则用户无法再点击按钮
What I'm actually doing is, after an update, if there are no other rows updated then the user can no longer click on the button
推荐答案
通过使用 ExecuteNonQuery，它将不返回任何行，任何输出参数或映射到参数的返回值都填充了数据.
By using ExecuteNonQuery, it will returns no rows, any output parameters or return values mapped to parameters are populated with data.
对于 UPDATE、INSERT 和 DELETE 语句，返回值是受命令影响的行数.
For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command.
您可以像这样提示用户
Dim RowsAffected as Integer = Command.ExecuteNonQuery()
MsgBox("The no.of rows effected by update query are " & RowsAffected.ToString)
相关文章