c# 创建sqlite数据库以及表

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

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            try
            {
                var filename = "D:/testDB.db";
                SQLiteConnection.CreateFile(filename);
                Console.WriteLine("成功建立数据库testDB");
                string databasefilename = "D:/testDB.db";
                string connectionstring = "data source="   databasefilename;
                SQLiteConnection dbconnection = new SQLiteConnection(connectionstring);
                dbconnection.Open();
                Console.WriteLine("成功连接到数据库");

                string[] colNames = new string[] { "ID", "Name", "Age", "Email" };
                string[] colTypes = new string[] { "INTEGER", "TEXT", "INTEGER", "TEXT" };
                string tableName = "table1";
                string queryString = "CREATE TABLE IF NOT EXISTS "   tableName   "( "   colNames[0]   " "   colTypes[0];
                for (int i = 1; i < colNames.Length; i  )
                {
                    queryString  = ", "   colNames[i]   " "   colTypes[i];
                }
                queryString  = "  ) ";
                SQLiteCommand dbCommand = dbconnection.CreateCommand();
                dbCommand.CommandText = queryString;
                SQLiteDataReader dataReader = dbCommand.ExecuteReader();

                Console.WriteLine("成功建立一个表");




                Console.ReadKey();

            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message.ToString());
                Console.ReadKey();
            }
        }
    }
}

资源下载

此资源下载价格为3D币（VIP免费），请先登录

资源文件列表

sqlite/.vs/ConsoleApplication1/v14/.suo , 41472
sqlite/.vs/sqlite/v14/.suo , 36352
sqlite/sqlite/App.config , 189
sqlite/sqlite/bin/Debug/ConsoleApplication1.exe , 5120
sqlite/sqlite/bin/Debug/ConsoleApplication1.exe.config , 189
sqlite/sqlite/bin/Debug/ConsoleApplication1.pdb , 13824
sqlite/sqlite/bin/Debug/ConsoleApplication1.vshost.exe , 22688
sqlite/sqlite/bin/Debug/ConsoleApplication1.vshost.exe.config , 189
sqlite/sqlite/bin/Debug/ConsoleApplication1.vshost.exe.manifest , 490
sqlite/sqlite/bin/Debug/SQLite.Interop.dll , 1320448
sqlite/sqlite/bin/Debug/System.Data.SQLite.dll , 1128448
sqlite/sqlite/obj/Debug/ConsoleApplication1.csproj.FileListAbsolute.txt , 823
sqlite/sqlite/obj/Debug/ConsoleApplication1.csprojResolveAssemblyReference.cache , 7187
sqlite/sqlite/obj/Debug/ConsoleApplication1.exe , 5120
sqlite/sqlite/obj/Debug/ConsoleApplication1.pdb , 13824
sqlite/sqlite/obj/Debug/DesignTimeResolveAssemblyReferences.cache , 726
sqlite/sqlite/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache , 6998
sqlite/sqlite/obj/Debug/sqlite.csproj.FileListAbsolute.txt , 971
sqlite/sqlite/obj/Debug/sqlite.csprojResolveAssemblyReference.cache , 8160
sqlite/sqlite/obj/Debug/TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs , 0
sqlite/sqlite/obj/Debug/TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs , 0
sqlite/sqlite/obj/Debug/TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs , 0
sqlite/sqlite/Program.cs , 1860
sqlite/sqlite/Properties/AssemblyInfo.cs , 1346
sqlite/sqlite/sqlite.csproj , 2968
sqlite/sqlite.sln , 985