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