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();
}
