Database Data [modified]

[SRJ92]

hello, i want to create a more complex highscore board that displays the playname and score in labels! currently i have a datagrid which is displaying my data as a test, here is my code for that:

        OLEDataConnector Dat = new OLEDataConnector("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\"Highscore.accdb\\";Persist Security Info=False;");
        DataTable Dt = new DataTable();
        Dat.dataSelect("select Playername, Score, LevelNumber from score order by score desc", ref Dt);
        dataGridView1.DataSource = Dt.DefaultView;

its a microsoft access database and i need to get around 10 rows if they are in the database to be put onto my highscore board ... So what i want is the playername of the record to be put into one label and the other as a score in another label, obviosuly they will move around using the query, :P Any help? as i can't find anything on this that is of any use.... Thanks

modified on Thursday, November 11, 2010 5:11 PM