private void tabControl1_SelectedIndexChanged(object sender, EventArgs e) { if (this.tabControl1.SelectedIndex == 1) { bkup = new List <Entries2Fiilter>(); int idx = 0; foreach (Entries2Fiilter sourceitm in (List <Entries2Fiilter>) this.gridEX2.DataSource) { Entries2Fiilter itm = new Entries2Fiilter(); // itm.relatedpercentage = sourceitm.relatedpercentage; bkup.Add(itm); } if (this.pushedonce) { this.button2_Click_1(this, new EventArgs()); } } else { var z = (List <Entries2Fiilter>) this.gridEX2.DataSource; for (int idx = 0; idx < bkup.Count; idx++) { } this.gridEX2.DataSource = z; button1_Click(this, new EventArgs()); } }
public List <Entries2Fiilter> localUpload2Form(OleDbCommand restricteditems, string direction) { Entries2Fiilter dummy; List <Entries2Fiilter> dummylist = new List <Entries2Fiilter>(); int pcatdepth = 1; int tcatdepth = 1; int ccat1depth = 1; int ccat2depth = 1; string prefix = ""; string vstodelimeter = ""; double a = Convert.ToDouble("15,5"); if (a == 15.5) { vstodelimeter = ","; } a = Convert.ToDouble("15.5"); if (a == 15.5) { vstodelimeter = "."; } using (OleDbDataReader calitm = restricteditems.ExecuteReader()) { while (calitm.Read()) { int i = 0; dummy = new Entries2Fiilter(); i++; dummy.setRunCount(i); dummy.Text1 = (string)calitm[prefix + "LongText1"]; dummy.DateTime1 = Convert.ToDateTime(calitm[prefix + "DateTime1"]).Date; dummy.Numeric1 = Convert.ToDouble(((double)calitm[prefix + "Numeric1"]).ToString().Replace(",", vstodelimeter).Replace(".", vstodelimeter)); dummy.Numeric2 = Convert.ToDouble(((double)calitm[prefix + "Numeric2"]).ToString().Replace(",", vstodelimeter).Replace(".", vstodelimeter)); dummy.Text2 = ((string)calitm[prefix + "ShortText3"]); dummy.Text3 = ((string)calitm[prefix + "ShortText3"]); dummy.setdbID(Convert.ToInt32(calitm[prefix + "ID"])); dummylist.Add(dummy); } } return(dummylist); }
public void UploadDataIntoList(OleDbCommand restricteditems) { Entries2Fiilter dummy; List <Entries2Fiilter> dummylist = new List <Entries2Fiilter>(); string vstodelimeter = ""; double a = Convert.ToDouble("15,5"); if (a == 15.5) { vstodelimeter = ","; } a = Convert.ToDouble("15.5"); if (a == 15.5) { vstodelimeter = "."; } string prefix = ""; using (OleDbDataReader calitm = restricteditems.ExecuteReader()) { while (calitm.Read()) { int i = 0; dummy = new Entries2Fiilter(); i++; dummy.setRunCount(i); dummy.setdbID(Convert.ToInt32(calitm[prefix + "ID"])); dummy.DateTime1 = Convert.ToDateTime(calitm[prefix + "DateTime1"]).Date; dummy.Text1 = (string)calitm[prefix + "LongText1"]; dummy.Text2 = ((string)calitm[prefix + "ShortText2"]); dummy.Text3 = ((string)calitm[prefix + "ShortText3"]); dummy.Numeric1 = Convert.ToDouble(((double)calitm[prefix + "Numeric1"]).ToString().Replace(",", vstodelimeter).Replace(".", vstodelimeter)); dummy.Numeric2 = Convert.ToDouble(((double)calitm[prefix + "Numeric2"]).ToString().Replace(",", vstodelimeter).Replace(".", vstodelimeter)); dummylist.Add(dummy); } //end read } //end using DataInList = dummylist; }