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