Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DateTime datetime1 = Convert.ToDateTime(NIVigencia.Text);
- DateTime datetime2 = Convert.ToDateTime(NFVigencia.Text);
- DateTime datetime3 = Convert.ToDateTime(fechahoy.Text);
- String ActualizarDS1 = "Update DATOSSEGURO SET Poliza = '" + NuevaPoliza.Text + "', Aseguradora = '" + Naseguradora.Text + "', FechaColozacion = '" + datetime3 + "', InitVigencia = '" + datetime1+ "', FinVigencia = '" + datetime2+ "' WHERE Poliza = " + TBPoliza.Text;
- SqlCommand actualizar = new SqlCommand();
- actualizar.Connection = MenuInicio.conexion;
- actualizar.CommandType = CommandType.Text;
- actualizar.CommandText = ActualizarDS1;
- try
- {
- actualizar.ExecuteNonQuery();
- actualizar.Dispose();
- actualizar = null;
- MessageBox.Show("Nueva Poliza agregada con exito", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
- }
- catch (SqlException ex)
- {
- MessageBox.Show("ERROR al actualizar datosseguro :" + ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement