Can a DataReader be used to populate a DataGrid? 1

[emaduddeen]

Hi Everyone,

Can a DataReader be used to populate a DataGridView? If yes can you show me what coding I need to use to do this?

Thanks.

Truly,

Emad

 

[RiverGuy]

        Me.DataGridView1.Columns.Clear()
        For i As Integer = 0 To MyDataReader.FieldCount - 1
            Me.DataGridView1.Columns.Add(MyDataReader.GetName(i), MyDataReader.GetName(i))
        Next

        While MyDataReader.Read
            Dim row(MyDataReader.FieldCount - 1) As Object
            MyDataReader.GetValues(row)
            Me.DataGridView1.Rows.Add(row)
        End While