protected void Page_Load(object sender, EventArgs e) { con = new SqlConnection(conn); if (!IsPostBack) { Dd2.Items.Insert(0, "select"); SqlDataAdapter da = new SqlDataAdapter(); SqlCommand cmd = new SqlCommand("Select * FROM scrum_roles2"); SqlDataAdapter da1 = new SqlDataAdapter(); SqlCommand cmd1 = new SqlCommand("Select * FROM sprints"); // SqlCommand cmd2 = new SqlCommand("Select * FROM master where [Backlog Name]='"+ s +"'"); DataTable dt1 = new DataTable(); DataTable dt2 = new DataTable(); da.SelectCommand = cmd; da.SelectCommand.Connection = con; da.Fill(dt1); Dd1.DataSource = dt1; Dd1.DataTextField = "Name"; Dd1.DataValueField = "Name"; Dd1.DataBind(); da1.SelectCommand = cmd1; da1.SelectCommand.Connection = con; da1.Fill(dt2); Dd2.DataSource = dt2; Dd2.DataTextField = "id"; Dd2.DataValueField = "id"; Dd2.DataBind(); Dd2.Items.Insert(0, new ListItem("General", "General")); } }
protected void Page_Load(object sender, EventArgs e) { DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(); SqlCommand cmd = new SqlCommand("select * from scrum_roles2", con); da.SelectCommand = cmd; da.SelectCommand.Connection = con; da.Fill(dt); if (dt.Rows.Count > 0) { Dd1.DataSource = dt; Dd1.DataTextField = "Name"; Dd1.DataValueField = "Name"; Dd1.DataBind(); } DataTable dt1 = new DataTable(); SqlDataAdapter da1 = new SqlDataAdapter(); SqlCommand cmd1 = new SqlCommand("select * from sprints", con); da.SelectCommand = cmd1; da.SelectCommand.Connection = con; da.Fill(dt1); Dd2.Items.Insert(0, new ListItem("select", "")); if (dt1.Rows.Count > 0) { Dd2.DataSource = dt1; Dd2.DataTextField = "id"; Dd2.DataValueField = "id"; Dd2.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { con = new SqlConnection(conn); if (!IsPostBack) { if (Session["username"] == null || Session["password"] == null) { Response.Redirect("dashboard.aspx"); } SqlCommand cmd1 = new SqlCommand("Select * FROM sprints"); // SqlCommand cmd2 = new SqlCommand("Select * FROM master where [Backlog Name]='"+ s +"'"); DataTable dt1 = new DataTable(); DataTable dt2 = new DataTable(); SqlDataAdapter da1 = new SqlDataAdapter(); da1.SelectCommand = cmd1; da1.SelectCommand.Connection = con; da1.Fill(dt2); Dd2.DataSource = dt2; Dd2.DataTextField = "id"; Dd2.DataValueField = "id"; Dd2.DataBind(); Dd2.Items.Insert(0, new ListItem("select", "")); Dd2_SelectedIndexChanged(null, null); } }
protected void Page_Load(object sender, EventArgs e) { con = new SqlConnection(conn); if (!IsPostBack) { con.Open(); if (Session["username"] == null && Session["password"] == null) { Response.Redirect("dashboard.aspx"); } DataTable var = new DataTable(); SqlDataAdapter vAR = new SqlDataAdapter("select * from scrum_master1 where Username = '******' and Password = '******' ", con); vAR.Fill(var); if (var.Rows.Count == 0) { Response.Write("<script>alert('only scrum master create sprints')</script>"); Response.Redirect("dashboard.aspx"); } SqlDataAdapter da = new SqlDataAdapter(); SqlCommand cmd = new SqlCommand("Select * FROM product_backlog"); DataTable dt1 = new DataTable(); da.SelectCommand = cmd; da.SelectCommand.Connection = con; da.Fill(dt1); Dd2.DataSource = dt1; Dd2.DataTextField = "Name"; Dd2.DataValueField = "Name"; Dd2.DataBind(); // s1 = Dd2.SelectedValue.ToString(); Dd2_SelectedIndexChanged(null, null); } }
protected void Page_Load(object sender, EventArgs e) { con = new SqlConnection(conn); if (!IsPostBack) { con.Open(); if (Session["username"] == null && Session["password"] == null) { Response.Redirect("login.aspx"); } SqlDataAdapter da = new SqlDataAdapter(); SqlCommand cmd = new SqlCommand("Select * FROM scrum_roles2 where Role='Developer'"); SqlDataAdapter da1 = new SqlDataAdapter(); SqlCommand cmd1 = new SqlCommand("Select * FROM product_backlog "); SqlDataAdapter da2 = new SqlDataAdapter(); // SqlCommand cmd2 = new SqlCommand("Select * FROM master where [Backlog Name]='"+ s +"'"); DataTable dt1 = new DataTable(); DataTable dt2 = new DataTable(); DataTable dt3 = new DataTable(); da.SelectCommand = cmd; da.SelectCommand.Connection = con; da.Fill(dt1); Dd1.DataSource = dt1; Dd1.DataTextField = "Name"; Dd1.DataValueField = "Name"; Dd1.DataBind(); da1.SelectCommand = cmd1; da1.SelectCommand.Connection = con; da1.Fill(dt2); Dd2.DataSource = dt2; Dd2.DataTextField = "Name"; Dd2.DataValueField = "Name"; Dd2.DataBind(); // s = Dd2.SelectedValue.ToString(); //SqlCommand cmd2 = new SqlCommand("Select * FROM master"); //da2.SelectCommand = cmd2; //da2.SelectCommand.Connection = con; //da2.Fill(dt3); //Dd3.DataSource = dt3; //Dd3.DataTextField = "feature"; //Dd3.DataValueField = "feature"; //Dd3.DataBind(); //con.Close(); } else { Response.Redirect("login.aspx"); } }