DataTable + DataReader + DataGridView 使用方法 |
using System.Data.SqlClient; private void CreateDataGridView() { 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.Columns.Add(); SoccerDataTable.Columns[0].ColumnName = "Soccer ID"; SoccerDataTable.Columns.Add(); SoccerDataTable.Columns[1].ColumnName = "Soccer Name"; int i = 0; if(dr.HasRows) { while(dr.Read()) { SoccerDataTable.Rows.Add(); SoccerDataTable.Rows[i]["Soccer ID"] = dr.GetInt32(0); SoccerDataTable.Rows[i]["Soccer Name"] = dr.GetString(1); i++; } } this.dataGridView1.DataSource = SoccerDataTable; cmd1.Dispose(); con1.Dispose(); } |