Adding data from sql database into gridview

[CasperG]

Can anyone tell me what is wrong with this code, i am trying to add information into a gridview from a sql datbase,

thanks

SQLSearch("SELECT * FROM engineerissues WHERE EngineerNumber = " & cmbRepTyp.Text)

        RS.AddNew()

        Dim dgvRow As New DataGridViewRow
        Dim dgvCell As DataGridViewCell

        dgvCell = New DataGridViewTextBoxCell()
        dgvCell.Value = RS.Fields.Item("EngineerNumber").Value
        dgvRow.Cells.Add(dgvCell)

        dgvCell = New DataGridViewTextBoxCell()
        dgvCell.Value = RS.Fields.Item("CallRef").Value
        dgvRow.Cells.Add(dgvCell)

        dgvCell = New DataGridViewTextBoxCell()
        dgvCell.Value = RS.Fields.Item("DateLogged").Value
        dgvRow.Cells.Add(dgvCell)

        dgvCell = New DataGridViewTextBoxCell()
        dgvCell.Value = RS.Fields.Item("LoggedBy").Value
        dgvRow.Cells.Add(dgvCell)

        dgvCell = New DataGridViewTextBoxCell()
        dgvCell.Value = RS.Fields.Item("Comments").Value
        dgvRow.Cells.Add(dgvCell)

        dgvCell = New DataGridViewTextBoxCell()
        dgvCell.Value = RS.Fields.Item("Resolved").Value
        dgvRow.Cells.Add(dgvCell)

but it retuns null values.