private void Search_TextChanged(object sender, TextChangedEventArgs e) { string text = search.Text; if (string.IsNullOrEmpty(text)) { isNumber = false; gridSearch.Visibility = Visibility.Hidden; return; } gridSearch.Visibility = Visibility.Visible; isNumber = char.IsDigit(text[0]); gridSearch.Items.Clear(); if (isNumber) { foreach (var p in sqlProduct.Select(Convert.ToInt32(text))) { gridSearch.Items.Add(p); } } else { foreach (var p in sqlProduct.Select(text)) { gridSearch.Items.Add(p); } } if (gridSearch.HasItems) { gridSearch.SelectedItem = gridSearch.Items[0]; } }
public void Produtos_Loaded(object sender, RoutedEventArgs e) { GridProdutos.Items.Clear(); foreach (var p in sqlProduct.Select()) { GridProdutos.Items.Add(p); } }