asp.net - 将SQL计数结果存储到变量VB中

Question

我试图获取 SQL 语句的结果并将其存储在 vb 中的整数变量“count”中，以便可以将其显示在我的网站上，向用户显示总的打开记录:

    SELECT COUNT (recordID) FROM [tbl_Records] WHERE [Status] = 'Open'

感谢任何帮助。

Answer 1

试试这个:

Public Function GetOpenRecordCount(ByVal connString As String) As Integer
    Dim RecordCount As Int32 = 0
    Dim sql As String = "SELECT COUNT (recordID) FROM [tbl_Records] WHERE [Status] = 'Open'"

    Using conn As New SqlConnection(connString)
        Dim cmd As New SqlCommand(sql, conn)
        Try
            conn.Open()
            RecordCount = Convert.ToInt32(cmd.ExecuteScalar())
        Catch ex As Exception
            Console.WriteLine(ex.Message)
        End Try
    End Using

    Return RecordCount
End Function