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