private void FillingMainDataGrid(bool pRefresh) { try { DataTable dtInfo = new DataTable(); string sQuery = DatabaseProcedure.OrderingColumns(); dtInfo = DatabaseProcedure.GettingInfoFromDatabase(sQuery); dataGrid.ItemsSource = dtInfo.DefaultView; } catch (Exception ex) { // MessageBox.Show(ex.Message.ToString()); } }
private static void FillingOutList() { List <ComponentsList> items = new List <ComponentsList>(); try { DataTable dtComponents = DatabaseProcedure.GettingInfoFromDatabase("SELECT Components FROM Components ORDER BY Components;"); foreach (DataRow row in dtComponents.Rows) { items.Add(new ComponentsList() { sComponent = row["Components"].ToString().Replace("_", " "), iQuantity = 0 }); } MyCollectionList = items; } catch { } }
public void AddingComponentsToGrid() { MyCollection = null; List <ComponentsList> items = new List <ComponentsList>(); try { DataTable dtComponents = DatabaseProcedure.GettingInfoFromDatabase("SELECT Components FROM Components ORDER BY Components;"); foreach (DataRow row in dtComponents.Rows) { items.Add(new ComponentsList() { sComponent = row["Components"].ToString().Replace("_", " "), iQuantity = 0 }); } MyCollectionList = items; } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } MyCollection = new ObservableCollection <ComponentsList>(MyCollectionList); dgComponent.ItemsSource = MyCollection; }