Esempio n. 1
0
        private void button1_Click(object sender, EventArgs e)
        {
            bindingSource1.DataSource = glob.dataglob;
            dataGridView1.DataSource  = bindingSource1;

            string           oradb = "DATA SOURCE=aos.acsu.buffalo.edu:1521/aos.buffalo.edu;PASSWORD=cse601;USER ID=AVIJEETM";
            OracleConnection conn  = new OracleConnection(oradb); // C#

            IExcel.Application appExl;
            appExl = new IExcel.Application();

            conn.Open();
            OracleCommand cmd   = conn.CreateCommand();
            String        query = "SELECT patient.p_id, ap.u_id, mn.exp FROM  mrnaexpression mn INNER JOIN arrayprobe ap ON mn.pb_id=ap.pb_id  INNER JOIN (SELECT a.s_id, b.p_id  FROM clinicalsample a, patientsample b WHERE a.s_id = b.s_id AND b.p_id  IN (SELECT p_id  FROM diagnosis      WHERE ds_id IN (SELECT ds_id FROM disease        WHERE name = '" + glob.dis_glob + "'))) patient ON mn.s_id = patient.s_id AND ap.u_id IN(";

            query = query + glob.dataglob[0].UID;
            for (int i1 = 1; i1 < glob.length; i1++)
            {
                query = query + "," + glob.dataglob[i1].UID;
            }
            query = query + ") ORDER BY patient.p_id,ap.u_id";

            cmd.CommandText = query;
            OracleDataReader dr      = cmd.ExecuteReader();
            OracleDataReader dr_temp = dr;
            int i = 0;

            double[]      tempuid = new double[100000];
            double[]      tempexp = new double[100000];
            Pid_UID_Exp[] dataexp = new Pid_UID_Exp[100000];
            int           length1 = 0;
            int           length2 = 0;

            while (dr.Read())
            {
                var abc = dr.GetValue(0);
                tempuid[i] = Convert.ToDouble(abc);
                var abc1 = dr.GetValue(1);
                tempexp[i] = Convert.ToDouble(abc1);
                var abc2 = dr.GetValue(2);
                tempexp[i] = Convert.ToDouble(abc2);

                dataexp[i]     = new Pid_UID_Exp();
                dataexp[i].PID = Convert.ToInt32(abc);
                dataexp[i].UID = Convert.ToInt32(abc1);
                dataexp[i].EXP = Convert.ToInt32(abc2);

                i++;
            }
            length1 = i;
            bindingSource2.DataSource = dataexp;
            dataGridView2.DataSource  = bindingSource2;



            int j = 0;

            double[]      tempuid2 = new double[100000];
            double[]      tempexp2 = new double[100000];
            Pid_UID_Exp[] dataexp2 = new Pid_UID_Exp[100000];

            OracleCommand cmd2   = conn.CreateCommand();
            String        query2 = "SELECT patient.p_id, ap.u_id, mn.exp FROM  mrnaexpression mn INNER JOIN arrayprobe ap ON mn.pb_id=ap.pb_id  INNER JOIN (SELECT a.s_id, b.p_id  FROM clinicalsample a, patientsample b WHERE a.s_id = b.s_id AND b.p_id  IN (SELECT p_id  FROM diagnosis      WHERE ds_id IN (SELECT ds_id FROM disease        WHERE name != '" + glob.dis_glob + "'))) patient ON mn.s_id = patient.s_id AND ap.u_id IN(";

            query2 = query2 + glob.dataglob[0].UID;
            for (int i1 = 1; i1 < glob.length; i1++)
            {
                query2 = query2 + "," + glob.dataglob[i1].UID;
            }
            query2 = query2 + ") ORDER BY patient.p_id,ap.u_id";

            cmd2.CommandText = query2;
            OracleDataReader dr2 = cmd2.ExecuteReader();

            while (dr2.Read())
            {
                var abc = dr2.GetValue(0);
                tempuid2[j] = Convert.ToDouble(abc);
                var abc1 = dr2.GetValue(1);
                tempexp2[j] = Convert.ToDouble(abc1);
                var abc2 = dr2.GetValue(2);
                tempexp2[j] = Convert.ToDouble(abc2);

                dataexp2[j]     = new Pid_UID_Exp();
                dataexp2[j].PID = Convert.ToInt32(abc);
                dataexp2[j].UID = Convert.ToInt32(abc1);
                dataexp2[j].EXP = Convert.ToInt32(abc2);

                j++;
            }
            length2 = j;

            bindingSource3.DataSource = dataexp2;
            dataGridView3.DataSource  = bindingSource3;

            int[] test  = new int[glob.length];
            int[] test1 = new int[glob.length];
            int[] test2 = new int[glob.length];
            int[] test3 = new int[glob.length];
            int[] test4 = new int[glob.length];
            int[] test5 = new int[glob.length];


            int           l      = 0;
            OracleCommand cmd3   = conn.CreateCommand();
            String        query3 = "select * from test_samples where u_id in (";

            query3 = query3 + glob.dataglob[0].UID;
            for (int i1 = 1; i1 < glob.length; i1++)
            {
                query3 = query3 + "," + glob.dataglob[i1].UID;
            }
            query3 = query3 + ") ORDER BY u_id";

            cmd2.CommandText = query3;
            OracleDataReader dr3 = cmd2.ExecuteReader();

            while (dr3.Read())
            {
                var abc = dr3.GetValue(0);
                test[l] = Convert.ToInt32(abc);
                var abc1 = dr3.GetValue(1);
                test1[l] = Convert.ToInt32(abc1);
                var abc2 = dr3.GetValue(2);
                test2[l] = Convert.ToInt32(abc2);
                var abc3 = dr3.GetValue(3);
                test3[l] = Convert.ToInt32(abc3);
                var abc4 = dr3.GetValue(4);
                test4[l] = Convert.ToInt32(abc4);
                var abc5 = dr3.GetValue(5);
                test5[l] = Convert.ToInt32(abc5);
                l++;
            }
            int length3 = j;

            int[] f1 = new int[glob.length];
            int   b  = 0;

            double[] c1        = new double[50000];
            double[] c2        = new double[50000];
            double[] c3        = new double[50000];
            double[] c4        = new double[50000];
            double[] c5        = new double[50000];
            int      count_in1 = 0;

            for (int a = 0; a < length1; a++)
            {
                f1[b] = dataexp[a].EXP;
                b++;
                if (b == glob.length)
                {
                    b = 0;

                    c1[count_in1] = appExl.WorksheetFunction.Pearson(f1, test1);
                    c2[count_in1] = appExl.WorksheetFunction.Pearson(f1, test2);
                    c3[count_in1] = appExl.WorksheetFunction.Pearson(f1, test3);
                    c4[count_in1] = appExl.WorksheetFunction.Pearson(f1, test4);
                    c5[count_in1] = appExl.WorksheetFunction.Pearson(f1, test5);
                    count_in1++;
                }
            }

            int[] f2 = new int[glob.length];
            b = 0;
            double[] c6        = new double[50000];
            double[] c7        = new double[50000];
            double[] c8        = new double[50000];
            double[] c9        = new double[50000];
            double[] c10       = new double[50000];
            int      count_in2 = 0;

            for (int a = 0; a < length2; a++)
            {
                f2[b] = dataexp2[a].EXP;
                b++;
                if (b == glob.length)
                {
                    b = 0;

                    c6[count_in2]  = appExl.WorksheetFunction.Pearson(f2, test1);
                    c7[count_in2]  = appExl.WorksheetFunction.Pearson(f2, test2);
                    c8[count_in2]  = appExl.WorksheetFunction.Pearson(f2, test3);
                    c9[count_in2]  = appExl.WorksheetFunction.Pearson(f2, test4);
                    c10[count_in2] = appExl.WorksheetFunction.Pearson(f2, test5);
                    count_in2++;
                }
            }


            double t1 = TTest(c1, c6, count_in1, count_in2);
            double p1 = appExl.WorksheetFunction.TDist(Math.Abs(t1), (count_in1 + count_in2 - 2), 2);
            double t2 = TTest(c2, c7, count_in1, count_in2);
            double p2 = appExl.WorksheetFunction.TDist(Math.Abs(t2), (count_in1 + count_in2 - 2), 2);
            double t3 = TTest(c3, c8, count_in1, count_in2);
            double p3 = appExl.WorksheetFunction.TDist(Math.Abs(t3), (count_in1 + count_in2 - 2), 2);
            double t4 = TTest(c4, c9, count_in1, count_in2);
            double p4 = appExl.WorksheetFunction.TDist(Math.Abs(t4), (count_in1 + count_in2 - 2), 2);
            double t5 = TTest(c5, c10, count_in1, count_in2);
            double p5 = appExl.WorksheetFunction.TDist(Math.Abs(t5), (count_in1 + count_in2 - 2), 2);


            dataf[] data_final = new dataf[5];
            data_final[0]         = new dataf();
            data_final[0].PATIENT = "PATIENT 1";
            data_final[0].TVAL    = t1;
            data_final[0].PVAL    = p1;
            if (p1 < 0.01)
            {
                data_final[0].PREDICTION = "Classified as '" + glob.dis_glob + " disease : Patient belongs to group A";
            }
            else
            {
                data_final[0].PREDICTION = "Classified as not " + glob.dis_glob + " disease: Patient belongs to group B";
            }

            data_final[1]         = new dataf();
            data_final[1].PATIENT = "PATIENT 2";
            data_final[1].TVAL    = t2;
            data_final[1].PVAL    = p2;
            if (p2 < 0.01)
            {
                data_final[1].PREDICTION = "Classified as '" + glob.dis_glob + " disease : Patient belongs to group A";
            }
            else
            {
                data_final[1].PREDICTION = "Classified as not " + glob.dis_glob + " disease: Patient belongs to group B";
            }

            data_final[2]         = new dataf();
            data_final[2].PATIENT = "PATIENT 3";
            data_final[2].TVAL    = t3;
            data_final[2].PVAL    = p3;
            if (p3 < 0.01)
            {
                data_final[2].PREDICTION = "Classified as '" + glob.dis_glob + " disease : Patient belongs to group A";
            }
            else
            {
                data_final[2].PREDICTION = "Classified as not " + glob.dis_glob + " disease: Patient belongs to group B";
            }

            data_final[3]         = new dataf();
            data_final[3].PATIENT = "PATIENT 4";
            data_final[3].TVAL    = t4;
            data_final[3].PVAL    = p4;
            if (p4 < 0.01)
            {
                data_final[3].PREDICTION = "Classified as '" + glob.dis_glob + " disease : Patient belongs to group A";
            }
            else
            {
                data_final[3].PREDICTION = "Classified as not " + glob.dis_glob + " disease: Patient belongs to group B";
            }

            data_final[4]         = new dataf();
            data_final[4].PATIENT = "PATIENT 5";
            data_final[4].TVAL    = t5;
            data_final[4].PVAL    = p5;
            if (p5 < 0.01)
            {
                data_final[4].PREDICTION = "Classified as '" + glob.dis_glob + " disease : Patient belongs to group A";
            }
            else
            {
                data_final[4].PREDICTION = "Classified as not " + glob.dis_glob + " disease: Patient belongs to group B";
            }

            bindingSource4.DataSource = data_final;
            dataGridView4.DataSource  = bindingSource4;
        }
        private void button1_Click(object sender, EventArgs e)
        {
            string           oradb = "DATA SOURCE=aos.acsu.buffalo.edu:1521/aos.buffalo.edu;PASSWORD=cse601;USER ID=AVIJEETM";
            OracleConnection conn  = new OracleConnection(oradb); // C#

            IExcel.Application appExl;
            appExl = new IExcel.Application();

            conn.Open();
            OracleCommand cmd = conn.CreateCommand();

            cmd.CommandText = "SELECT ap.u_id, mn.exp FROM mrnaexpression mn INNER JOIN arrayprobe ap ON mn.pb_id=ap.pb_id  WHERE mn.s_id IN (SELECT s_id  FROM clinicalsample WHERE s_id  IN (SELECT s_id  FROM patientsample  WHERE p_id  IN (SELECT p_id  FROM diagnosis      WHERE ds_id IN (SELECT ds_id FROM disease        WHERE name = '" + disease + "'))))ORDER BY ap.u_id";
            OracleDataReader dr      = cmd.ExecuteReader();
            OracleDataReader dr_temp = dr;
            int i = 0;

            double[]  tempuid = new double[100000];
            double[]  tempexp = new double[100000];
            Exp_UID[] dataexp = new Exp_UID[100000];
            int       length1 = 0;
            int       length2 = 0;

            while (dr.Read())
            {
                var abc  = dr.GetValue(0);
                var abc1 = dr.GetValue(1);
                tempuid[i] = Convert.ToDouble(abc);
                tempexp[i] = Convert.ToDouble(abc1);

                dataexp[i]     = new Exp_UID();
                dataexp[i].UID = Convert.ToInt32(abc);
                dataexp[i].EXP = Convert.ToInt32(abc1);

                i++;
            }
            length1 = i;



            int j = 0;

            double[]  tempuid2 = new double[100000];
            double[]  tempexp2 = new double[100000];
            Exp_UID[] dataexp2 = new Exp_UID[100000];

            OracleCommand cmd2 = conn.CreateCommand();

            cmd2.CommandText = "SELECT ap.u_id, mn.exp FROM mrnaexpression mn INNER JOIN arrayprobe ap ON mn.pb_id=ap.pb_id  WHERE mn.s_id IN (SELECT s_id  FROM clinicalsample WHERE s_id  IN (SELECT s_id  FROM patientsample  WHERE p_id  IN (SELECT p_id  FROM diagnosis      WHERE ds_id IN (SELECT ds_id FROM disease        WHERE name != '" + disease + "'))))ORDER BY ap.u_id";
            OracleDataReader dr2 = cmd2.ExecuteReader();

            while (dr2.Read())
            {
                var abc = dr2.GetValue(0);
                tempuid2[j] = Convert.ToDouble(abc);
                var abc1 = dr2.GetValue(1);
                tempexp2[j] = Convert.ToDouble(abc1);

                dataexp2[j]     = new Exp_UID();
                dataexp2[j].UID = Convert.ToInt32(abc);
                dataexp2[j].EXP = Convert.ToInt32(abc1);

                j++;
            }
            length2 = j;


            Uid[]  dataexp3 = new Uid[100000];
            int[]  arr      = new int[500];
            int    c        = 0;
            double prev     = tempuid[0];

            for (int k = 0; k < length1; k++)
            {
                double[] arr1   = new double[500];
                double[] arr2   = new double[500];
                int      count1 = 0;
                int      count2 = 0;


                for (int x = 0; x < length2; x++)
                {
                    if (tempuid[k] == tempuid2[x])
                    {
                        arr1[count1] = tempexp[k];
                        count1++;
                        arr2[count2] = tempexp2[x];
                        count2++;
                        prev = tempuid[k];
                        k++;
                        x++;
                        while (prev == tempuid[k] && k < length1)
                        {
                            arr1[count1] = tempexp[k];
                            count1++;
                            k++;
                        }
                        k--;
                        while (prev == tempuid2[x] && x < length2)
                        {
                            arr2[count2] = tempexp2[x];
                            count2++;
                            x++;
                        }
                        int q = Convert.ToInt32(prev);

                        /*if (q == 48199244)
                         * {
                         *  int assads;
                         *  assads = q + 1;
                         * }*/
                        double t = TTest(arr1, arr2, count1, count2);
                        double p = appExl.WorksheetFunction.TDist(Math.Abs(t), (count1 + count2 - 2), 2);
                        if (p < 0.01)
                        {
                            dataexp3[c]     = new Uid();
                            dataexp3[c].UID = Convert.ToInt32(prev);
                            c++;
                        }
                        break;
                    }
                }
            }


            bindingSource3.DataSource = dataexp3;
            dataGridView1.DataSource  = bindingSource3;

            OracleCommand cmd4   = conn.CreateCommand();
            String        query4 = "SELECT patient.p_id, ap.u_id, mn.exp FROM  mrnaexpression mn INNER JOIN arrayprobe ap ON mn.pb_id=ap.pb_id  INNER JOIN (SELECT a.s_id, b.p_id  FROM clinicalsample a, patientsample b WHERE a.s_id = b.s_id AND b.p_id  IN (SELECT p_id  FROM diagnosis      WHERE ds_id IN (SELECT ds_id FROM disease        WHERE name = '" + disease + "'))) patient ON mn.s_id = patient.s_id AND ap.u_id IN(";

            query4 = query4 + dataexp3[0].UID;
            for (int i1 = 1; i1 < c; i1++)
            {
                query4 = query4 + "," + dataexp3[i1].UID;
            }
            query4 = query4 + ") ORDER BY patient.p_id,ap.u_id";

            cmd4.CommandText = query4;
            OracleDataReader dr4 = cmd4.ExecuteReader();
            int y = 0;

            double[]      tempuid3 = new double[100000];
            double[]      tempexp3 = new double[100000];
            Pid_UID_Exp[] dataexp4 = new Pid_UID_Exp[100000];
            int           length3  = 0;
            int           length4  = 0;

            while (dr4.Read())
            {
                var abc = dr4.GetValue(0);
                tempuid3[y] = Convert.ToDouble(abc);
                var abc1 = dr4.GetValue(1);
                tempexp3[y] = Convert.ToDouble(abc1);
                var abc2 = dr4.GetValue(2);
                tempexp3[y] = Convert.ToDouble(abc2);

                dataexp4[y]     = new Pid_UID_Exp();
                dataexp4[y].PID = Convert.ToInt32(abc);
                dataexp4[y].UID = Convert.ToInt32(abc1);
                dataexp4[y].EXP = Convert.ToInt32(abc2);

                y++;
            }
            length3 = y;



            int z = 0;

            double[]      tempuid5 = new double[100000];
            double[]      tempexp5 = new double[100000];
            Pid_UID_Exp[] dataexp5 = new Pid_UID_Exp[100000];

            OracleCommand cmd5   = conn.CreateCommand();
            String        query5 = "SELECT patient.p_id, ap.u_id, mn.exp FROM  mrnaexpression mn INNER JOIN arrayprobe ap ON mn.pb_id=ap.pb_id  INNER JOIN (SELECT a.s_id, b.p_id  FROM clinicalsample a, patientsample b WHERE a.s_id = b.s_id AND b.p_id  IN (SELECT p_id  FROM diagnosis      WHERE ds_id IN (SELECT ds_id FROM disease        WHERE name != '" + disease + "'))) patient ON mn.s_id = patient.s_id AND ap.u_id IN(";

            query5 = query5 + dataexp3[0].UID;
            for (int i1 = 1; i1 < c; i1++)
            {
                query5 = query5 + "," + dataexp3[i1].UID;
            }
            query5 = query5 + ") ORDER BY patient.p_id,ap.u_id";

            cmd5.CommandText = query5;
            OracleDataReader dr5 = cmd5.ExecuteReader();

            while (dr5.Read())
            {
                var abc = dr5.GetValue(0);
                tempuid5[z] = Convert.ToDouble(abc);
                var abc1 = dr5.GetValue(1);
                tempexp5[z] = Convert.ToDouble(abc1);
                var abc2 = dr5.GetValue(2);
                tempexp5[z] = Convert.ToDouble(abc2);

                dataexp5[z]     = new Pid_UID_Exp();
                dataexp5[z].PID = Convert.ToInt32(abc);
                dataexp5[z].UID = Convert.ToInt32(abc1);
                dataexp5[z].EXP = Convert.ToInt32(abc2);

                z++;
            }
            length4 = z;



            int[] test  = new int[c];
            int[] test1 = new int[c];
            int[] test2 = new int[c];
            int[] test3 = new int[c];
            int[] test4 = new int[c];
            int[] test5 = new int[c];


            int           l      = 0;
            OracleCommand cmd6   = conn.CreateCommand();
            String        query6 = "select * from test_samples where u_id in (";

            query6 = query6 + dataexp3[0].UID;
            for (int i1 = 1; i1 < c; i1++)
            {
                query6 = query6 + "," + dataexp3[i1].UID;
            }
            query6 = query6 + ") ORDER BY u_id";

            cmd2.CommandText = query6;
            OracleDataReader dr6 = cmd2.ExecuteReader();

            while (dr6.Read())
            {
                var abc = dr6.GetValue(0);
                test[l] = Convert.ToInt32(abc);
                var abc1 = dr6.GetValue(1);
                test1[l] = Convert.ToInt32(abc1);
                var abc2 = dr6.GetValue(2);
                test2[l] = Convert.ToInt32(abc2);
                var abc3 = dr6.GetValue(3);
                test3[l] = Convert.ToInt32(abc3);
                var abc4 = dr6.GetValue(4);
                test4[l] = Convert.ToInt32(abc4);
                var abc5 = dr6.GetValue(5);
                test5[l] = Convert.ToInt32(abc5);
                l++;
            }

            int[] f1 = new int[c];
            int   b  = 0;

            double[] c1        = new double[50000];
            double[] c2        = new double[50000];
            double[] c3        = new double[50000];
            double[] c4        = new double[50000];
            double[] c5        = new double[50000];
            int      count_in1 = 0;

            for (int a = 0; a < length3; a++)
            {
                f1[b] = dataexp4[a].EXP;
                b++;
                if (b == c)
                {
                    b = 0;

                    c1[count_in1] = appExl.WorksheetFunction.Pearson(f1, test1);
                    c2[count_in1] = appExl.WorksheetFunction.Pearson(f1, test2);
                    c3[count_in1] = appExl.WorksheetFunction.Pearson(f1, test3);
                    c4[count_in1] = appExl.WorksheetFunction.Pearson(f1, test4);
                    c5[count_in1] = appExl.WorksheetFunction.Pearson(f1, test5);
                    count_in1++;
                }
            }

            int[] f2 = new int[c];
            b = 0;
            double[] c6        = new double[50000];
            double[] c7        = new double[50000];
            double[] c8        = new double[50000];
            double[] c9        = new double[50000];
            double[] c10       = new double[50000];
            int      count_in2 = 0;

            for (int a = 0; a < length4; a++)
            {
                f2[b] = dataexp5[a].EXP;
                b++;
                if (b == c)
                {
                    b = 0;

                    c6[count_in2]  = appExl.WorksheetFunction.Pearson(f2, test1);
                    c7[count_in2]  = appExl.WorksheetFunction.Pearson(f2, test2);
                    c8[count_in2]  = appExl.WorksheetFunction.Pearson(f2, test3);
                    c9[count_in2]  = appExl.WorksheetFunction.Pearson(f2, test4);
                    c10[count_in2] = appExl.WorksheetFunction.Pearson(f2, test5);
                    count_in2++;
                }
            }


            double t1 = TTest(c1, c6, count_in1, count_in2);
            double p1 = appExl.WorksheetFunction.TDist(Math.Abs(t1), (count_in1 + count_in2 - 2), 2);
            double t2 = TTest(c2, c7, count_in1, count_in2);
            double p2 = appExl.WorksheetFunction.TDist(Math.Abs(t2), (count_in1 + count_in2 - 2), 2);
            double t3 = TTest(c3, c8, count_in1, count_in2);
            double p3 = appExl.WorksheetFunction.TDist(Math.Abs(t3), (count_in1 + count_in2 - 2), 2);
            double t4 = TTest(c4, c9, count_in1, count_in2);
            double p4 = appExl.WorksheetFunction.TDist(Math.Abs(t4), (count_in1 + count_in2 - 2), 2);
            double t5 = TTest(c5, c10, count_in1, count_in2);
            double p5 = appExl.WorksheetFunction.TDist(Math.Abs(t5), (count_in1 + count_in2 - 2), 2);


            dataf[] data_final = new dataf[5];
            data_final[0]         = new dataf();
            data_final[0].PATIENT = "PATIENT 1";
            data_final[0].TVAL    = t1;
            data_final[0].PVAL    = p1;
            if (p1 < 0.01)
            {
                data_final[0].PREDICTION = "Classified as '" + glob.dis_glob + " disease : Patient belongs to group A";
            }
            else
            {
                data_final[0].PREDICTION = "Classified as not " + glob.dis_glob + " disease: Patient belongs to group B";
            }

            data_final[1]         = new dataf();
            data_final[1].PATIENT = "PATIENT 2";
            data_final[1].TVAL    = t2;
            data_final[1].PVAL    = p2;
            if (p2 < 0.01)
            {
                data_final[1].PREDICTION = "Classified as '" + glob.dis_glob + " disease : Patient belongs to group A";
            }
            else
            {
                data_final[1].PREDICTION = "Classified as not " + glob.dis_glob + " disease: Patient belongs to group B";
            }

            data_final[2]         = new dataf();
            data_final[2].PATIENT = "PATIENT 3";
            data_final[2].TVAL    = t3;
            data_final[2].PVAL    = p3;
            if (p3 < 0.01)
            {
                data_final[2].PREDICTION = "Classified as '" + glob.dis_glob + " disease : Patient belongs to group A";
            }
            else
            {
                data_final[2].PREDICTION = "Classified as not " + glob.dis_glob + " disease: Patient belongs to group B";
            }

            data_final[3]         = new dataf();
            data_final[3].PATIENT = "PATIENT 4";
            data_final[3].TVAL    = t4;
            data_final[3].PVAL    = p4;
            if (p4 < 0.01)
            {
                data_final[3].PREDICTION = "Classified as '" + glob.dis_glob + " disease : Patient belongs to group A";
            }
            else
            {
                data_final[3].PREDICTION = "Classified as not " + glob.dis_glob + " disease: Patient belongs to group B";
            }

            data_final[4]         = new dataf();
            data_final[4].PATIENT = "PATIENT 5";
            data_final[4].TVAL    = t5;
            data_final[4].PVAL    = p5;
            if (p5 < 0.01)
            {
                data_final[4].PREDICTION = "Classified as '" + glob.dis_glob + " disease : Patient belongs to group A";
            }
            else
            {
                data_final[4].PREDICTION = "Classified as not " + glob.dis_glob + " disease: Patient belongs to group B";
            }

            bindingSource4.DataSource = data_final;
            dataGridView4.DataSource  = bindingSource4;
            conn.Close();
        }