private void searchTxtBox_TextChanged(object sender, TextChangedEventArgs e)
{
string S_key = searchTxtBox.Text;
try
{
if (S_key == "")
{
DataTable dt = itm.select();
InventoryItems.SetBinding(ItemsControl.ItemsSourceProperty, new Binding {
Source = dt
});
}
else
{
DataTable dt = new DataTable();
con = new SqlConnection(ConfigurationManager.ConnectionStrings["conString"].ConnectionString);
con.Open();
SqlDataAdapter sda = new SqlDataAdapter(
"select id, ingredient,price,quantity,convert(varchar, inv.e_date, 3) as e_date,unit,min_quantity, CASE WHEN supplier_id IS NULL THEN '' ELSE (SELECT supplier_name FROM suppliers where supplier_id=inv.supplier_id) END AS supplier_name FROM inventory as inv WHERE ingredient LIKE '%" + S_key + "%'", con);
sda.Fill(dt);
InventoryItems.SetBinding(ItemsControl.ItemsSourceProperty, new Binding {
Source = dt
});
}
}
catch (Exception exception)
{
MessageBox.Show(exception.ToString(), "Info");
}
finally
{
con.Close();
}
}
private void loadGrid()
{
DataTable dt = itm.select();
InventoryItems.SetBinding(ItemsControl.ItemsSourceProperty, new Binding {
Source = dt
});
}