.NET (Core and Framework)

private void buttonSearch_Click(object sender, RoutedEventArgs e)
        {
            CreateSearchQuery();
            UpdateLayout();
            UpdateFolderProperties();
            IndexContents();
            try
            {
                using (OleDbConnection conn = new OleDbConnection(
"Provider=Search.CollatorDSO;Extended Properties='Application=Windows';"))
                {
                    conn.Open();
                    OleDbCommand cmd = new OleDbCommand(SearchQuery, conn);

                    using (OleDbDataReader reader = cmd.ExecuteReader())
                    {
                        listView1.Items.Clear();
                        while (reader.Read())
                        {
                            listView1.Items.Add(reader[0]);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                statusBar.Text = "Searching failed: " + ex.Message + "!";
            }
        }

        private void CreateSearchQuery()
        {
            SearchQuery = @"SELECT "
                          + @"System.ItemPathDisplay"
                          + @" FROM SYSTEMINDEX WHERE (FREETEXT('" + txtSearch.Text + @"') OR System.ItemName LIKE '%" + txtSearch.Text + @"%') AND SCOPE = '" + txtPath.Text + @"'";
        }