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