c# sqlite 求教 批量插入

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Collections;
using System.Data;
using System.Data.Common;
using System.Data.SQLite;namespace ConsoleApplication2
{
    class Program
    {        static void Main(string[] args)
        {
            System.Data.SQLite.SQLiteConnection.CreateFile("datasource");
            string datasource = "D:/test.db"; System.Data.SQLite.SQLiteConnection.CreateFile(datasource);            string connectionString = @"Server=localhost;Database=Northwind;Trusted_Connection=true";            System.Data.SQLite.SQLiteConnectionStringBuilder connstr = new System.Data.SQLite.SQLiteConnectionStringBuilder();            connstr.DataSource = datasource;
            using (System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection(connectionString))
            {                conn.ConnectionString = connstr.ToString();
                conn.Open();
                System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand();                string sql = "CREATE TABLE test(devid int,data_time int,data_value int)";
                cmd.Connection = conn;                cmd.CommandText = sql;
                cmd.ExecuteNonQuery();                System.Data.SQLite.SQLiteDataAdapter sd = new System.Data.SQLite.SQLiteDataAdapter();
                sd.SelectCommand = new System.Data.SQLite.SQLiteCommand("select devid,data_time,data_value from Test", conn);
                sd.InsertCommand = new System.Data.SQLite.SQLiteCommand("insert into Test (devid,data_time,data_value) "
                                + " values (@devid,@data_time,@data_value);", conn);
              
                sd.InsertCommand.UpdatedRowSource = UpdateRowSource.None;
                DataSet dataset = new DataSet();
                sd.Fill(dataset);
               
                for (int i = 0; i < 100000; i++)
                {
                    Random r = new Random(1000);
                    object[] row = { i, r.Next(1, 1000), r.Next(1, 1000) };
                    dataset.Tables[0].Rows.Add(row);
                    try
                    {
                        if (i % 300 == 0)
                        {
                            sd.Update(dataset.Tables[0]);
                            dataset.Tables[0].Clear();
                        }
                    }
                    catch (Exception )
                    { }
                }
                sd.Update(dataset.Tables[0]);
                dataset.Tables[0].Clear();
                sd.Dispose();
                dataset.Dispose();
                conn.Close();
            }        }
    }
}
就这个，错误语句：sd.Update(dataset.Tables[0]);原因SQLite error；Insufficient parameters supplied to the command 新手，详细点
不要用参数，目的是可以快速插入大量数据到表中，有一些没读懂瞎写的，看在我就接触两个星期的份上，不要喷