private void dgvParada1_UserDeletingRow(object sender, DataGridViewRowCancelEventArgs e) { liteBd.AbrirConexao(); liteBd.InsertDeleteUpdate("DELETE FROM Paradas WHERE Cod = " + dgvParada1.CurrentRow.Cells[0].Value); liteBd.FecharConexao(); }
private void btnInserir1_Click(object sender, EventArgs e) { LiteBD liteBd2 = new LiteBD(); string data = dtpData.Text.Substring(6, 4) + "-" + dtpData.Text.Substring(3, 2) + "-" + dtpData.Text.Substring(0, 2); liteBd2.AbrirConexao(); liteBd2.InsertDeleteUpdate("INSERT INTO Paradas (data, hora_inicio, hora_fim, descricao, tipo) " + "values('" + data + "', '" + txtHoraInicio.Text + "', '" + txtHoraFim.Text + "', '" + txtMotivo.Text + "', 'PLANEJADO')"); liteBd2.FecharConexao(); CarregaDgvParada1(); }