/* * 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); } }