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