Ejemplos de Queries.sp_GetFirstNameFromLoginDataTable en C# (CSharp)

Ejemplo n.º 1

Archivo: RegistrationComplete.aspx.cs Proyecto: barnhill/BloodSpider

        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());
                }
            }
        }

Ejemplo n.º 2

Archivo: RegistrationComplete.aspx.cs Proyecto: springmin/BloodSpider

        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());
                }
            }
        }