資料繫結技巧：DataReader 繫結至 DataGrid

SqlDataReader dr;
void Page_Load(object sender, System.EventArgs e)
{
    string ConnStr = System.Configuration.ConfigurationSettings.AppSettings["ConnectionSqlServer"];
    string query = "SELECT * FROM Categories";
    SqlCommand myCommand = new SqlCommand(query, new SqlConnection(ConnStr));
    myCommand.Connection.Open();
    dr = myCommand.ExecuteReader();
    DataGrid1.DataSource = dr;
    DataGrid1.DataBind();
    dr.Close();
    myCommand.Connection.Close();
}

來源：https://mjgforever.cnblogs.com/