Execute Scalar Example : Database Reader « Database ADO.net « VB.Net

1. VB.Net
2. Database ADO.net
3. Database Reader

Execute Scalar Example

  


Imports System
Imports System.Data
Imports System.Data.SqlClient

    Public Class MainClass

        Public Shared Sub ExecuteScalarExample(ByVal con As IDbConnection)
            Dim com As IDbCommand = con.CreateCommand
            com.CommandType = CommandType.Text
            com.CommandText = "SELECT COUNT(*) FROM HumanResources.Employee;"
            Dim result As Integer = CInt(com.ExecuteScalar)
            Console.WriteLine("Employee count = " & result)
        End Sub
        Public Shared Sub Main()
            Using con As New SqlConnection
                con.ConnectionString = "Data Source=.\sqlexpress;Database=AdventureWorks;Integrated Security=SSPI;"
                con.Open()

                ExecuteScalarExample(con)
                con.Close()
            End Using
        End Sub
    End Class

   
    
  

Related examples in the same category

1.	Use SqlDataReader to read a single row of data
2.	Select top 5 Records in data table
3.	Execute Reader Example
4.	Execute the command and retrieve and XmlReader to access the results