DataTable + DataReader + DataGridView 使用方法

  

   DataTable + DataReader + DataGridView 使用方法
 
   using System.Data.SqlClient;
 
   private void CreateDataGridView()
   {
 
      String connectionString1 = "Data Source=.\\SqlExpress; Initial Catalog=Soccer; Integrated Security=SSPI";
      SqlConnection con1 = new SqlConnection(connectionString1);
      con1.Open();
 
      String SqlString1 = "SELECT Player_ID, Player_Name FROM dbo.Player";
 
      SqlCommand cmd1 = new SqlCommand(SqlString1, con1);
 
      SqlDataReader dr = cmd1.ExecuteReader();
 
      DataTable SoccerDataTable = new DataTable();
 
      SoccerDataTable.Columns.Add();
      SoccerDataTable.Columns[0].ColumnName = "Soccer ID";
 
      SoccerDataTable.Columns.Add();
      SoccerDataTable.Columns[1].ColumnName = "Soccer Name";
 
      int i = 0;
 
      if(dr.HasRows)
      {
         while(dr.Read())
         {
            SoccerDataTable.Rows.Add();
            SoccerDataTable.Rows[i]["Soccer ID"] = dr.GetInt32(0);
            SoccerDataTable.Rows[i]["Soccer Name"] = dr.GetString(1);
 
            i++;
         }
      }
 
      this.dataGridView1.DataSource = SoccerDataTable;
 
      cmd1.Dispose();
      con1.Dispose();
 
   }