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