sqlit3 插入数据库可用完整

sqlit3 插入数据库可用完整实例源码

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SQLite;
using System.Data;

namespace SQLPrac
{
    class Program
    {
        static void Main（string[] args）
        {
            //EraseTable（）;
            Test（）;
            Console.WriteLine（“保存完毕！“）;
            Console.ReadKey（）;
        }

        public static void Test（）
        {
            var datalist = new int[100];
            for （int i = 0; i < 100; i++）
            {
                datalist[i] = i + 1;
            }

            SQLiteConnectionStringBuilder str = new SQLiteConnectionStringBuilder（）;
            str.DataSource =“mydata.db“;
            using （var con = new SQLiteConnection（str.ConnectionS

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件        990  2014-04-03 09:09  C#-SQLite\PressurePractice.sln

     文件        187  2013-10-21 17:32  C#-SQLite\SQLPrac\App.config

     文件       4096  2014-04-03 09:09  C#-SQLite\SQLPrac\bin\Debug\mydata.db

     文件       6656  2014-04-03 09:09  C#-SQLite\SQLPrac\bin\Debug\SQLPrac.exe

     文件        187  2013-10-21 17:32  C#-SQLite\SQLPrac\bin\Debug\SQLPrac.exe.config

     文件      15872  2014-04-03 09:09  C#-SQLite\SQLPrac\bin\Debug\SQLPrac.pdb

     文件      24224  2014-04-03 09:09  C#-SQLite\SQLPrac\bin\Debug\SQLPrac.vshost.exe

     文件        187  2013-10-21 17:32  C#-SQLite\SQLPrac\bin\Debug\SQLPrac.vshost.exe.config

     文件        490  2010-03-17 22:39  C#-SQLite\SQLPrac\bin\Debug\SQLPrac.vshost.exe.manifest

     文件    1045504  2013-10-14 09:25  C#-SQLite\SQLPrac\bin\Debug\System.Data.SQLite.dll

     文件     182784  2013-10-14 09:25  C#-SQLite\SQLPrac\bin\Debug\System.Data.SQLite.Linq.dll

     文件       6901  2014-04-03 09:03  C#-SQLite\SQLPrac\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

     文件       1310  2014-04-03 09:09  C#-SQLite\SQLPrac\obj\Debug\SQLPrac.csproj.FileListAbsolute.txt

     文件      13416  2014-04-03 09:09  C#-SQLite\SQLPrac\obj\Debug\SQLPrac.csprojResolveAssemblyReference.cache

     文件       6656  2014-04-03 09:09  C#-SQLite\SQLPrac\obj\Debug\SQLPrac.exe

     文件      15872  2014-04-03 09:09  C#-SQLite\SQLPrac\obj\Debug\SQLPrac.pdb

     文件          0  2013-10-21 17:32  C#-SQLite\SQLPrac\obj\Debug\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs

     文件          0  2013-10-21 17:32  C#-SQLite\SQLPrac\obj\Debug\TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs

     文件          0  2013-10-21 17:32  C#-SQLite\SQLPrac\obj\Debug\TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs

     文件        152  2013-10-21 17:36  C#-SQLite\SQLPrac\packages.config

     文件       3000  2013-10-23 10:26  C#-SQLite\SQLPrac\Program.cs

     文件       1334  2013-10-21 17:32  C#-SQLite\SQLPrac\Properties\AssemblyInfo.cs

     文件       2943  2013-10-21 22:28  C#-SQLite\SQLPrac\SQLPrac.csproj

     目录          0  2013-10-21 17:32  C#-SQLite\SQLPrac\obj\Debug\TempPE

     目录          0  2014-04-03 09:09  C#-SQLite\SQLPrac\bin\Debug

     目录          0  2014-04-03 09:09  C#-SQLite\SQLPrac\obj\Debug

     目录          0  2014-04-03 09:09  C#-SQLite\SQLPrac\bin

     目录          0  2014-04-03 09:09  C#-SQLite\SQLPrac\obj

     目录          0  2014-04-03 09:09  C#-SQLite\SQLPrac\Properties

     目录          0  2014-04-03 09:09  C#-SQLite\SQLPrac

............此处省略4个文件信息