protected void Page_Load(object sender, EventArgs e) { //redirect if workflow wasnt followed if (Session["login"] == null) { Response.Redirect("/"); } using (QueriesTableAdapters.sp_GetFirstNameFromLoginTableAdapter ta = new QueriesTableAdapters.sp_GetFirstNameFromLoginTableAdapter()) { using (Queries.sp_GetFirstNameFromLoginDataTable dt = new Queries.sp_GetFirstNameFromLoginDataTable()) { ta.Fill(dt, Session["login"].ToString().Trim().ToLowerInvariant()); lblWelcome.Text = string.Format(Resources.Account_Strings.Label_WelcomeRegistrationComplete, dt.Rows[0]["firstname"].ToString()); } } }