如何加载的GridView使用SqlDataReader

dbCommand = new SqlCommand("SELECT Game.GameId,Location,Date,Time FROM Game,Results WHERE Game.GameId = Results.GameId AND CountryId ='" + cboCountryName.SelectedValue + "'", dbConnection);

 

            if (dbConnection.State = ConnectionState.Closed)

            {

                dbConnection.Open();

            }

            dbread = dbCommand.ExecuteReader();

            while (dbread.Read())

            {

              

            }

  DataTable table = new DataTable();

  

  table.Load( dbCommand.ExecuteReader());

 

 dataGrid.DataSource = table;

 

con.Open(); 

SqlDataReader reader = cmd.ExecuteReader();

GridView1.DataSource = reader;

GridView1.DataBind();

reader.Close();

con.Close();