public void loadSingleSong(int songid) { try { cur_stz = 0; sqlQuery = "SELECT * FROM songs WHERE songid=" + songid + ";"; appDB = new AppDatabase(); reader = appDB.getSingle(sqlQuery); while (reader.Read()) { lblSongno.Text = "#" + reader["number"].ToString(); lblSongTitle.Text = vsbf.textRender(reader["title"].ToString()); songtext = reader["content"].ToString(); } appDB.sqlClose(); songstanzas = songtext.Split('`'); stanzas = songstanzas.Length; lblSongText.Text = vsbf.songRender(songstanzas[cur_stz]); } catch (Exception ex) { lblSongTitle.Text = "Song projection failed"; lblSongText.Text = "Oops! Song projection failed due to: " + ex.Message; } }
public void loadSingleSong(int songid) { try { txtSongContent.Clear(); sqlQuery = "SELECT * FROM songs WHERE songid=" + songid + ";"; appDB = new AppDatabase(); reader = appDB.getSingle(sqlQuery); while (reader.Read()) { txtSongContent.Text = vsbf.songRender(reader["content"].ToString()); } appDB.sqlClose(); } catch (Exception ex) { loadFeedback("Oops! Sorry song viewing failed: " + ex.Message, false, true); } }
public void loadBookDetails(string songid) { try { txtNotes.Clear(); sqlQuery = "SELECT * FROM books WHERE bookid=" + songid + ";"; appDB = new AppDatabase(); reader = appDB.getSingle(sqlQuery); while (reader.Read()) { txtBookTitle.Text = reader["title"].ToString(); txtBookCode.Text = reader["code"].ToString(); txtNotes.Text = reader["notes"].ToString(); lblInfo.Text = reader["songs"].ToString() + " songs"; } appDB.sqlClose(); } catch (Exception ex) { loadFeedback("Oops! Sorry book viewing failed: " + ex.Message, false, true); } }