调用存储过程

using System;
using System.Data;
using System.Data.SqlClient;

/*
	create procedure sp_Select_All_Employees
	as
	  select
		employeeid,
		firstname,
		lastname
	  from
		employees
*/
namespace Chapter6
{
    class CallSp1
    {
        static void Main()
        {
           
            SqlConnection conn = null;
            SqlDataReader rdr = null;
            try
            {
                 // create connection
                 conn = new SqlConnection
                                        (@"server = .;
                                        integrated security = true;
                                        database = northwind");

                // open connection
                conn.Open();
                
                // create command
                 SqlCommand cmd = conn.CreateCommand();

                // specify stored procedure to  execute
                //enum CommandType {Text, StoredProcedure, TableDirect}
                 cmd.CommandType = CommandType.StoredProcedure;
                //指定StoredProcedure名
                 cmd.CommandText = "sp_Select_All_Employees";

                 // execute command
                 rdr = cmd.ExecuteReader();

                 // Process the result set
                 while (rdr.Read())
                 {
                     Console.WriteLine(
                     "{0} {1} {2}"
                     ,rdr[0].ToString().PadRight(5)
                     ,rdr[1].ToString()
                     ,rdr[2].ToString());                
                 }
                 
            }
            catch (SqlException ex)
            {
                 Console.WriteLine(ex.ToString());
            }
            finally
            {
                rdr.Close();
                conn.Close();
            }
        }
    }
}