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(); } } }