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