void Button7Click(object sender, EventArgs e)
{
// Save changes back to DB
string updatesqlrunner = string.Format("UPDATE Athletes SET Fname = '{0}', Lname = '{1}', Sex= '{2}', DOB= '{3}', Race= '{4}', Status= '{5}', BibNumber= '{6}', GunStart= '{7}', ManualEnd= '{8}' WHERE unique_key='{9}'", textBoxFname.Text, textBoxLname2.Text, comboBoxSex.Text, dateTimePicker1.Text, comboBoxRace2.Text, comboBoxStatus2.Text, textBoxBib2.Text, textBoxGunStart.Text, textBoxManualEnd.Text, runneruniquekey);
DbSqlite.SimpleSQliteAction(updatesqlrunner);
//update the view
runner = DbSqlite.GetDataSetSqlite(sqlsearchrunner);
}
void Button3Click(object sender, System.EventArgs e)
{
//save changes to db
string updateracesql = string.Format("UPDATE Races SET RaceOver = '{0}', RaceLaps = '{1}', RaceHours = '{2}', RaceType = '{3}' WHERE RaceName = '{4}'", comboBoxStatus.Text, textBoxRaceLaps.Text, textBoxRaceLength.Text, comboBoxType.Text, textBoxRaceName.Text);
Console.WriteLine(updateracesql);
DbSqlite.SimpleSQliteAction(updateracesql);
//refresh data in view
ds2 = DbSqlite.GetDataSetSqlite(thissearchstring);
}
