KillPrice.Helper.SQLiteDBHelper.CreateDB C# (CSharp) Метод

CreateDB() публичный статический Метод

创建SQLite数据库文件
public static CreateDB ( string dbPath ) : void
dbPath string 要创建的SQLite数据库文件路径
Результат void
        public static void CreateDB(string dbPath)
        {
            using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + dbPath))
            {
                connection.Open();
                using (SQLiteCommand command = new SQLiteCommand(connection))
                {
                    command.CommandText = "CREATE TABLE Demo(id integer NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE)";
                    command.ExecuteNonQuery();
                    command.CommandText = "DROP TABLE Demo";
                    command.ExecuteNonQuery();
                }
            }
        }
        /// <summary> 

Usage Example

Пример #1
0
        public static void CreateTable()
        {
            string dbPath = "D:\\Demo.db3";

            //如果不存在改数据库文件,则创建该数据库文件
            if (!System.IO.File.Exists(dbPath))
            {
                SQLiteDBHelper.CreateDB("D:\\Demo.db3");
            }
            SQLiteDBHelper db  = new SQLiteDBHelper("D:\\Demo.db3");
            string         sql = "CREATE TABLE Test3(id integer NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,Name char(3),TypeName varchar(50),addDate datetime,UpdateTime Date,Time time,Comments blob)";

            db.ExecuteNonQuery(sql, null);
        }