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);
}
}
