sql - 如何获得 SqlCommand ExecuteNonQuery 结果？

Question

为了检查特定用户是否是 db_owner，我执行以下查询:

"select is_rolemember('db_owner', '" & p_userName & "')"

使用 SqlCommand ExecuteNonQuery 方法。

如何获取查询结果？

这是我的代码:

    Dim com As SqlCommand = New SqlCommand(sql, m_connection)               
    com.ExecuteNonQuery()

sql是query，m_connection是connectionString。

Answer 1

您可以使用ExecuteScalar

Executes the query, and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored.

就像 Lucero 说的那样。

例如:

cmd.CommandText = "SELECT COUNT(*) FROM dbo.region";
Int32 count = (Int32) cmd.ExecuteScalar();

返回 Int。