private void searchTB_EditValueChanged(object sender, DevExpress.Xpf.Editors.EditValueChangedEventArgs e) { if (!string.IsNullOrWhiteSpace(searchTB.Text) && table != "Data" && column != null) { string query; if (column != "ID") { query = "Select * from " + table + " Where " + column + " like N'%" + searchTB.Text + "%'"; } else { query = "Select * from " + table + " Where " + column + " = " + searchTB.Text + " "; } DataBaseTools.open(); SqlCommand cmd = new SqlCommand(query, DataBaseTools.conn); cmd.ExecuteNonQuery(); SqlDataAdapter a = new SqlDataAdapter(cmd); DataTable t = new DataTable(); a.Fill(t); searchGrid.ItemsSource = t; DataBaseTools.close(); matchesTB.Text = searchGrid.VisibleRowCount + ""; } else { matchesTB.Text = ""; searchGrid.ItemsSource = null; searchGrid.Columns.Clear(); } }
private void searchBTN_Click(object sender, System.Windows.RoutedEventArgs e) { string searchFor = searchTB.Text; string query = @"select b.Title ,d.pageid [Page Number] , d.text [Text] from books b inner join Data d on b.ID = d.BookID where d.Text like N'%" + searchFor + @"%' union select b.Title ,pd.pageid [Page Number] , 'Image : ' + pd.text [Text] from books b inner join PicturesData pd on b.ID = pd.BookID where pd.text like N'%" + searchFor + "%' order by b.Title"; DataBaseTools.open(); ExecuteAndFill(query); }