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
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 |