예제 #1
0
        /*
         * select * from shooters.shooter, shooters.deathrowpop where drNAME LIKE '%' || Upper(first) || '%' AND drName LIKE '%' || Upper(last) || '%'
         */

        //  select* from shooters.shooter, shooters.executed where Upper(ename) LIKE '%' || Upper(first) || '%' AND upper(ename) LIKE '%' || Upper(last) || '%'
        private void populateDeathRowPopTXTState()
        {
            string          path  = @"C:\Users\Will Regan\Desktop\PSU\databases\deathrowpop\US Military.txt";
            List <deathrow> _list = TableUtils.populateDeathRowPopTXTState <deathrow>(path, "US");

            for (int i = 0; i < _list.Count; i++)
            {
                string query = "insert into shooters.deathrowpop (drState, drId, drName, drRace) values (@drState, @drId, @drName, @DrRace)";
                List <addWithValue> _values = new List <addWithValue>();
                _values.Add(new addWithValue("@drState", _list[i].drState));
                _values.Add(new addWithValue("@drId", _list[i].drId));
                _values.Add(new addWithValue("@drName", _list[i].drName));
                _values.Add(new addWithValue("@drRace", _list[i].drRace));
                QueryUtils.query(query, _values);
            }
        }