private void dataGridView1_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e) { modificar_button.Enabled = true; guardar_button.Enabled = false; generar_codigo_button.Enabled = false; foreach (DataGridViewRow row in this.dataGridView1.SelectedRows) { Codigos_generados cust = row.DataBoundItem as Codigos_generados; if (cust != null) { codigoActual.codigo = cust.codigo; codigoActual.descripcion = cust.descripcion; codigoActual.ruta = cust.ruta; } } }
public void InsertCodigoGenerado(Codigos_generados codigo) { SqlCeConnection conn = null; try { conn = new SqlCeConnection(@"Data Source=|DataDirectory|\DB\DB_local.sdf"); conn.Open(); SqlCeCommand cmd = conn.CreateCommand(); cmd.CommandText = "INSERT INTO codigosGenerados ([codigo],[descripcion],[ruta]) Values('" + codigo.codigo + "','" + codigo.descripcion + "','" + codigo.ruta + "')"; cmd.ExecuteNonQuery(); } finally { conn.Close(); } }
public void ModificarCodigo(Codigos_generados codigo) { SqlCeConnection conn = null; try { conn = new SqlCeConnection(@"Data Source=|DataDirectory|\DB\DB_local.sdf"); conn.Open(); SqlCeCommand cmd = conn.CreateCommand(); cmd.CommandText = "UPDATE codigosGenerados SET descripcion='" + codigo.descripcion + "' WHERE codigo ='" + codigo.codigo + "'"; cmd.ExecuteNonQuery(); } finally { conn.Close(); } }
public Codigos_generados GetCodigo(Codigos_generados temp) { Codigos_generados codigo = new Codigos_generados(); SqlCeConnection conn = new SqlCeConnection(@"Data Source=|DataDirectory|\DB\DB_local.sdf"); conn.Open(); //commands represent a query or a stored procedure SqlCeCommand cmd = conn.CreateCommand(); cmd.CommandText = "SELECT * FROM codigosGenerados WHERE codigo='" + temp.codigo + "' AND descripcion='" + temp.descripcion + "';"; SqlCeDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { codigo = new Codigos_generados( reader["codigo"].ToString(), reader["descripcion"].ToString(), reader["ruta"].ToString()); } return(codigo); }