static public void AgregarRubro(Rubros oRubro) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "insert into RUBROS values ('" + oRubro.Nombre + "')"; cmd.Connection = CN; Conectar(); cmd.ExecuteNonQuery(); Desconectar(); }
private void button2_Click(object sender, EventArgs e) { try { Rubros oRubro = new Rubros(txtRubros.Text); BD_ABM_ALMACEN.AgregarRubro(oRubro); Rubros = BD_ABM_ALMACEN.CargarRubros(); if (Rubros.Columns.Count > 0) { comboRubros.DataSource = Rubros; comboRubros.ValueMember = Rubros.Columns[0].ToString(); comboRubros.DisplayMember = Rubros.Columns[1].ToString(); comboRubros.Text = "Rubros"; } } catch (SqlException ex) { MessageBox.Show(ex.Message); } }