Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void GetPergunta(){
- using(IDbConnection dbConnection = new SqliteConnection(connectionString)){
- dbConnection.Open();
- using(IDbCommand dbCommand = dbConnection.CreateCommand()){
- string sqlQuery = "SELECT * FROM " + sqliteTabelasPerguntas[sqliteIndexTabelaPergunta] + " WHERE doenca_id=@id LIMIT 1";
- dbCommand.Parameters.Add(new SqliteParameter("@id", doencaId));
- dbCommand.CommandText = sqlQuery;
- using(IDataReader reader = dbCommand.ExecuteReader()){
- while(reader.Read()){
- pergunta = reader.GetString(1);
- alternativasId[0] = reader.GetInt32(3);
- alternativasId[1] = reader.GetInt32(4);
- alternativasId[2] = reader.GetInt32(5);
- alternativasId[3] = reader.GetInt32(6);
- alternativaCorretaId = reader.GetInt32(7);
- }
- dbConnection.Close();
- reader.Close();
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement