DataGridView + DataReader 使用方法

 

   DataGridView + DataReader 使用方法
 
   using System.Data.SqlClient;
 
   private void button1_Click(object sender, EventArgs e)
   {
      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.Load(dr);
      SoccerDataTable.Columns[0].ColumnName = "Soccer ID";
      SoccerDataTable.Columns[1].ColumnName = "Soccer Name";
 
      this.dataGridView1.DataSource = SoccerDataTable;
 
      cmd1.Dispose();
      con1.Dispose();
   }