基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：78630559

本次赞助数额为： 2 元　

支付宝支付

微信支付

   源码介绍

---

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();
            }
        }
    }
}