private void listPlayerSponsorships_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
PlayerSponsorship secilen = new PlayerSponsorship();
secilen = (PlayerSponsorship)listPlayerSponsorships.SelectedItem;
grd1.DataContext = secilen;
}
public void allPlayerSponsorships()
{
playerSponsorships = new ObservableCollection <PlayerSponsorship>();
command = new SqlCommand();
command.Connection = connection;
command.CommandText = "SELECT Sponsor.sponsorName, Sponsor.sponsorID, PlayerSponsorship.sponsorshipContractPeriod, PlayerSponsorship.sponsorshipPayment, Player.playerName, Player.playerID " +
"FROM PlayerSponsorship INNER JOIN Sponsor ON PlayerSponsorship.sponsorID = Sponsor.sponsorID " +
"INNER JOIN Player ON PlayerSponsorship.playerID = Player.playerID ORDER BY Sponsor.sponsorID ASC";
connection.Open();
reader = command.ExecuteReader();
while (reader.Read())
{
PlayerSponsorship playerSponsorship = new PlayerSponsorship();
playerSponsorship.PlayerID = (int)reader["playerID"];
playerSponsorship.PlayerName = (string)reader["playerName"];
playerSponsorship.SponsorID = (int)reader["sponsorID"];
playerSponsorship.SponsorName = (string)reader["sponsorName"];
playerSponsorship.SponsorshipContractPeriod = (int)reader["sponsorshipContractPeriod"];
playerSponsorship.SponsorshipPayment = (int)reader["sponsorshipPayment"];
playerSponsorships.Add(playerSponsorship);
}
connection.Close();
listPlayerSponsorships.ItemsSource = playerSponsorships;
}
