protected static IDNameList fillIDNameList(string selectStr)
{
//select personID and jump type 'SJ' mean
dbcmd.CommandText = selectStr;
LogB.SQL(dbcmd.CommandText.ToString());
dbcmd.ExecuteNonQuery();
SqliteDataReader reader = dbcmd.ExecuteReader();
IDNameList list = new IDNameList();
while(reader.Read()) {
IDName idname = new IDName( Convert.ToInt32(reader[0].ToString()),
reader[1].ToString());
LogB.SQL(idname.ToString());
list.Add(new IDName( Convert.ToInt32(reader[0].ToString()),
reader[1].ToString() ));
}
reader.Close();
return list;
}
