Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Execute Scalar Example

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;" +                   "Database=northwind");         thisConnection.Open();         SqlCommand thisCommand = thisConnection.CreateCommand();         thisCommand.CommandText = "SELECT COUNT(*) FROM Customers";         Object countResult = thisCommand.ExecuteScalar();         Console.WriteLine("Count of Customers = {0}", countResult);         thisConnection.Close();     } }