Executing Commands - Beginning C# 2008 Databases: From Novice to Professional - page 222

// define scalar query
string sqlqry = @"
select
count(*)
from
employees
";
// define insert statement
string sqlins = @"
insert into employees
(
firstname,
lastname
)
values('Zachariah', 'Zinn')
";
// define delete statement
string sqldel = @"
delete from employees
where
firstname = 'Zachariah'
and
lastname = 'Zinn'
";
// create commands
SqlCommand cmdqry = new SqlCommand(sqlqry, conn);
SqlCommand cmdnon = new SqlCommand(sqlins, conn);
try
{
// open connection
conn.Open();
// execute query to get number of employees
Console.WriteLine(
"Before INSERT: Number of employees {0}\n"
, cmdqry.ExecuteScalar()
);