用ListView控件显示数据库中的数据

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