Example #1
0
        private void listKategorie_SelectedIndexChanged(object sender, EventArgs e)
        {
            global global = new global();

            listWort.Items.Clear();
            ListView.SelectedListViewItemCollection testColl2 = new ListView.SelectedListViewItemCollection(listKategorie);

            testColl2 = listKategorie.SelectedItems;
            if (testColl2.Count > 0)
            {
                string siItem2 = testColl2[0] /*.SubItems[0]*/.Text;

                int tablesCounterW = global.datasetWort.Tables[global.datasetWort.Tables[0].TableName].Columns.Count;
                for (int i = 0; i < tablesCounterW; i++)
                {
                    if (global.datasetWort.Tables[global.datasetWort.Tables[0].TableName].Rows[i]["Kategorie"].ToString() == siItem2)
                    {
                        ListViewItem lviWort = new ListViewItem(global.datasetWort.Tables[global.datasetWort.Tables[0].TableName].Rows[i]["ID"].ToString());
                        lviWort.SubItems.Add((String)global.datasetWort.Tables[global.datasetWort.Tables[0].TableName].Rows[i]["BEZ"]);
                        listWort.Items.Add(lviWort);
                    }
                }
                //listWort.Items[0].Focused = true;
                listWort.Items[0].Selected = true;
                listWort.Select();
            }
            else
            {
                ListViewItem lviWort = new ListViewItem("!!!");
                lviWort.SubItems.Add("SelectedListViewItemCollection = null!!");
                listWort.Items.Add(lviWort);
            }
        }
Example #2
0
        private void tabWort_Enter(object sender, EventArgs e)
        {
            global global = new global();

            //--------------Einlesen der Themen aus der DB
            listThema.Items.Clear();
            int tablesCounterT = global.datasetThema.Tables.Count;

            try
            {
                tablesCounterT = global.datasetThema.Tables[global.datasetThema.Tables[0].TableName].Columns.Count;
            }
            catch (Exception ex)
            {
                string fehler = ex.ToString();
            }

            for (int i = 0; i < tablesCounterT; i++)
            {
                ListViewItem lviThema = new ListViewItem(global.datasetThema.Tables[global.datasetThema.Tables[0].TableName].Rows[i]["ID"].ToString());
                lviThema.SubItems.Add((String)global.datasetThema.Tables[global.datasetThema.Tables[0].TableName].Rows[i]["BEZ"]);
                listThema.Items.Add(lviThema);
            }

            if (listThema.Items.Count > 0)
            {
                listThema.Items[0].Focused  = true;
                listThema.Items[0].Selected = true;
                listThema.Select();
            }
            else
            {
                int count = listThema.Items.Count;
            }
        }
Example #3
0
        private void listThema_SelectedIndexChanged(object sender, EventArgs e)
        {
            global global = new global();

            //Rund 1: Thema = 1; Kategorie = ok / Runde 2: Thema = 2; Kategorie = ko / Runde 3: Thema = ko --> häääää???????????????????? --> TODO!!!!!!!!!

            listKategorie.Items.Clear();
            ListView.SelectedListViewItemCollection testColl = new ListView.SelectedListViewItemCollection(listThema);

            //string dsKat = datasetKategorie.Tables[datasetKategorie.Tables[0].TableName].Rows[0]["Thema"].ToString();

            testColl = listThema.SelectedItems;
            if (testColl.Count == 0)    //test
            {
                listThema.Items[1].Selected = true;
                listThema.Select();
            }
            if (testColl.Count > 0)
            {
                testColl = listThema.SelectedItems;
                string siItem = testColl[0] /*.SubItems[0]*/.Text;

                int tablesCounterK = global.datasetKategorie.Tables[global.datasetKategorie.Tables[0].TableName].Columns.Count;
                for (int i = 0; i < tablesCounterK; i++)
                {
                    if (global.datasetKategorie.Tables[global.datasetKategorie.Tables[0].TableName].Rows[i]["Thema"].ToString() == siItem)
                    {
                        ListViewItem lviKategorie = new ListViewItem(global.datasetKategorie.Tables[global.datasetKategorie.Tables[0].TableName].Rows[i]["ID"].ToString());
                        lviKategorie.SubItems.Add((String)global.datasetKategorie.Tables[global.datasetKategorie.Tables[0].TableName].Rows[i]["BEZ"]);
                        listKategorie.Items.Add(lviKategorie);
                    }
                }
                int katCount = listKategorie.Items.Count;
                if (katCount > 0)
                {
                    listThema.Items[0].Selected     = true; //test
                    listKategorie.Items[0].Focused  = true;
                    listKategorie.Items[0].Selected = true;
                    listKategorie.Select();
                }
            }
            else
            {
                ListViewItem lviKategorie = new ListViewItem("!!!");
                lviKategorie.SubItems.Add("SelectedListViewItemCollection = null!!");
                listKategorie.Items.Add(lviKategorie);
            }
        }
Example #4
0
        public void Load()
        {
            global global = new global();
            //--------------Verbinden und Öffnen der DB
            SQLiteConnection connection = new SQLiteConnection();

            connection.ConnectionString = "Data Source = " + global.dbPfad;
            connection.Open();

            //-------------Einlesen der Themen aus der DB
            string        commandThema = "SELECT * FROM Thema";
            SQLiteCommand SqlcmdT      = new SQLiteCommand();

            SqlcmdT.CommandType = System.Data.CommandType.Text;
            SqlcmdT.CommandText = commandThema;
            SqlcmdT.Connection  = connection;
            SQLiteDataAdapter dataAdapterT = new SQLiteDataAdapter(SqlcmdT);

            dataAdapterT.FillSchema(global.datasetThema, SchemaType.Source);
            dataAdapterT.Fill(global.datasetThema);

            //--------------Einlesen der Kategorien aus der DB
            string        commandKat = "SELECT * FROM Kategorie";
            SQLiteCommand SqlcmdK    = new SQLiteCommand();

            SqlcmdK.CommandType = System.Data.CommandType.Text;
            SqlcmdK.CommandText = commandKat;
            SqlcmdK.Connection  = connection;
            SQLiteDataAdapter dataAdapterK = new SQLiteDataAdapter(SqlcmdK);

            dataAdapterK.Fill(global.datasetKategorie);

            //---------------Einlesen der Wörter aus der DB
            string        commandW = "SELECT * FROM Wort";
            SQLiteCommand SqlcmdW  = new SQLiteCommand();

            SqlcmdW.CommandType = System.Data.CommandType.Text;
            SqlcmdW.CommandText = commandW;
            SqlcmdW.Connection  = connection;
            SQLiteDataAdapter dataAdapterW = new SQLiteDataAdapter(SqlcmdW);

            dataAdapterW.Fill(global.datasetWort);

            //---------------Einlesen der Favoriten aus der DB
            string        commandF = "SELECT * FROM Favorit";
            SQLiteCommand SqlcmdF  = new SQLiteCommand();

            SqlcmdW.CommandType = System.Data.CommandType.Text;
            SqlcmdW.CommandText = commandW;
            SqlcmdW.Connection  = connection;
            SQLiteDataAdapter dataAdapterF = new SQLiteDataAdapter(SqlcmdW);

            dataAdapterW.Fill(global.datasetFavorit);

            //---------------Einlesen der Listen aus der DB
            string        commandL = "SELECT * FROM Liste";
            SQLiteCommand SqlcmdL  = new SQLiteCommand();

            SqlcmdW.CommandType = System.Data.CommandType.Text;
            SqlcmdW.CommandText = commandW;
            SqlcmdW.Connection  = connection;
            SQLiteDataAdapter dataAdapterL = new SQLiteDataAdapter(SqlcmdW);

            dataAdapterW.Fill(global.datasetListe);

            //---------------Schließen der DB-Verbingung
            connection.Close();
        }