void Button6Click(object sender, EventArgs e)
        {
// Search based on last name , race and bib number

            if (textBoxBib2.Text != "")
            {
                sqlsearchrunner = string.Format("Select * from Athletes WHERE BibNumber = '{0}'  AND Race = '{1}'", textBoxBib2.Text, comboBoxRace2.Text);

                try {
                    runner = DbSqlite.GetDataSetSqlite(sqlsearchrunner);

                    if (runner.Tables[0].Rows.Count != 0)
                    {
                        comboBoxRace2.Text    = runner.Tables[0].Rows[0]["Race"].ToString();
                        textBoxFname.Text     = runner.Tables[0].Rows[0]["Fname"].ToString();
                        textBoxLname2.Text    = runner.Tables[0].Rows[0]["Lname"].ToString();
                        comboBoxSex.Text      = runner.Tables[0].Rows[0]["Sex"].ToString();
                        comboBoxStatus2.Text  = runner.Tables[0].Rows[0]["Status"].ToString();
                        dateTimePicker1.Text  = runner.Tables[0].Rows[0]["DOB"].ToString();
                        textBoxBib2.Text      = runner.Tables[0].Rows[0]["BibNumber"].ToString();
                        textBoxGunStart.Text  = runner.Tables[0].Rows[0]["GunStart"].ToString();
                        textBoxManualEnd.Text = runner.Tables[0].Rows[0]["ManualEnd"].ToString();



                        runneruniquekey = runner.Tables[0].Rows[0]["unique_key"].ToString();
                    }
                }

                catch { MessageBox.Show("No result for that search"); }
            }
        }
        private void PopulateMenu()

        {
            string NewQuery = "Select * from Races";                                             //+ "\'%"+ SelectRace.Text+"\'";
//Console.WriteLine(NewQuery);

//Pass string to function here....

            /// <remarks>
/// Creating a DataSet to feed the DataGridView
/// </remarks>
//
            DataSet results = new DataSet();

            try
            {
                results = DbSqlite.GetDataSetSqlite(NewQuery);


                ChooseRace.DataSource     = results.Tables[0];
                ChooseRace.DisplayMember  = "RaceName";
                ChooseRace.BindingContext = BindingContext;

                //dataGridView1.DataSource = results.Tables[0].DefaultView;
            }



            catch (Exception error)
            {
                MessageBox.Show("Exception caught: " + error.Message);
            }
        }
        public Races()
        {
            //
            // The InitializeComponent() call is required for Windows Forms designer support.
            //


            try {
                //
                // The InitializeComponent() call is required for Windows Forms designer support.
                //
                InitializeComponent();

                DataSet menu = DbSqlite.GetDataSetSqlite("SELECT * FROM races");

                ChooseRace.DataSource     = menu.Tables[0];
                ChooseRace.DisplayMember  = "RaceName";
                ChooseRace.BindingContext = BindingContext;

                dataGridView1.AutoGenerateColumns = true;

                dataGridView1.DataSource = menu.Tables[0];
            } catch (Exception ex)

            {
                MessageBox.Show(ex.Message);
            }
        }
        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);
        }
        void Button1Click(object sender, EventArgs e)
        {
            thissearchstring = string.Format("Select * from Races where RaceName = '{0}'", ChooseRace.Text);            // where RaceName ="+ChooseRace.Text;


            ds2 = DbSqlite.GetDataSetSqlite(thissearchstring);

            textBoxRaceName.Text   = ds2.Tables[0].Rows[0]["RaceName"].ToString();
            textBoxRaceLength.Text = ds2.Tables[0].Rows[0]["RaceHours"].ToString();
            textBoxRaceLaps.Text   = ds2.Tables[0].Rows[0]["RaceLaps"].ToString();
            comboBoxStatus.Text    = ds2.Tables[0].Rows[0]["RaceOver"].ToString();
            comboBoxType.Text      = ds2.Tables[0].Rows[0]["RaceType"].ToString();


            //dataGridView2.DataSource = ds2.Tables[0];
        }
        void Button2Click(object sender, EventArgs e)
        {
            thissearchstring = string.Format("Select * from Races");             //where RaceName = '{0}'",ChooseRace.Text);
            Console.WriteLine(thissearchstring);

            DbSqlite.SaveDataTable(dataGridView1, thissearchstring);

            DataSet menu = DbSqlite.GetDataSetSqlite("SELECT * FROM races");

            ChooseRace.DataSource     = menu.Tables[0];
            ChooseRace.DisplayMember  = "RaceName";
            ChooseRace.BindingContext = BindingContext;

            dataGridView1.AutoGenerateColumns = true;

            dataGridView1.DataSource = menu.Tables[0];
        }
        private void FillData(string selectCommand)
        {
            DataSet ds = new DataSet();


            ds = DbSqlite.GetDataSetSqlite(selectCommand);

            dataGridView2.DataSource = ds.Tables[0];



            DataView overall = ds.Tables[0].DefaultView;

            overall.Sort             = "OverallPos ASC";
            dataGridView2.DataSource = overall;

            if (checkBox4.Checked == true)
            {
                DataView agecat = ds.Tables[0].DefaultView;
                agecat.Sort = "AgeCat ASC, CatPos ASC";
                dataGridView2.DataSource = agecat;
            }
        }
        void Button1Click(object sender, EventArgs e)
        {
            TimersWindow tww = new TimersWindow();

            tww.TimerRaceName = SelectRace2.Text;

            //check the db to see if this race is already started
            //if it is we use the existing start time
            //if not we write the starttime to the db

            //selectquery = "Select * from Races where "

            //ExecuteSQLQuery("Select * from Races where RaceName =");

            //fill the datatable

            string racestartquery = string.Format("Select * from Races WHERE RaceName = '{0}'", SelectRace2.Text);

            Console.WriteLine(racestartquery);
            //FillData(racestartquery);

            //search the datatable for the value

            //string connstring = "Data Source=RFIDTAGSTORE.s3db";

            CreateSQLiteDataReader(racestartquery);


            tww.RaceTimeStartTime = DateTime.Now.ToLocalTime();

            try {
                tww.RaceTimeStartTime = Convert.ToDateTime(RaceStartValue);
            }

            catch {
                string sqlinsert = string.Format("UPDATE Races SET RaceStart='{0}', RaceOver = '{1}' WHERE RaceName ='{2}'", tww.RaceTimeStartTime, "Running", SelectRace2.Text);

                Console.WriteLine(sqlinsert);

                DbSqlite r = new DbSqlite();

                //	DbSqlite.RFIDTAGSTORE.Open();

                r.SimpleSQliteInsert(sqlinsert);


                //Lets also set the GunTime for all the athletes in the race.

                string setstartsql = string.Format("UPDATE Athletes SET GunStart='{0}', NettTotal = null, GunTotal = null, OverallPos = null, GenderPos = null, CatPos = null  WHERE Race='{1}'", tww.RaceTimeStartTime.ToString(), SelectRace2.Text);

                r.SimpleSQliteInsert(setstartsql);

                Console.WriteLine(setstartsql);

                //	DbSqlite.RFIDTAGSTORE.Close();
            }



            //tww.RaceTimeStartTime = SQLRaceStartTime;

            tww.RaceLaps  = RaceLaps;
            tww.RaceHours = RaceHours;
            tww.RaceType  = RaceType;

            tww.Text = SelectRace2.Text + " Timer";
            tww.Show();

            //	var race = new formstest.MainClass.Races();
            //	race.RaceName = SelectRace2.Text;
        }