public void guardar(proalm mo)
{
try
{
string strl = "guardar";
MySqlCommand cmd = new MySqlCommand(strl, cnx);
cnx.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("pe", mo.pe);
cmd.Parameters.AddWithValue("po", mo.po);
cmd.Parameters.AddWithValue("prac", mo.pract);
cmd.Parameters.AddWithValue("valores", mo.val);
cmd.Parameters.AddWithValue("prue", mo.prue);
cmd.Parameters.AddWithValue("nota", mo.nota);
cmd.Parameters.AddWithValue("resul", mo.resul);
cmd.Parameters.AddWithValue("lit", mo.lite);
cmd.ExecuteNonQuery();
cnx.Close();
}
catch (MySqlException ex)
{
throw ex;
}
}
private void button3_Click(object sender, EventArgs e)
{
try
{
proalm mo = new proalm();
conecciomysql da = new conecciomysql();
mo.pe = int.Parse(txtpe.Text);
mo.po = int.Parse(txtpo.Text);
mo.pract = int.Parse(txtprac.Text);
mo.val = int.Parse(txtvalo.Text);
mo.prue = int.Parse(txtprueba.Text);
mo.nota = int.Parse(txtnota.Text);
mo.resul = txtresul.Text;
mo.lite = txtliteral.Text;
da.guardar(mo);
MessageBox.Show("Datos guardados");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}