private void button2_Click(object sender, EventArgs e) { EditTeam2 editTeam2 = new EditTeam2(); editTeam2.ShowDialog(); string sql = "SELECT dbo.Team.id, dbo.Team.name AS Название, dbo.Country.name AS Страна, dbo.Team.games AS Игр, dbo.Team.victori AS Побед, dbo.Team.loss AS Проигрышей, dbo.Team.country " + " FROM dbo.Team INNER JOIN " + " dbo.Country ON dbo.Team.country = dbo.Country.id "; adapter = new OleDbDataAdapter(sql, con); ds = new DataTable(); adapter.Fill(ds); dataGridView1.Columns.Clear(); dataGridView1.DataSource = ds; dataGridView1.Columns[0].Visible = false; dataGridView1.Columns[6].Visible = false; }
private void button1_Click(object sender, EventArgs e) { int tmp = dataGridView1.CurrentRow.Index; int nom = Convert.ToInt32(dataGridView1[0, tmp].Value); EditTeam2 editTeam2 = new EditTeam2(dataGridView1[1, tmp].Value.ToString(), dataGridView1[2, tmp].Value.ToString(), dataGridView1[3, tmp].Value.ToString(), dataGridView1[4, tmp].Value.ToString(), dataGridView1[5, tmp].Value.ToString(), Convert.ToInt32(dataGridView1[6, tmp].Value), nom ); editTeam2.ShowDialog(); string sql = "SELECT dbo.Team.id, dbo.Team.name AS Название, dbo.Country.name AS Страна, dbo.Team.games AS Игр, dbo.Team.victori AS Побед, dbo.Team.loss AS Проигрышей, dbo.Team.country " + " FROM dbo.Team INNER JOIN " + " dbo.Country ON dbo.Team.country = dbo.Country.id "; adapter = new OleDbDataAdapter(sql, con); ds = new DataTable(); adapter.Fill(ds); dataGridView1.Columns.Clear(); dataGridView1.DataSource = ds; dataGridView1.Columns[0].Visible = false; dataGridView1.Columns[6].Visible = false; }