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; }