Hi,

I am not able to get entire rows as per my access database in MSHFlexgrid, can anyone please suggest

Access DB example:

WORD MEANING
Deprive Not allow to have: to prevent somebody from having somethingTake away: to take something away from somebody; Depose: to depose somebody from high rank office

Below is my code:
Code:
Set oRs = oConn.Execute(sql)

    mfgViewData.Clear
    mfgViewData.Rows = 2
    mfgViewData.Cols = 2
    mfgViewData.TextMatrix(0, 0) = "WORD"
    mfgViewData.TextMatrix(0, 1) = "MEANING"
    
    mfgViewData.ColWidth(0) = 1500
    mfgViewData.ColWidth(1) = 4000
    
    With oRs
    Do While oRs.EOF = False
        mfgViewData.AddItem ""
        mfgViewData.TextMatrix(mfgViewData.Rows - 2, 0) = .Fields("WORD")
        mfgViewData.TextMatrix(mfgViewData.Rows - 2, 1) = .Fields("MEANING")
    .MoveNext
    Loop
End With
Is there any oother way to view the data
db:access
application: vb 6.0

Thanks in advance