protected void Page_Load(object sender, EventArgs e) { FootbalLinqDataDataContext linqCon = new FootbalLinqDataDataContext(); LoadTeamsDDL(linqCon); LoadPositionDDL(linqCon); string CS = "data source=.; database = FantasyFootball; integrated security=SSPI"; using (SqlConnection con = new SqlConnection(CS)) { SqlDataAdapter da = new SqlDataAdapter("sp_GetPlayersByFilter", con); da.SelectCommand.CommandType = CommandType.StoredProcedure; DataSet ds = new DataSet(); DataTable dt = new DataTable(); da.Fill(ds); dt = ds.Tables["Players"]; int i = 1; foreach (DataRow row in ds.Tables[0].Rows) { string divId = "div" + i; string script = "<script type='text/javascript'>alert('" + row["last_name"] + "');</script>"; Response.Write(script); CreateDiv(divId); i++; } } }
private void LoadTeamsDDL(FootbalLinqDataDataContext linqCon) { ddlTeams.DataSource = linqCon.Teams; ddlTeams.DataTextField = "team_name"; ddlTeams.DataValueField = "team_id"; ddlTeams.DataBind(); ddlTeams.Items.Insert(0, new ListItem(String.Empty, String.Empty)); ddlTeams.SelectedIndex = 0; }
private void LoadPositionDDL(FootbalLinqDataDataContext linqCon) { ddlPositions.DataSource = linqCon.Positions; ddlPositions.DataTextField = "position_name"; ddlPositions.DataValueField = "position_id"; ddlPositions.DataBind(); ddlPositions.Items.Insert(0, new ListItem(String.Empty, String.Empty)); ddlPositions.SelectedIndex = 0; }