public InfoCoche(ConectorSQLite conector, string bastidor) { InitializeComponent(); SQLiteCommand consulta = conector.DameComando(); SQLiteDataReader reader; consulta.CommandText = "SELECT * FROM Coche WHERE N_Bastidor='" + bastidor + "'"; reader = consulta.ExecuteReader(); while (reader.Read()) { txtBastidor.Text = reader.GetString(0); txtMarca.Text = reader.GetString(1); txtModelo.Text = reader.GetString(2); txtMotor.Text = reader.GetString(3); txtCV.Text = reader.GetInt16(4).ToString(); txtTipo.Text = reader.GetString(5); txtColor.Text = reader.GetString(6); txtPrecio.Text = reader.GetFloat(7).ToString(); try { byte[] imageBytes = (System.Byte[])reader["Img"]; MemoryStream ms = new MemoryStream(imageBytes); pImagen.Image = Image.FromStream(ms, true); } catch (Exception ex) { } } reader.Close(); }
public TablaVentas(ConectorSQLite con) { conector = con; InitializeComponent(); string sql; sql = "SELECT * FROM Venta"; iniciar_datagrid(sql); }
public TablaCoches(ConectorSQLite con) { conector = con; InitializeComponent(); string sql; sql = "SELECT * FROM Coche"; iniciar_datagrid(sql); TablaVentas = new TablaVentas(); TablaRevisiones = new TablaRevisiones(); }
public FormMain() { InitializeComponent(); con = new ConectorSQLite(); tablaCoches = this.iniciar_coches(); tablaVentas = this.iniciar_ventas(); tablaRevisiones = this.iniciar_revisiones(); tablaClientes = this.iniciar_clientes(); rellenarComboMarcas(); ventana_informe = new FormInforme(); //Abro la tabla de los coches cuando inicio el programa this.abrir_hijo(0); }
public void rellenarComboDni() { ConectorSQLite conector = new ConectorSQLite(); SQLiteCommand consulta3 = conector.DameComando(); consulta3.CommandText = "SELECT Dni FROM Cliente"; SQLiteDataReader reader2 = consulta3.ExecuteReader(); this.autoComplete2.Clear(); while (reader2.Read()) { autoComplete2.Add(reader2.GetString(0)); } reader2.Close(); }
public void rellenarComboBastidor() { ConectorSQLite conector = new ConectorSQLite(); SQLiteCommand consulta2 = conector.DameComando(); consulta2.CommandText = "SELECT N_Bastidor FROM Coche"; SQLiteDataReader reader = consulta2.ExecuteReader(); this.autoComplete.Clear(); while (reader.Read()) { this.autoComplete.Add(reader.GetString(0)); } reader.Close(); }
private void dataGridView1_CellEndEdit_1(object sender, DataGridViewCellEventArgs e) { if (dataGridView1.CurrentRow.Cells[0].Value.ToString() != "") { string bastidor = dataGridView1.CurrentRow.Cells[0].Value.ToString(); ConectorSQLite c = new ConectorSQLite(); SQLiteCommand consulta = c.DameComando(); consulta.CommandText = "SELECT Precio FROM Coche WHERE N_Bastidor = '" + bastidor + "'"; SQLiteDataReader reader = consulta.ExecuteReader(); while (reader.Read()) { dataGridView1.CurrentRow.Cells[3].Value = reader.GetFloat(0).ToString(); } reader.Close(); } }
public InfoVenta(ConectorSQLite conector, string bastidor, string dni) { InitializeComponent(); SQLiteCommand consulta = conector.DameComando(); SQLiteDataReader reader; consulta.CommandText = "SELECT * FROM Venta WHERE N_Bastidor='" + bastidor + "' AND Dni='" + dni + "'"; reader = consulta.ExecuteReader(); while (reader.Read()) { txtCoche.Text = reader.GetString(0); txtCliente.Text = reader.GetString(1); txtFecha.Text = reader.GetString(2); txtPrecio.Text = reader.GetFloat(3).ToString(); } reader.Close(); }
public InfoCliente(ConectorSQLite conector, string dni) { InitializeComponent(); SQLiteCommand consulta = conector.DameComando(); SQLiteDataReader reader; consulta.CommandText = "SELECT * FROM Cliente WHERE Dni='" + dni + "'"; reader = consulta.ExecuteReader(); while (reader.Read()) { txtDni.Text = reader.GetString(0); txtNombre.Text = reader.GetString(1); txtApellidos.Text = reader.GetString(2); txtTelefono.Text = reader.GetString(3); txtDireccion.Text = reader.GetString(4); } reader.Close(); }
public InfoRevision(ConectorSQLite conector, object id) { InitializeComponent(); int nrevision = Convert.ToInt16(id); string frenos = null; string aceite = null; string filtro = null; SQLiteCommand consulta = conector.DameComando(); SQLiteDataReader reader; consulta.CommandText = "SELECT * FROM Revision WHERE N_Revision=" + nrevision; reader = consulta.ExecuteReader(); while (reader.Read()) { txtId.Text = reader.GetInt16(0).ToString(); txtFecha.Text = reader.GetString(1); frenos = reader.GetString(2); aceite = reader.GetString(3); filtro = reader.GetString(4); txtBastidor.Text = reader.GetString(5); } reader.Close(); if (frenos == "Sí") { chkFrenos.Checked = true; } else { chkFrenos.Checked = false; } if (aceite == "Sí") { chkAceite.Checked = true; } else { chkAceite.Checked = false; } if (filtro == "Sí") { chkFiltro.Checked = true; } else { chkFiltro.Checked = false; } string bastidor = txtBastidor.Text; SQLiteCommand consulta2 = conector.DameComando(); SQLiteDataReader reader2; consulta2.CommandText = "SELECT Marca, Modelo FROM Coche WHERE N_Bastidor='" + bastidor + "'"; reader2 = consulta2.ExecuteReader(); while (reader2.Read()) { txtMarca.Text = reader2.GetString(0); txtModelo.Text = reader2.GetString(1); } reader2.Close(); }