private void button1_Click(object sender, System.EventArgs e)
  {
   try
   {
    //clear the list view
    listView1.Columns.Clear();
    listView1.Items.Clear();

    //Create a connection
    SqlConnection cn = new SqlConnection(@"Data Source=(local);" +
     "Integrated Security=SSPI;database=NorthWind");
    //Create a command object
    SqlCommand cmd= cn.CreateCommand();
    //Specify the stored procedure that is to be executed
    cmd.CommandType= CommandType.StoredProcedure;
    cmd.CommandText="Orders_ByEmployeeId";
    //Create a parameter object to provide the input
    SqlParameter parInput = cmd.Parameters.Add("@EmployeeId", SqlDbType.Int);
    parInput.Direction = ParameterDirection.Input;
    parInput.Value= Convert.ToInt32(textBox1.Text);

    //Open the connection
    cn.Open();

    //execute the command and display the results
    //Create a datareader object
    SqlDataReader dr=cmd.ExecuteReader();
    //Get the colummn names of the datareader and show in the listview's columns
    for (int i=0; i< dr.FieldCount; i++)
    {
                    //ListView控件列的表头
     ColumnHeader c = new ColumnHeader();
     c.Text=dr.GetName(i);  //设定表头的文本
     listView1.Columns.Add(c);
    }
    //Get the values of each row in the datareader and show them in the list view
    ListViewItem itmX;
    while (dr.Read())
    {
     //create the list view item    
     itmX=new ListViewItem();    
     //specify the text and subitems of the list view

     itmX.Text= dr.GetValue(0).ToString();
     for (int i=1 ; i< dr.FieldCount; i++)
     {                
      itmX.SubItems.Add(dr.GetValue(i).ToString());
     }
     //Add the item to the list view's  Items collection
     listView1.Items.Add(itmX);    

    }
    //close the reader
    dr.Close();

    cn.Close();
   }
   catch ( System.Data.SqlClient.SqlException  e1)
   {
    // Display the error message.
    MessageBox.Show ("There was an error in executing the SQL Command. Error Message:" + e1.Message);
   }
  }