private void cmdaltas_Click(object sender, EventArgs e) { Agregar a = new Agregar(); a.bandera = bandera; a.Text = bandera.ToString();; modif = false; a.modif = modif; a.Show(); this.Hide(); }
public void modi() { Conectar.conexion(); dataGridView1.CellBeginEdit += dataGridView1_CellBeginEdit; Agregar f*g = new Agregar(); if (bandera == "Liga") { f*g.textBox7.Enabled = false; string val = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["id_liga"].Value.ToString(); SqlCommand recorrer = new SqlCommand(string.Format("Select * from liga where id_liga = '{0}'", val), Conectar.conexion()); SqlDataReader leer = recorrer.ExecuteReader(); while (leer.Read()) { f*g.textBox7.Text = leer.GetString(0); f*g.textBox1.Text = leer.GetString(1); f*g.textBox2.Text = leer.GetString(2); f*g.textBox3.Text = leer.GetString(3); f*g.comboBox1.Text = leer.GetString(4); } leer.Close(); f*g.bandera = bandera; modif = true; f*g.modif = modif; f*g.BackgroundImage = global :: WindowsFormsApplication1.Properties.Resources.mlb_logo_wide; f*g.Text = bandera.ToString(); f*g.Show(); this.Hide(); } else if (bandera == "Jugador") { f*g.textBox7.Enabled = false; string val = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["id_jugador"].Value.ToString(); SqlCommand recorrer = new SqlCommand(string.Format("Select * from jugador where id_jugador = '{0}'", val), Conectar.conexion()); SqlDataReader leer = recorrer.ExecuteReader(); while (leer.Read()) { f*g.textBox7.Text = leer.GetString(0); f*g.textBox1.Text = leer.GetString(1); f*g.textBox2.Text = leer.GetString(2); f*g.textBox6.Text = leer.GetString(3); f*g.textBox3.Text = leer.GetString(4); f*g.textBox4.Text = leer.GetString(5); f*g.textBox5.Text = leer.GetString(6); f*g.comboBox1.Text = leer.GetString(7); } leer.Close(); f*g.bandera = bandera; modif = true; f*g.modif = modif; f*g.BackgroundImage = global :: WindowsFormsApplication1.Properties.Resources.imagen; f*g.Text = bandera.ToString();; f*g.Show(); this.Hide(); } else if (bandera == "Partido") { f*g.textBox7.Enabled = false; string val = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["id_partido"].Value.ToString(); SqlCommand recorrer = new SqlCommand(string.Format("Select * from partido where id_partido = '{0}'", val), Conectar.conexion()); SqlDataReader leer = recorrer.ExecuteReader(); while (leer.Read()) { f*g.textBox7.Text = leer.GetString(0); f*g.textBox3.Text = leer.GetString(1); f*g.textBox2.Text = leer.GetString(2); f*g.comboBox2.Text = leer.GetString(3); f*g.comboBox3.Text = leer.GetString(4); f*g.textBox1.Text = leer.GetString(5); f*g.textBox4.Text = leer.GetString(6); f*g.comboBox1.Text = leer.GetString(7); } leer.Close(); f*g.bandera = bandera; modif = true; f*g.modif = modif; f*g.Text = bandera.ToString();; f*g.Show(); this.Hide(); } else if (bandera == "Equipo") { f*g.textBox7.Enabled = false; string val = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["id_equipo"].Value.ToString(); SqlCommand recorrer = new SqlCommand(string.Format("Select * from equipo where id_equipo = '{0}'", val), Conectar.conexion()); SqlDataReader leer = recorrer.ExecuteReader(); while (leer.Read()) { f*g.textBox7.Text = leer.GetString(0); f*g.textBox1.Text = leer.GetString(1); f*g.textBox3.Text = leer.GetString(2); f*g.textBox2.Text = leer.GetString(3); f*g.maskedTextBox1.Text = leer.GetString(4); f*g.comboBox1.Text = leer.GetString(5); } leer.Close(); f*g.bandera = bandera; modif = true; f*g.modif = modif; f*g.BackgroundImage = global ::WindowsFormsApplication1.Properties.Resources.dallas_cowboys; f*g.Text = bandera.ToString();; f*g.Show(); this.Hide(); } else { MessageBox.Show("ERROR"); } Conectar.conexion().Close(); }