How to bind data to a DataGridView?

[bclayshannon]

I can retrieve data this way:

Code: Select all

            while (myReader.Read())
            {
                MessageBox.Show(myReader.GetString(0)); 
             }

...but I really want to put all of the data into a DataGridView control. Is that possisble? If so, how?

[Pinturiccio]

...but I really want to put all the data into a DataGridView control. Is that possisble? If so, how?

You cannot bind data from DataReader to DataGridView control. As a workaround, you can put all of the data into DataTable and then bind Datatable to DataGridView control.