Advertisement
Guest User

Untitled

a guest
Nov 26th, 2014
142
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.01 KB | None | 0 0
  1. SQLiteCommand cmd = new SQLiteCommand("SELECT id, damage_class_id, " +
  2. "(SELECT name FROM type_names WHERE type_names.type_id = types.id AND local_language_id = 1) AS name_ja, " +
  3. "(SELECT name FROM type_names WHERE type_names.type_id = types.id AND local_language_id = 9) AS name_en, " +
  4. "(SELECT name FROM type_names WHERE type_names.type_id = types.id AND local_language_id = 5) AS name_fr, " +
  5. "(SELECT name FROM type_names WHERE type_names.type_id = types.id AND local_language_id = 8) AS name_it, " +
  6. "(SELECT name FROM type_names WHERE type_names.type_id = types.id AND local_language_id = 6) AS name_de, " +
  7. "(SELECT name FROM type_names WHERE type_names.type_id = types.id AND local_language_id = 7) AS name_es, " +
  8. "(SELECT name FROM type_names WHERE type_names.type_id = types.id AND local_language_id = 3) AS name_ko " +
  9. "FROM types ORDER BY id", connVeekun);
  10. SQLiteDataReader reader = cmd.ExecuteReader();
  11. DataTable tblTypes = new DataTable();
  12. tblTypes.Load(reader);
  13. reader.Close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement