DataGridView + DataReader 使用方法 |
using System.Data.SqlClient; private void button1_Click(object sender, EventArgs e) { 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.Load(dr); SoccerDataTable.Columns[0].ColumnName = "Soccer ID"; SoccerDataTable.Columns[1].ColumnName = "Soccer Name"; this.dataGridView1.DataSource = SoccerDataTable; cmd1.Dispose(); con1.Dispose(); } |