private void set_Manmber_table()
        {
            count_current_Member = 0;
            count_previous_Member = 0;
            count_insert_Member = 0;
            count_fail_Member = 0;
            #region Temp
            Database db = new Database();
            string query = "select * from member";
            DataTable dt = db.return_dataset(query);
            #endregion

            #region Main
            db = new Database("Data Source=(LOCAL);Initial Catalog=baselineMaster;User ID = sa;Password ="******"select * from member";
            DataTable dt_m = db.return_dataset(query);
            #endregion

            int Flag;

            count_previous_Member = dt_m.Rows.Count;
            foreach (DataRow r in dt.Rows)
            {

                Flag = 0;
                foreach (DataRow r1 in dt_m.Rows)
                {

                    if (r[14].ToString() == r1[14].ToString())
                    {
                        Flag = 1;

                    }

                }
                if (Flag == 0)
                {

                    query = "INSERT INTO member (member_no, mother_no, name, relation_no, age, dob, sex_no, marital_no, marital_year, education_no, weight, height, parity, khana_id, member_id, occupation_no)"
                        + "VALUES (" + r[0] + "," + r[1] + ",'" + r[2] + "'," + r[3] + "," + r[4] + ",'" + r[5] +
                        "'," + r[6] + "," + r[7] + "," + r[8] + "," + r[9] + "," + r[10] + "," + r[11] +   "," + r[12] + ",'" + r[13] + "','" + r[14] + "'," + r[15] + ")";
                    if (!db.Insert(query))
                    {
                        MessageBox.Show("Failed to insert");
                        count_fail_Member++;
                    }
                    else
                        count_insert_Member++;
                }

            }

            count_current_Member = count_previous_Member + count_insert_Member;
        }
        private void set_Cnc_table()
        {
            count_current_CNC = 0;
            count_previous_CNC = 0;
            count_insert_CNC = 0;
            count_fail_CNC = 0;

            #region Temp
            Database db = new Database();
            string query = "select * from CNC";
            DataTable dt = db.return_dataset(query);
            #endregion

            #region Main
            db = new Database("Data Source=(LOCAL);Initial Catalog=baselineMaster;User ID = sa;Password ="******"select * from CNC";
            DataTable dt_m = db.return_dataset(query);
            #endregion

            int Flag;

            count_previous_CNC = dt_m.Rows.Count;
            foreach(DataRow r in dt.Rows)
            {

                Flag = 0;
                foreach (DataRow r1 in dt_m.Rows)
                {

                    if (r[2].ToString() == r1[2].ToString())
                    {
                        Flag = 1;

                    }

                }
                if (Flag == 0)
                {
                    query = "INSERT INTO cnc  (cnc_no, union_id, cnc_id) VALUES (" + r[0] + ",'" + r[1] + "','" + r[2] + "')";
                    if (!db.Insert(query))
                    {
                        MessageBox.Show("Failed to insert");
                        count_fail_CNC++;
                    }
                    else
                        count_insert_CNC++;
                }
            }
            count_current_CNC = count_previous_CNC+count_insert_CNC;
        }
        private void set_Khana_table()
        {
            count_current_Khana = 0;
            count_previous_Khana = 0;
            count_insert_Khana = 0;
            count_fail_Khana = 0;
            #region Temp
            Database db = new Database();
            string query = "select * from khana";
            DataTable dt = db.return_dataset(query);
            #endregion

            #region Main
            db = new Database("Data Source=(LOCAL);Initial Catalog=baselineMaster;User ID = sa;Password ="******"select * from Khana";
            DataTable dt_m = db.return_dataset(query);
            #endregion

            int Flag;

            count_previous_Khana = dt_m.Rows.Count;
            foreach (DataRow r in dt.Rows)
            {

                Flag = 0;
                foreach (DataRow r1 in dt_m.Rows)
                {

                    if (r[30].ToString() == r1[30].ToString())
                    {
                        Flag = 1;

                    }

                }
                if (Flag == 0)
                {

                   query = "INSERT INTO khana ( khana_no,cnc_id,user_id,roof_no,wall_no,floor_no,water_source_no,evaluation_no,house_price,land_amount,land_price,cow,goat,hen,fruit_tree,vegitable_land,month_covered,bed,chair,radio,tv,tubewell,milky_cow,milky_goat,day_labourer,labour_days,latrine,enumerator,cno_name,entry_date, khana_id) VALUES ("
                            + r[0] + ",'" + r[1] + "','" + r[2] + "'," + r[3] + "," + r[4] + ","
                            + r[5] + "," + r[6] + "," + r[7] + "," + r[8] + ","
                            + r[9] + "," + r[10] + "," + r[11] + "," + r[12] + "," + r[13] + ","
                            + r[14] + "," + r[15] + "," + r[16] + "," + r[17] + "," + r[18] + ","
                            + r[19] + "," + r[20] + "," + r[21] + "," + r[22] + "," + r[23] + ","
                            + r[24] + "," + r[25] + "," + r[26] + ",'" + r[27] +"','"
                            + r[28] + "','" + r[29] + "','" + r[30] + "')";

                    if (!db.Insert(query))
                    {
                        MessageBox.Show("Failed to insert");
                        count_fail_Khana++;
                    }
                    else
                        count_insert_Khana++;
                }

            }

            count_current_Khana = count_previous_Khana + count_insert_Khana;
        }