private void ProcurarNome_Button_Click(object sender, RoutedEventArgs e) { DataTable dataTable = new DataTable("Estoque"); SqlDataAdapter dataAdapter = InterfaceBD.GetDataAdapter($"SELECT * FROM Estoque WHERE Nome LIKE '%{Name_TextBox.Text}%'"); dataAdapter.Fill(dataTable); Produto_DataGrid.ItemsSource = dataTable.DefaultView; }
private void update_table() { DataTable dataTable = new DataTable("Estoque"); SqlDataAdapter dataAdapter = InterfaceBD.GetDataAdapter("SELECT * FROM Estoque"); dataAdapter.Fill(dataTable); Produto_DataGrid.ItemsSource = dataTable.DefaultView; }
public MenuHistorico(MainWindow window) { InitializeComponent(); mainWindow = window; DataTable dataTable = new DataTable("Estoque"); SqlDataAdapter dataAdapter = InterfaceBD.GetDataAdapter($"SELECT * FROM Historico"); dataAdapter.Fill(dataTable); Produto_DataGrid.ItemsSource = dataTable.DefaultView; }