Execute Scalar Example : SqlCommand Select « ADO.Net « C# / CSharp Tutorial

using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Text;

class Program {
    static void Main(string[] args) {
        SqlConnection thisConnection = new
        SqlConnection(@"Server=(local)\sqlexpress;Integrated Security=True;" +
        SqlCommand thisCommand = thisConnection.CreateCommand();
        thisCommand.CommandText = "SELECT COUNT(*) FROM Customers";
        Object countResult = thisCommand.ExecuteScalar();
        Console.WriteLine("Count of Customers = {0}", countResult);


32.21.SqlCommand Select
32.21.1.Simple Query
32.21.2.How to perform a SELECT statement using ADO.NET
32.21.3.Execute Scalar Example
32.21.4.Executing a Query That Does Not Return a Result Set
32.21.5.Executing a Query That Returns Multiple Result Sets with DataSet
32.21.6.Executing a Query That Returns Multiple Result Sets with SqlDataReader
32.21.7.Execute the command to get Scalar value
32.21.9.Get table list