private void dothesearch()
        {
            if (txtBoxSearchSyllogo.Text != "")
            {
                SullogosAnazitisis = null;
                this.syllogoiTableAdapter.Fill(ptuxiakiDatabaseDataSet1.Syllogoi);
                DataRow[] grammes;
                int count_results;
                int idSullogou;
                bool is_int = int.TryParse(txtBoxSearchSyllogo.Text, out idSullogou);
                if (is_int)
                {
                    grammes = ptuxiakiDatabaseDataSet1.Tables["Syllogoi"].Select("ID_Syllogou ='" + txtBoxSearchSyllogo.Text + "'");
                }
                else
                {
                    txtBoxSearchSyllogo.Text = txtBoxSearchSyllogo.Text.Replace('*', '%');
                    grammes = ptuxiakiDatabaseDataSet1.Tables["Syllogoi"].Select("Onoma_Syllogou LIKE '" + txtBoxSearchSyllogo.Text + "' or Eponumo_Proedrou LIKE '" + txtBoxSearchSyllogo.Text + "'");
                }
                count_results = grammes.Length;
                if (count_results > 1)
                {
                    stoixeio = txtBoxSearchSyllogo.Text;
                   FormEpilogiSyllogou SyllogosEpilogi_Show_A = new FormEpilogiSyllogou();
                   SyllogosEpilogi_Show_A.stoixeio = stoixeio;
                    if (SyllogosEpilogi_Show_A.ShowDialog() == DialogResult.OK)
                    {
                        SullogosAnazitisis = SyllogosEpilogi_Show_A.SullogosAnazitisis;
                        iD_SyllogouLabel1.Text = SullogosAnazitisis[0].ToString();
                        onoma_SyllogouLabel1.Text = SullogosAnazitisis[1].ToString();
                        onoma_ProedrouLabel1.Text = SullogosAnazitisis[2].ToString();
                        eponumo_ProedrouLabel1.Text = SullogosAnazitisis[3].ToString();
                        num_FialesLabel1.Text = SullogosAnazitisis[4].ToString();
                        date_IdrisisLabel1.Text = SullogosAnazitisis[5].ToString();

                    }

                }
                if (count_results == 1)
                {
                    SullogosAnazitisis = grammes[0];
                    iD_SyllogouLabel1.Text = SullogosAnazitisis[0].ToString();
                    onoma_SyllogouLabel1.Text = SullogosAnazitisis[1].ToString();
                    onoma_ProedrouLabel1.Text = SullogosAnazitisis[2].ToString();
                    eponumo_ProedrouLabel1.Text = SullogosAnazitisis[3].ToString();
                    num_FialesLabel1.Text = SullogosAnazitisis[4].ToString();
                    date_IdrisisLabel1.Text = SullogosAnazitisis[5].ToString();
                }
                if (count_results == 0)
                {
                    MessageBox.Show("Δεν βρέθηκε η εγγραφή!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                     txtBoxSearchSyllogo.Focus();
                     txtBoxSearchSyllogo.SelectAll();
                }

            }
        }
        private void SearchSyllogo()
        {
            if (textBoxSearchSyllogo.Text != "")
            {
                SyllogosAnazitisis = null;
                this.syllogoiTableAdapter1.Fill(ptuxiakiDatabaseDataSet11.Syllogoi);
                DataRow[] grammes;
                int count_results = 0;
                int idSyllogou;
                bool idgiven = int.TryParse(textBoxSearchSyllogo.Text, out idSyllogou);
                if (idgiven)
                {
                    grammes = ptuxiakiDatabaseDataSet11.Tables["Syllogoi"].Select("ID_Syllogou='" + textBoxSearchSyllogo.Text + "'");
                    count_results = grammes.Length;
                    if (count_results != 0)
                    {
                        SyllogosAnazitisis = grammes[0];
                    }
                    else
                    {
                        MessageBox.Show("Δεν βρέθηκε ο Σύλλογος!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    }
                }
                else
                {
                    textBoxSearchSyllogo.Text = textBoxSearchSyllogo.Text.Replace('*', '%');
                    grammes = ptuxiakiDatabaseDataSet11.Tables["Syllogoi"].Select("Onoma_Syllogou LIKE '" + textBoxSearchSyllogo.Text + "' or Eponumo_Proedrou LIKE '" + textBoxSearchSyllogo.Text + "'");
                    count_results = grammes.Length;

                    if (count_results > 1)
                    {
                        stoixeio = textBoxSearchSyllogo.Text;
                        FormEpilogiSyllogou epilogisyllogou = new FormEpilogiSyllogou();
                        epilogisyllogou.stoixeio = stoixeio;
                        if (epilogisyllogou.ShowDialog() == DialogResult.OK)
                        {
                            SyllogosAnazitisis = epilogisyllogou.SullogosAnazitisis;
                        }
                    }
                    if (count_results == 1)
                    {
                        SyllogosAnazitisis = grammes[0];
                    }
                    if (count_results == 0)
                    {
                        MessageBox.Show("Δεν βρέθηκε ο Συλλόγος!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    }

                }

            }
        }
        private void dothesearchSyllogou()
        {
            if (textBoxSearchSyllogo.Text != "")
            {
                int results = 0;
                DataRow[] grammesSyllogou;
                this.syllogoiTableAdapter1.Fill(ptuxiakiDatabaseDataSet11.Syllogoi);
                int idSyllogou;
                bool is_int = int.TryParse(textBoxSearchSyllogo.Text, out idSyllogou);
                if (is_int)
                {
                    grammesSyllogou = ptuxiakiDatabaseDataSet11.Tables["Syllogoi"].Select("ID_Syllogou= '" + textBoxSearchSyllogo.Text + "'");
                }
                else
                {
                    textBoxSearchSyllogo.Text = textBoxSearchSyllogo.Text.Replace('*', '%');
                    grammesSyllogou = ptuxiakiDatabaseDataSet11.Tables["Syllogoi"].Select("Onoma_Syllogou LIKE '" + textBoxSearchSyllogo.Text + "'or Eponumo_Proedrou LIKE '" + textBoxSearchSyllogo.Text + "'");
                }
                results = grammesSyllogou.Length;
                if (results > 1)
                {
                    stoixeioSyllogou = textBoxSearchSyllogo.Text;
                    FormEpilogiSyllogou SyllogosEpilogi = new FormEpilogiSyllogou();
                    SyllogosEpilogi.stoixeio = stoixeioSyllogou;
                    if (SyllogosEpilogi.ShowDialog() == DialogResult.OK)
                    {
                        SullogosAnazitisis = SyllogosEpilogi.SullogosAnazitisis;
                        FormFindSyllogoFromMain SullogosEpilogi_Show_A = new FormFindSyllogoFromMain();
                        SullogosEpilogi_Show_A.SullogosAnazitisis = SullogosAnazitisis;
                        SullogosEpilogi_Show_A.Show();
                    }
                }

                if (results == 1)
                {
                    MessageBox.Show("Ο Σύλλογος βρέθηκε", "Found !", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    FormFindSyllogoFromMain findSullogos = new FormFindSyllogoFromMain();
                    findSullogos.SullogosAnazitisis = grammesSyllogou[0];
                    findSullogos.Show();
                }

                if (results == 0)
                {
                    MessageBox.Show("Δεν βρέθηκε ο Σύλλογος!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }

            }
        }