Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SQLiteCommand cmd = new SQLiteCommand("SELECT id, damage_class_id, " +
- "(SELECT name FROM type_names WHERE type_names.type_id = types.id AND local_language_id = 1) AS name_ja, " +
- "(SELECT name FROM type_names WHERE type_names.type_id = types.id AND local_language_id = 9) AS name_en, " +
- "(SELECT name FROM type_names WHERE type_names.type_id = types.id AND local_language_id = 5) AS name_fr, " +
- "(SELECT name FROM type_names WHERE type_names.type_id = types.id AND local_language_id = 8) AS name_it, " +
- "(SELECT name FROM type_names WHERE type_names.type_id = types.id AND local_language_id = 6) AS name_de, " +
- "(SELECT name FROM type_names WHERE type_names.type_id = types.id AND local_language_id = 7) AS name_es, " +
- "(SELECT name FROM type_names WHERE type_names.type_id = types.id AND local_language_id = 3) AS name_ko " +
- "FROM types ORDER BY id", connVeekun);
- SQLiteDataReader reader = cmd.ExecuteReader();
- DataTable tblTypes = new DataTable();
- tblTypes.Load(reader);
- reader.Close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement