Csharp/CSharp Tutorial/ADO.Net/Count — различия между версиями
Admin (обсуждение | вклад) м (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.