Csharp/CSharp Tutorial/ADO.Net/Count — различия между версиями

Материал из .Net Framework эксперт
Перейти к: навигация, поиск
м (1 версия)
 
(нет различий)

Текущая версия на 15:19, 26 мая 2010

Do a row count using SqlCommand

<source lang="csharp">using System; using System.Data; using System.Data.SqlClient; class CommandScalar {

  static void Main()
  {
     SqlConnection conn = new SqlConnection("server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI;");
     string sql = @"select count(*) from employee";
     SqlCommand cmd = new SqlCommand(sql, conn);
     Console.WriteLine("Command created and connected.");
     try
     {
        conn.Open();
        Console.WriteLine("Number of Employees is {0}", cmd.ExecuteScalar());
     }
     catch (SqlException ex)
     {
        Console.WriteLine(ex.ToString());
     }
     finally
     {
        conn.Close();
        Console.WriteLine("Connection Closed.");
     }
  }

}</source>

Command created and connected.
Number of Employees is 4
Connection Closed.