CsvReader - adding data into sqlite

Question

am new to all of this, but a fast learning curve is underway.

I have been searching round, but cannot piece together what I need.

I am using Lumenworks CsvReader to reader the data from a csv file - so far so good, and I am seeing data. Next I need to pass this data into SQLite.

Where I am stuck is trying to pass that information into my INSERT statement in a loop, so hoping someone here can help me?

I know the error lies in my loop, (and I know the format may be wrong), but I cannot figure this out. Thankyou for any help in advance.

here is my code so far:

    command.CommandText = @"CREATE TABLE [Test] ([Code] VARCHAR(50) PRIMARY KEY  NOT NULL , [Description] VARCHAR(100),[RRP] NUMERIC DEFAULT (null) ,[Points] NUMERIC, [Buy] NUMERIC DEFAULT (null) )";
    command.ExecuteNonQuery();

    string insertText = "INSERT INTO [Test] ([Code],[Description],[RRP],[Points],[Buy]) VALUES(@Code,@Description,@RRP,@Points,@Buy)";

        SQLiteTransaction trans = conn.BeginTransaction();
        command.Transaction = trans;

        command.CommandText = insertText;

        using (CsvReader csv = new CsvReader(new StreamReader(@"C:\Data.csv"), true))
        {
            int fieldCount = csv.FieldCount;

            string[] headers = csv.GetFieldHeaders();

            while (csv.ReadNextRecord())
            {
                for (int i = 0; i < fieldCount; i++)
                    command.Parameters.AddWithValue("@Code", csv[i]);
                    command.Parameters.AddWithValue("@Description", csv[i]);
                    command.Parameters.AddWithValue("@RRP", csv[i]);
                    command.Parameters.AddWithValue("@Points", csv[i]);
                    command.Parameters.AddWithValue("@Buy", csv[i]);

                command.ExecuteNonQuery();
            }
        }