Populating an MSHFlexGrid using ADO control

[Sorry]

Sorry I am fairly new to VB and would really aprieciate some advice.

After having obtained the results from an SQL query in an ADODB recordset, rstScore is this a fairly efficient method of populating a Flex Grid, it seems rather cumbersome.


rstScores.Open strSQLScores, Cnxn, adOpenStatic,
adLockBatchOptimistic

Do While Not rstScores.EOF
With rstScores
fname = !fname
sname = !sname
playerid = !Id
state = !state
score = !score
msfgScores.AddItem (playerid + Chr(9) + sname +
Chr(9) + fname + Chr(9) + state + Chr(9) + score)
.MoveNext
End With
Loop


Thank you to any one that can help.

 

[75cl]

try this, it works great for display data on flexgrid
Set flexgrid.recordset = rs