コード例 #1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Session["logado"] == null || (bool)Session["logado"] != true)
            {
                Response.Redirect("~/Login.aspx");
            }
            else
            {
                string login = (string)(Session["login"]);
                ClientScript.RegisterClientScriptBlock(Page.GetType(), "", "");
                //txtNome.Text = login;
            }

            //+ Session["login"]

            SqlConnection cnx = new SqlConnection(@"Data Source=APPCTX06SALLM\SQLEXPRESS;Initial Catalog=bd_rh_atestadoctx;User ID=sa;Password=todo@2015");

            cnx.Open();
            SqlDataAdapter adp = new SqlDataAdapter("Select * from tb_lancamento where login="******"login"], cnx);
            DataSet        dst = new DataSet();

            adp.Fill(dst);
            Consulta_status.DataSource = dst;
            Consulta_status.DataBind();
        }
コード例 #2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            SqlConnection cnx = new SqlConnection(@"Data Source=appctx06sallm\SQLEXPRESS; Initial Catalog=oi_internet; User Id=sa; Password=todo@2015;");

            cnx.Open();
            SqlDataAdapter adp = new SqlDataAdapter("  select * from tb_lancamento_euindico where resultado='venda'", cnx);
            DataSet        dst = new DataSet();

            adp.Fill(dst);
            Consulta_status.DataSource = dst;
            Consulta_status.DataBind();
        }
コード例 #3
0
        protected void Page_Load(object sender, EventArgs e)
        {
            string        login = (string)(Session["login"]);
            SqlConnection cnx   = new SqlConnection(@"Data Source=CARITA-PC\SQLEXPRESS;Initial Catalog=oi_internet;User ID=sa;Password=marcus123");

            cnx.Open();
            SqlDataAdapter adp = new SqlDataAdapter("Select * from tb_auditoria where re='" + login + "'", cnx);
            DataSet        dst = new DataSet();

            adp.Fill(dst);
            Consulta_status.DataSource = dst;
            Consulta_status.DataBind();
        }