SQL Server数据提供程序中的命令对象SqlCommand(一)创建命令

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;

namespace CommandSql
{
    class Program
    {
        static void Main(string[] args)
        {
            SqlConnection conn = new SqlConnection(@"Data Source=PC2012032219VBB;Initial Catalog=Northwind;Integrated Security=True");
           
            //利用构造函数来创建Command对象
            //SqlCommand cmd = new SqlCommand();
            //Console.WriteLine("Command created.");

            //设置Connection属性
            //cmd.Connection = conn;
            //Console.WriteLine("Connected command to this connection.");

            //可以用一条语句来实现
            SqlCommand cmd = conn.CreateCommand();
            Console.WriteLine("Command created and Connected command to this connection");

            //设置Command对象的文本
            cmd.CommandText = @"select count(*) from employees";
            Console.WriteLine("Ready to execute SQL:{0}", cmd.CommandText);

            try
            {
                conn.Open();
            }
            catch (SqlException ex)
            {
                Console.WriteLine(ex.ToString());
            }
            finally
            {
                conn.Close();
                Console.WriteLine("Connection closed.");
            }
            Console.ReadKey();
        }
    }
}