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