public DataTable retrieveScore() { try { DataTable dtScore; dbcon = new BrainGameDatabaseConnection(); string query; query = "select * from record order by recordid desc"; dtScore = dbcon.retrieve(query); return(dtScore); } catch (Exception exc) { MessageBox.Show("Error: " + exc); return(null); } }
public void insertdata() { try { dbcon = new BrainGameDatabaseConnection(); string query; query = "insert into record(player1, player2, player1score, player2score, player1time, player2time, totaltime, winner) values('" + _player1 + "','" + _player2 + "'," + _player1score + "," + _player2score + ",'" + _player1time + "','" + _player2time + "','" + _totaltime + "','" + _winner + "');"; dbcon.manipulate(query); } catch (Exception exc) { MessageBox.Show("Error: " + exc); } }