Advertisement
Guest User

Untitled

a guest
Feb 12th, 2016
169
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.04 KB | None | 0 0
  1. private void GetPergunta(){
  2. using(IDbConnection dbConnection = new SqliteConnection(connectionString)){
  3. dbConnection.Open();
  4.  
  5. using(IDbCommand dbCommand = dbConnection.CreateCommand()){
  6. string sqlQuery = "SELECT * FROM " + sqliteTabelasPerguntas[sqliteIndexTabelaPergunta] + " WHERE doenca_id=@id LIMIT 1";
  7. dbCommand.Parameters.Add(new SqliteParameter("@id", doencaId));
  8. dbCommand.CommandText = sqlQuery;
  9.  
  10. using(IDataReader reader = dbCommand.ExecuteReader()){
  11. while(reader.Read()){
  12. pergunta = reader.GetString(1);
  13. alternativasId[0] = reader.GetInt32(3);
  14. alternativasId[1] = reader.GetInt32(4);
  15. alternativasId[2] = reader.GetInt32(5);
  16. alternativasId[3] = reader.GetInt32(6);
  17. alternativaCorretaId = reader.GetInt32(7);
  18. }
  19. dbConnection.Close();
  20. reader.Close();
  21. }
  22. }
  23. }
  24. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement