private void listTeamSponsorships_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
TeamSponsorship secilen = new TeamSponsorship();
secilen = (TeamSponsorship)listTeamSponsorships.SelectedItem;
grd1.DataContext = secilen;
}
public void allTeamSponsorships()
{
teamSponsorships = new ObservableCollection <TeamSponsorship>();
command = new SqlCommand();
command.Connection = connection;
command.CommandText = "SELECT Sponsor.sponsorName, Sponsor.sponsorID, TeamSponsorship.sponsorshipContractPeriod, TeamSponsorship.sponsorshipPayment, Team.teamName, Team.teamID " +
"FROM TeamSponsorship INNER JOIN Sponsor ON TeamSponsorship.sponsorID = Sponsor.sponsorID " +
"INNER JOIN Team ON TeamSponsorship.teamID = Team.teamID ORDER BY Sponsor.sponsorID ASC";
connection.Open();
reader = command.ExecuteReader();
while (reader.Read())
{
teamSponsorship = new TeamSponsorship();
teamSponsorship.TeamID = (int)reader["teamID"];
teamSponsorship.TeamName = (string)reader["teamName"];
teamSponsorship.SponsorID = (int)reader["sponsorID"];
teamSponsorship.SponsorName = (string)reader["sponsorName"];
teamSponsorship.SponsorshipContractPeriod = (int)reader["sponsorshipContractPeriod"];
Console.WriteLine(teamSponsorship.SponsorshipContractPeriod);
teamSponsorship.SponsorshipPayment = (int)reader["sponsorshipPayment"];
teamSponsorships.Add(teamSponsorship);
}
connection.Close();
listTeamSponsorships.ItemsSource = teamSponsorships;
}
