Please help! I'm very confused on this, the following is my code that I am using to attempt to connect to a mysql database, any help will be apreciated!

string dbConn = "driver={mysql};server=193.169.0.3;database=StealthOnline_Com;user=;password=;";

ADODB._Connection db = new ADODB.ConnectionClass();
ADODB._Recordset rs = new ADODB.RecordsetClass();



db.Open(dbConn, "", "", -1);


rs.Open("select * from sfx", db, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockReadOnly, -1);


How do I now grab the data from the recordset? this is my problem!

Thanks in advance,
toto