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