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