[RESOLVED] [2008] How to populate datagridview using a datareader

[Nitesh]

Hi Guys,

This is some of my code. But how do I populate a datagridview using the datareader.

Dim strSQL As String = "SELECT peopleid,firstnames,surname FROM people;"
            Dim cmd As New MySqlCommand(strSQL, con)
            'cmd.Parameters.AddWithValue("Parameter1", strName)

            Dim reader As MySqlDataReader = cmd.ExecuteReader

and how can I handle null field values.Please help