C# (CSharp) SInP LiteBD示例

示例#1

        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();
        }