private void getData()
{
string sqlDB;
sqlDB = @"SELECT dbo.FOOTBALL_CLUBS.ID_CLUB,
dbo.FOOTBALL_CLUBS.NAME_CLUB,
dbo.FOOTBALL_CLUBS.BUDGET_CLUB,
dbo.FOOTBALL_CLUBS.OPENING_DATE_CLUB,
dbo.FOOTBALL_CLUBS.STADIUM_CLUB,
dbo.FOOTBALL_CLUBS.RATING_CLUB,
NAME_LEAGUE,
NAME_CITY
FROM dbo.FOOTBALL_CLUBS
INNER JOIN dbo.LEAGUES on (dbo.FOOTBALL_CLUBS.ID_LEAGUE = dbo.LEAGUES.ID_LEAGUE)
INNER JOIN dbo.CITIES on (dbo.FOOTBALL_CLUBS.ID_CITY = dbo.CITIES.ID_CITY)
";
SqlDataAdapter sqlDA = new SqlDataAdapter(sqlDB, sqlCon);
DataTable dtTable = new DataTable();
sqlDA.Fill(dtTable);
List <Football_Clubs> lmf3 = new List <Football_Clubs>();
for (int i = 0; i < dtTable.Rows.Count; i++)
{
Football_Clubs temp = new Football_Clubs();
temp.city = new City();
temp.league = new Leagues();
temp.ID_CLUB = (int)dtTable.Rows[i]["ID_CLUB"];
temp.NAME_CLUB = dtTable.Rows[i]["NAME_CLUB"].ToString();
temp.BUDGET_CLUB = dtTable.Rows[i]["BUDGET_CLUB"].ToString();
temp.OPENING_DATE_CLUB = dtTable.Rows[i]["OPENING_DATE_CLUB"].ToString();
temp.STADIUM_CLUB = dtTable.Rows[i]["STADIUM_CLUB"].ToString();
temp.RATING_CLUB = dtTable.Rows[i]["RATING_CLUB"].ToString();
temp.city.NAME_CITY = dtTable.Rows[i]["NAME_CITY"].ToString();
temp.league.NAME_LEAGUE = dtTable.Rows[i]["NAME_LEAGUE"].ToString();
lmf3.Add(temp);
}
dataGridView2.DataSource = null;
dataGridView2.DataSource = lmf3;
}
private void buttonPokazatDannye_Click(object sender, EventArgs e)
{
string sqlDB;
sqlDB = @"SELECT dbo.FOOTBALL_CLUBS.ID_CLUB,
dbo.FOOTBALL_CLUBS.NAME_CLUB,
dbo.FOOTBALL_CLUBS.BUDGET_CLUB,
dbo.FOOTBALL_CLUBS.OPENING_DATE_CLUB,
dbo.FOOTBALL_CLUBS.STADIUM_CLUB,
dbo.FOOTBALL_CLUBS.ID_LEAGUE,
dbo.FOOTBALL_CLUBS.ID_CITY,
dbo.FOOTBALL_CLUBS.RATING_CLUB
FROM dbo.FOOTBALL_CLUBS
";
SqlDataAdapter sqlDA = new SqlDataAdapter(sqlDB, f1.sqlCon);
DataTable dtTable = new DataTable();
sqlDA.Fill(dtTable);
List <Football_Clubs> lmf3 = new List <Football_Clubs> ();
for (int i = 0; i < dtTable.Rows.Count; i++)
{
Football_Clubs temp = new Football_Clubs();
temp.city = new City();
temp.league = new Leagues();
temp.ID_CLUB = (int)dtTable.Rows[i]["ID_CLUB"];
temp.NAME_CLUB = dtTable.Rows[i]["NAME_CLUB"].ToString();
temp.BUDGET_CLUB = dtTable.Rows[i]["BUDGET_CLUB"].ToString();
temp.OPENING_DATE_CLUB = dtTable.Rows[i]["OPENING_DATE_CLUB"].ToString();
temp.STADIUM_CLUB = dtTable.Rows[i]["STADIUM_CLUB"].ToString();
temp.league.ID_LEAGUE = (int)dtTable.Rows[i]["ID_LEAGUE"];
temp.city.ID_CITY = (int)dtTable.Rows[i]["ID_CITY"];
temp.RATING_CLUB = dtTable.Rows[i]["RATING_CLUB"].ToString();
lmf3.Add(temp);
}
dataGridViewFootballClubs.DataSource = null;
dataGridViewFootballClubs.DataSource = lmf3;
}
