如何检索从 SQL Server 影响到 VB.NET 的行数? [英] How do I retrieve the number of rows affected from SQL Server to 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)

这篇关于如何检索从 SQL Server 影响到 VB.NET 的行数?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！