public static ObservableCollection <Category> GetCategoriesFromDb() { var categoriesList = new ObservableCollection <Category>(); DataTable q = QueryForSQLServer.GetCategory(); foreach (DataRow row in q.Rows) { var category = new Category { Id = (int)row.ItemArray[0], Name = (string)row.ItemArray[1] }; categoriesList.Add(category); } return(categoriesList); }
public void searchFillter(ObservableCollection <Product> products) { this.InitializeComponent(); var categoriesList = new ObservableCollection <Category>(); DataTable q = QueryForSQLServer.GetCategory(); foreach (DataRow row in q.Rows) { var category = new Category { Id = (int)row.ItemArray[0], Name = (string)row.ItemArray[1] }; categoriesList.Add(category); } ProductData = products; PagingPage(); cbbListType.ItemsSource = categoriesList; }