Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- internal void CreateDatabase()
- {
- using SQLiteConnection conn = new(_dbFilePath);
- using SQLiteCommand cmd = conn.CreateCommand();
- using SQLiteCommand cmd2 = conn.CreateCommand();
- using SQLiteCommand cmd3 = conn.CreateCommand();
- conn.Open();
- cmd.CommandText = @"CREATE TABLE IF NOT EXISTS
- [records] (
- [Id] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
- [Date] VARCHAR(2048),
- [StartTime] VARCHAR(2048),
- [StartMileage] INTEGER,
- [EndTime] VARCHAR(2048),
- [EndMileage] INTEGER,
- [TotalTime] VARCHAR(2048),
- [TotalMileage] INTEGER,
- [Pay] REAL)";
- cmd2.CommandText = @"CREATE TABLE IF NOT EXISTS
- [gasRecords] (
- [Id] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
- [Date] VARCHAR(2048),
- [Amount] REAL)";
- cmd3.CommandText = @"CREATE TABLE IF NOT EXISTS
- [maintenanceRecords] (
- [Id] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
- [Date] VARCHAR(2048),
- [Amount] REAL,
- [Notes] VARCHAR(2048))";
- try
- {
- cmd.ExecuteNonQuery();
- cmd2.ExecuteNonQuery();
- cmd3.ExecuteNonQuery();
- }
- catch (Exception ex)
- {
- Console.WriteLine(ex.Message);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment