void inFood_Loaded(object sender, RoutedEventArgs e) { ds = Comm.ds; if (ds.ndata.Rows.Count == 0) { LoadData(); } //LINQ.. //var nutqry = from d in ds.ndata // where d.NDB_No == Ndb_No // select new { Nutr_No = d.Nutr_No, Nutr_Val = d.Nutr_Val }; //Lambda var nutqry = ds.ndata.Where(n => n.NDB_No == Ndb_No); foreach (var r in nutqry) { AddRow(r.Nutr_No, r.Nutr_Val); } NutV.DataContext = ValueList; Title = string.Format("{0} Records Found", ValueList.Count); Cfood.Text = this.Foo; }
public Home() { InitializeComponent(); ds = (Sr25DataSet)this.FindResource("sr25DataSet"); this.Loaded += Home_Loaded; bg.DoWork += bg_DoWork; bg.RunWorkerCompleted += bg_RunWorkerCompleted; }
//public static Sr25DataSet.Fd_GrpDataTable fg; //public static Sr25DataSet.FOOD_DESDataTable ft; //public static Sr25DataSet.ndataDataTable data; //public static Sr25DataSet.NUT_DEFDataTable nt; public static void sett(SR25Ce.Sr25DataSet d) { ds = d; //fg = ds.Fd_Grp; //ft = ds.FOOD_DES; //data = ds.ndata; //nt = ds.NUT_DEF; }
public MainWindow() { InitializeComponent(); foo = (Sr25DataSet)FindResource("SR25DS"); bg.DoWork += bg_DoWork; bg.RunWorkerCompleted += bg_RunWorkerCompleted; this.Loaded += MainWindow_Loaded; FooList.SelectionMode = SelectionMode.Multiple; }
void List2_Loaded(object sender, RoutedEventArgs e) { ds = Comm.ds; // Load data into the table Fd_Grp. You can modify this code as needed. if (ds == null) { MessageBox.Show("Null Data set"); this.Close(); } _groups.Add(new Ext_Groups(0, "All groups")); foreach (Sr25DataSet.Fd_GrpRow r in ds.Fd_Grp) { _groups.Add(new Ext_Groups(r.FdGrp_CD, r.FdGrp_Desc)); } Group.DataContext = _groups; Nutdef.DataContext = ds.NUT_DEF.DefaultView; }