SQLDataReader Return 出 DataTable 使用方法

 
SQLDataReader Return 出 DataTable 使用方法
 

   Default.aspx
 
   using System.Configuration;
   using System.Text;
   using System.Data;
   using System.Data.SqlClient;
 
   private DataTable GetTeamReader()
   {
 
      String connectionString1 =
      ConfigurationManager.ConnectionStrings["Conn_Str"].ConnectionString;
      SqlConnection con1 =
      new SqlConnection(connectionString1);
      con1.Open();
 
      StringBuilder sb = new StringBuilder();
      sb.Append("SELECT * FROM Team;");
 
      SqlCommand cmd1 = new SqlCommand(sb.ToString(), con1);
      SqlDataReader dr = cmd1.ExecuteReader();
 
      DataTable SoccerTeamDataTable = new DataTable();
      SoccerTeamDataTable.Load(dr);
      SoccerTeamDataTable.Columns[0].ColumnName = "Team ID";
      SoccerTeamDataTable.Columns[1].ColumnName = "Team Name";
      SoccerTeamDataTable.Columns[2].ColumnName = "League ID";
 
      con1.Close();
      con1.Dispose();
 
      return SoccerTeamDataTable;
 
   }