SQLDataAdapter Return 出 DataTable 使用方法

 
SQLDataAdapter Return 出 DataTable 使用方法
 

   Deafult.aspx
 
   using System.Configuration;
   using System.Text;
   using System.Data;
   using System.Data.SqlClient;
 
   private DataTable GetTeamAdapter()
   {
 
      String connectionString1 = ConfigurationManager.ConnectionStrings["Conn_Str"].ConnectionString;
      SqlConnection con1 = new SqlConnection(connectionString1);
      con1.Open();
 
      StringBuilder sb = new StringBuilder();
      sb.Append("SELECT * FROM Team;");
 
      SqlDataAdapter Adapter = new SqlDataAdapter(sb.ToString(), con1);
      DataSet ds = new DataSet();
 
      Adapter.Fill(ds);
 
      ds.Tables[0].TableName = "Team";
      ds.Tables[0].Columns[0].ColumnName = "Team ID";
      ds.Tables[0].Columns[1].ColumnName = "Team Name";
      ds.Tables[0].Columns[2].ColumnName = "League ID";
 
      con1.Close();
      con1.Dispose();
 
      return ds.Tables[0];
 
   }