private void textBox1_TextChanged(object sender, EventArgs e)
{
comando.Connection = conexion.AbrirConexion();
SqlCommand cmd = new SqlCommand("buscar2", conectar);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Curp", textBox1.Text);
conectar.Close();
conectar.Open();
SqlDataReader reader = cmd.ExecuteReader();
// SqlDataReader leer = comando.ExecuteReader();
if (reader.Read())
{
gradotxt.Text = Convert.ToString(reader["Grado"]);
// if (reader.Read() == true)
{
gradotxt.Text = reader["Grado"].ToString();
if (gradotxt.Text == "6°A")
{
boleta4_6 frm = this.FormInstance;
frm.curp = Convert.ToString(textBox1.Text);
if (frm.WindowState == FormWindowState.Minimized)
{
frm.WindowState = FormWindowState.Normal;
}
AddOwnedForm(frm);
frm.FormBorderStyle = FormBorderStyle.FixedSingle;
//frm.TopLevel = false;
frm.StartPosition = FormStartPosition.CenterScreen;
//frm.Dock = DockStyle.Fill;
//this.Controls.Add(frm);
this.Tag = frm;
frm.BringToFront();
frm.Enabled = true;
frm.Visible = true;
frm.Show();
}
if (gradotxt.Text == "2°A")
{
Boleta1_2 frm = this.FormInstan;
frm.curp = Convert.ToString(textBox1.Text);
if (frm.WindowState == FormWindowState.Minimized)
{
frm.WindowState = FormWindowState.Normal;
}
AddOwnedForm(frm);
frm.FormBorderStyle = FormBorderStyle.FixedSingle;
//frm.TopLevel = false;
frm.StartPosition = FormStartPosition.CenterScreen;
//frm.Dock = DockStyle.Fill;
//this.Controls.Add(frm);
this.Tag = frm;
frm.BringToFront();
frm.Enabled = true;
frm.Visible = true;
frm.Show();
}
if (gradotxt.Text == "3°A")
{
boletas3AS frm = this.FormInstanc;
frm.curp = Convert.ToString(textBox1.Text);
if (frm.WindowState == FormWindowState.Minimized)
{
frm.WindowState = FormWindowState.Normal;
}
AddOwnedForm(frm);
frm.FormBorderStyle = FormBorderStyle.FixedSingle;
//frm.TopLevel = false;
frm.StartPosition = FormStartPosition.CenterScreen;
//frm.Dock = DockStyle.Fill;
//this.Controls.Add(frm);
this.Tag = frm;
frm.BringToFront();
frm.Enabled = true;
frm.Visible = true;
frm.Show();
}
if (gradotxt.Text == "4°A")
{
boleta4_6 frm = this.FormInstance;
frm.curp = Convert.ToString(textBox1.Text);
if (frm.WindowState == FormWindowState.Minimized)
{
frm.WindowState = FormWindowState.Normal;
}
AddOwnedForm(frm);
frm.FormBorderStyle = FormBorderStyle.FixedSingle;
//frm.TopLevel = false;
frm.StartPosition = FormStartPosition.CenterScreen;
//frm.Dock = DockStyle.Fill;
//this.Controls.Add(frm);
this.Tag = frm;
frm.BringToFront();
frm.Enabled = true;
frm.Visible = true;
frm.Show();
}
if (gradotxt.Text == "5°A")
{
boleta4_6 frm = this.FormInstance;
frm.curp = Convert.ToString(textBox1.Text);
if (frm.WindowState == FormWindowState.Minimized)
{
frm.WindowState = FormWindowState.Normal;
}
AddOwnedForm(frm);
frm.FormBorderStyle = FormBorderStyle.FixedSingle;
//frm.TopLevel = false;
frm.StartPosition = FormStartPosition.CenterScreen;
//frm.Dock = DockStyle.Fill;
//this.Controls.Add(frm);
this.Tag = frm;
frm.BringToFront();
frm.Enabled = true;
frm.Visible = true;
frm.Show();
}
if (gradotxt.Text == "1°A")
{
Boleta1_2 frm = this.FormInstan;
frm.curp = Convert.ToString(textBox1.Text);
if (frm.WindowState == FormWindowState.Minimized)
{
frm.WindowState = FormWindowState.Normal;
}
AddOwnedForm(frm);
frm.FormBorderStyle = FormBorderStyle.FixedSingle;
//frm.TopLevel = false;
frm.StartPosition = FormStartPosition.CenterScreen;
//frm.Dock = DockStyle.Fill;
//this.Controls.Add(frm);
this.Tag = frm;
frm.BringToFront();
frm.Enabled = true;
frm.Visible = true;
frm.Show();
}
}
}
}
void form_Disposede(object sender, EventArgs e)
{
mo = null;
}
