I was told to create a new thread by kevininstructor

Code:
Public Sub queryCity()
        Dim cmd2 As New OracleCommand
        conn.Open()

        cmd2.Connection = conn
        cmd2.CommandText = "select e.employer_name, e.pen, e.contact_no, b.street1, b.street2, e.employer_status, e.mapping_status from employer e, building b, block k, map m where e.building_id = b.building_id and b.block_id = k.block_id and k.map_id = m.map_id and k.city = '" & employerReports.categoryResults_cb.Text & "'"
        'MsgBox(cmd2.CommandText)
        cmd2.CommandType = CommandType.Text
        Dim dr As OracleDataReader = cmd2.ExecuteReader
        Dim dt As New DataTable
        dt.Load(dr)
        employerReports.DataGridView1.DataSource = dt
        conn.Close()
    End Sub
here's the output, dunno if this will work. i can't upload it to any imagehosting site. our office restricts em.


i need a way to screen each employer status and mapping status before placing them in the DGV. I need to convert the numerical values to their corresponding status. 1 = Good, 2 = Non-Reporting, 3 = Under-Remitting and 4= Non-Remitting(which i already know how to do). I just don't know how to get the values being placed on the DGV. I would love to do this on oracle but i don't know how to.

thank you!