protected void Page_Load(object sender, EventArgs e)
{
SampleDataContext dataContext = new SampleDataContext();
if (!IsPostBack)
{
ddlTeamSelect.DataSource = from team in dataContext.Teams
select team.team_name;
ddlTeamSelect.DataBind();
ddlPositionSelect.DataSource = from position in dataContext.Positions
orderby position.position_id
select position.position_name;
ddlPositionSelect.DataBind();
GridView1.DataSource = from player in dataContext.Players
where player.team_id == 1
orderby player.last_name ascending
select player;
GridView1.DataBind();
}
}
protected void btnFilter_Click(object sender, EventArgs e)
{
int newTeam = ddlTeamSelect.SelectedIndex + 1;
int newPosition = ddlPositionSelect.SelectedIndex + 1;
SampleDataContext sdc = new SampleDataContext();
GridView1.DataSource = from player in sdc.Players
from position in sdc.Positions
from team in sdc.Teams
where player.team_id == team.team_id && player.position_id == position.position_id &&
player.team_id == newTeam &&
player.position_id == newPosition
orderby player.last_name ascending
select new
{
player.last_name,
player.first_name,
position.position_name,
team.team_name
};
GridView1.DataBind();
}
