c# - 将列表框数据拉到 sqlite

Question

列表框正在由 JSON 数据正确填充到列表框中。然后，当我尝试获取列表框enter code here数据，然后在运行时填充 sqlite 数据库时，它不会写入数据库。

                foreach (var closeout in deseiralizeObject.Reports)

                CloseoutslListBox.Items.Add($"{closeout.CloseoutID}, {closeout.Desc}, {closeout.Start},{closeout.End}");

            for (int i = 0; i < CloseoutslListBox.Items.Count; i++)
            {
                CloseoutslListBox.SetSelected(i, true);
            }
            GetCloseout vc = new GetCloseout();

            vc.CloseoutID = CloseoutslListBox.Text;
            vc.Desc = CloseoutslListBox.Text;
            vc.Start = CloseoutslListBox.Text;
            vc.End = CloseoutslListBox.Text;


            SqliteDataAccess.SaveAPIData(p);

            CloseoutslListBox.Text = "";

还有我的 sqlite 方面

       public static void SaveAPIData(GetCloseout close)
    {
        using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
        {
            cnn.Execute("insert into VersiCloseOuts (CloseoutID, Desc, Start, End) values (@CloseoutID, @Desc, @Start, @End)", close);
        }
    }

Sqlite 表字段由单个字段中的所有数据填充，而不是由从 JSON 中提取的各个部分分解。从这部分代码：

    vc.CloseoutID = CloseoutslListBox.Text;
        vc.Desc = CloseoutslListBox.Text;
        vc.Start = CloseoutslListBox.Text;
        vc.End = CloseoutslListBox.Text;

和 Sqlite 表字段

2020112501, 11/25/2020 #01 Wed, 2020-11-24T20:01:55.000-08:00,2020-11-25T16:49:40.000-08:00

标签： c#sqlite