OleDbCommand.ExecuteScalar : OleDbCommand « System.Data.OleDb « C# / C Sharp by API

1. C# / C Sharp by API
2. System.Data.OleDb
3. OleDbCommand

OleDbCommand.ExecuteScalar

  

using System;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;

class MainClass
{
    static void Main(string[] args)
    {
        string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\Northwind.mdb";
        OleDbConnection conn = new OleDbConnection(ConnectionString);

        conn.Open();
        OleDbCommand cmd = new OleDbCommand();
        cmd.CommandText = "SELECT Count(*) FROM Customers";
        cmd.Connection = conn;

        int counter = (int)cmd.ExecuteScalar();
        
        Console.WriteLine("Total rows returned are :" + counter.ToString());
               
        conn.Close();                  
    }
}

   
    
  

Related examples in the same category