Beispiel #1
0
        private void ItemNameInput_KeyUp(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Control || e.KeyCode == Keys.Enter)
            {
                if (ItemNameInput.Text != "")
                {
                    itemSearchSQLcmd.Parameters["@name"].Value = ItemNameInput.Text;
                    itemSearchSQLcmd.Prepare();

                    SQLiteDataReader rdr = itemSearchSQLcmd.ExecuteReader();

                    ResultList.BeginUpdate();

                    ResultList.Items.Clear();
                    while (rdr.Read())
                    {
                        var item = new ListViewItem();

                        item.Text = rdr.GetString(0);
                        item.SubItems.Add(rdr.GetInt32(1).ToString());

                        ResultList.Items.Add(item);
                    }

                    ResultList.EndUpdate();

                    ResultList.Columns[0].Width = ResultList.ClientSize.Width;

                    rdr.Close();
                }
            }
        }