private void LoadData() { this.Title = "Loading data . . . . . . . . . . . ."; Sr25DataSetTableAdapters.ndataTableAdapter nda = new Sr25DataSetTableAdapters.ndataTableAdapter(); nda.Fill(ds.ndata); nda.Dispose(); }
private void Loadndata() { if (ds.ndata.Rows.Count == 0) { SR25Ce.Sr25DataSetTableAdapters.ndataTableAdapter da = new Sr25DataSetTableAdapters.ndataTableAdapter(); da.Fill(ds.ndata); da.Dispose(); } }
private void FoodValueData() { //lazy loading must beware this data is not loaded at start of the program. if (ds.ndata.Rows.Count == 0) { SR25Ce.Sr25DataSetTableAdapters.ndataTableAdapter da = new Sr25DataSetTableAdapters.ndataTableAdapter(); da.Fill(ds.ndata); da.Dispose(); } }
private void AddFoodRow(Sr25DataSet.FOOD_DESRow fr) { if (foo.ndata.Rows.Count == 0) { //Title = string.Format("lazy loader busy .. Loading data before .. {0}", fr.NDB_No); Sr25DataSetTableAdapters.ndataTableAdapter ddda = new Sr25DataSetTableAdapters.ndataTableAdapter(); ddda.Fill(foo.ndata); ddda.Dispose(); } var nuts4foo = foo.ndata.Where(f => f.NDB_No == fr.NDB_No).ToDictionary(nno => nno.Nutr_No); DataRow dr = TheResTab.NewRow(); float v = 0F; dr[0] = fr.Desc; for (int i = 1; i < TheResTab.Columns.Count; i++) { short _nut_no = short.Parse(TheResTab.Columns[i].Caption); //Title = DateTime.Now.ToLongTimeString(); try { var _nut_val = nuts4foo[_nut_no]; dr[i] = _nut_val.Nutr_Val; } catch (KeyNotFoundException eee) { dr[i] = v; } } TheResTab.Rows.Add(dr); }
/// <summary> /// Make The DataTable for The results Datagrid. /// </summary> private void MakeResTab() { //TheResTab.Columns.Clear(); if (foo.NUT_DEF.Rows.Count <= 0) { Sr25DataSetTableAdapters.ndataTableAdapter ddda = new Sr25DataSetTableAdapters.ndataTableAdapter(); ddda.Fill(foo.ndata); ddda.Dispose(); } DataColumn ndc = new DataColumn("Food List", typeof(string)); ndc.Caption = "000"; TheResTab.Columns.Add(ndc);// Food column Header....... foreach (Sr25DataSet.NUT_DEFRow nd in foo.NUT_DEF) { //if (nd.IsSelected != null && ) //{ //colname = string.Format("{0}-({1}).",nd.NutrDesc,nd.Units); ndc = new DataColumn(nd.Nutr_No.ToString(), typeof(float)); ndc.Caption = nd.Nutr_No.ToString(); // save the nutr_no key!! TheResTab.Columns.Add(ndc); //} } }
private void Loadndata() { Sr25DataSetTableAdapters.ndataTableAdapter nddd = new Sr25DataSetTableAdapters.ndataTableAdapter(); nddd.Fill(foo.ndata); }