C# SQLite insert does not work

Question

I have a problem with the command INSERT. I compile the application and this works but the row isn't inserted in the database (no throws any error). The database is included in the project and has the property "Copy always". I'm developing a project with WPF and C#, but for the connection and querys, i use C#.

Thanks!

public SQLiteConnection conexion;
        SQLiteCommand cmd;

        public MainWindow()
        {
            InitializeComponent();
            Conectar();
        }

        public void Conectar ()
        {
            try
            {
                //Connection
                conexion = new SQLiteConnection("Data Source=eldelbar.s3db;Version=3;New=True;Compress=True;");
                conexion.Open();

                //Insert query
                string insercion = "insert into cerveza (nombre,precio) values('amstel', 1.3);";
                cmd = new SQLiteCommand(insercion, conexion);
                int cantidad = cmd.ExecuteNonQuery();
                if (cantidad < 1)
                    MessageBox.Show("No se ha podido insertar");

                cmd.Dispose();
                conexion.Close();

            }
            catch (Exception e)
            {
                MessageBox.Show("Error2!" + e.Message);
            }
        }

Steve · Accepted Answer · 2013-07-07 15:35:10Z

1

If you set the property Copy To The Output Directory to Copy Always, everytime you start a debug session in VS, a copy of the database from the project folder is copied to the output directory (usually BIN\DEBUG). You need simply to change that property to Copy If Newer

answered Jul 7, 2013 at 15:35

Steve

217k22 gold badges242 silver badges296 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

C# SQLite insert does not work

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related