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);
}
}
