protected void Page_Load(object sender, EventArgs e) { user = (User)Session["userObj"]; if (user == null) { Response.Redirect("Main.aspx"); return; } dbUtil = new DBUtil(); verse = dbUtil.GetRandomVerse(); GenVerseText(); GenClearArray(); GenRawArray(); Session["verseId"] = verse.GetId(); }
public void UpdateVerse(Verse verse) { connection.Open(); SqlCommand command = connection.CreateCommand(); command.CommandText = String.Format("UPDATE Verses SET BestTime = {0} WHERE (Id={1})", verse.GetBestTime(), verse.GetId()); command.ExecuteNonQuery(); connection.Close(); }