private void getfoodlist() { decimal max = 100.0M; decimal min = 0.0M; if (nUTR_DEFDataGrid.SelectedItem == null) { return; } DataRowView drv = nUTR_DEFDataGrid.SelectedItem as DataRowView; if (drv == null) { return; } SR25b.zsrDataSet.NUTR_DEFRow fr = (SR25b.zsrDataSet.NUTR_DEFRow)drv.Row; foo = (SR25b.zsrDataSet) this.FindResource("zsrDataSet"); decimal.TryParse(z_min.Text, out min); if (string.IsNullOrWhiteSpace(z_max.Text) == false) { decimal.TryParse(z_max.Text, out max); } // manually set the ItemsSource from the GetDataBy1 and use DefaultView. fOOD_DESDataGrid.ItemsSource = fdda.GetDataBy1(fr.Nutr_No, min, max).DefaultView; z_res.Content = string.Format(" Results, ( {0} Records Found )", fOOD_DESDataGrid.Items.Count); }
private void nUTR_DEFDataGrid_SelectionChanged(object sender, SelectionChangedEventArgs e) { int idx = nUTR_DEFDataGrid.SelectedIndex; if (nUTR_DEFDataGrid.SelectedItem == null) { return; } DataRowView drv = nUTR_DEFDataGrid.SelectedItem as DataRowView; if (drv == null) { return; } SR25b.zsrDataSet.NUTR_DEFRow fr = (SR25b.zsrDataSet.NUTR_DEFRow)drv.Row; }
private void LoadRdg() { ListBoxItem lb = ResList.SelectedItem as ListBoxItem; if (lb == null) { return; } SR25b.zsrDataSet.NUTR_DEFRow nd = (SR25b.zsrDataSet.NUTR_DEFRow)lb.Tag; // could do with cleaning this as string StrFormat take this.decp this.decp = nd.Decimal; string strfmt = StrFormat(decp); string selection = string.Format("Nutr_No = {0}", nd.Nutr_No); DataRow[] r4dg = Tempres.Select(selection); PanRes.Rows.Clear(); ResGrid.AutoGenerateColumns = true; ResGrid.Columns.Clear(); ResGrid.ItemsSource = null; SR25b.zsrDataSet.NUT_DATARow drow = null; foreach (DataRow dr in r4dg) { drow = (SR25b.zsrDataSet.NUT_DATARow)dr; DataRow d0 = PanRes.NewRow(); //d0[0] = (float)drow.Nutr_Val; d0[0] = string.Format(strfmt, drow.Nutr_Val); d0[1] = ffoodes(drow.NDB_No); PanRes.Rows.Add(d0); } //z_res.ItemsSource = TheResTab.DefaultView; ResGrid.ItemsSource = PanRes.DefaultView; ResGridHead.Content = string.Format("{0} Records Found", PanRes.Rows.Count); //DataGridTextColumn dgc = ResGrid.Columns[0] as DataGridTextColumn; ////dgc.HeaderStringFormat = strfmt; //string curfmt = dgc.Binding.StringFormat; //dgc.Binding.StringFormat = strfmt; //ResGridHead.Content = string.Format("Decimal pt {0}, prev format is {1}, next format {2}", decp, curfmt, strfmt); }