private void cargararray(string nomtabla) { int c = 0; bd.leertabla(nomtabla); while (bd.Reader.Read()) { Consortiumcls cons = new Consortiumcls(); if (!bd.Reader.IsDBNull(0)) { cons.Idconsortium = bd.Reader.GetInt32(0); } if (!bd.Reader.IsDBNull(1)) { cons.Name = bd.Reader.GetString(1); } if (!bd.Reader.IsDBNull(2)) { cons.Cuit = bd.Reader.GetDouble(2); } if (!bd.Reader.IsDBNull(3)) { cons.Address = bd.Reader.GetString(3); } if (!bd.Reader.IsDBNull(4)) { cons.Number = bd.Reader.GetInt32(4); } if (!bd.Reader.IsDBNull(5)) { cons.District = bd.Reader.GetString(5); } arraycons[c] = cons; c++; } bd.Reader.Close(); bd.desconectar(); listBox1.Items.Clear(); for (int i = 0; i < c; i++) { listBox1.Items.Add(arraycons[i].Name); } }
private void btnGuardar_Click(object sender, EventArgs e) { Consortiumcls p = new Consortiumcls(); p.Name = txtNombre.Text; p.Cuit = Convert.ToDouble(txtCuit.Text); p.District = txtBarrio.Text; p.Address = txtDireccion.Text; p.Number = Convert.ToInt32(txtNumero.Text); if (nuevo == true) { string consultasql = "insert into consorcio(cuit,nombre,direccion,numero,barrio) " + "values (" + p.Cuit + ",'" + p.Name + "','" + p.Address + "'," + p.Number + ",'" + p.District + "')"; bd.modificarbd(consultasql); cargarcombo(cmbConsorcio, "consorcio"); cargararray("consorcio"); limpiar(); } else { p.Idconsortium = arraycons[listBox1.SelectedIndex].Idconsortium; string consultasql = "update consorcio set " + "nombre= '" + p.Name + "'," + "cuit= " + p.Cuit + "," + "direccion= '" + p.Address + "'," + "numero= " + p.Number + "," + "barrio= '" + p.District + "' " + "where id_consorcio= " + p.Idconsortium; bd.modificarbd(consultasql); cargarcombo(cmbConsorcio, "consorcio"); cargararray("consorcio"); limpiar(); } }