how to load values into combobox from ms Access database to shockwave flash object ?

See more:

MFC

MS-Access

VisualC++

Hi i am new to vc++ and ms access i am Retrieving data from ms access 2007 send into record set
from record set i am not able to send all values to comobobox.but i was sending one one value



recordset database(&recset);

cstring sqlstring="select username,password from student"
database.Excutesql(sqlstring);
recset.open(CRecordset::forwardonly,sqlstring,CRecordset::Readonly);

recset.getfieldvalue("username",username);

m_shockwavelogin.setvariable("username",(lpctstr)&recset);


i have done like this .it is displaying only one value (username);

i am having database like given below:

id username password
1 user 1234
2 Admin 3456

these to names i have to show in comobobox.plz help me..