I am trying to insert some data into an SQLite file but when I try to do so nothing gets added to the file, it's the first time I deal with SQLite so not quite sure I'm doing it right. Please ask if any other information is needed.
Here is the source code.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;
using System.Data.SQLite;
namespace WpfApplication1
{
public partial class MainWindow : Window
{
    public MainWindow()
    {
        InitializeComponent();
        Readlines();
    }
    public void Readlines()
    {
        string[] lines = System.IO.File.ReadAllLines(@"D:\Projects\GFKMVC\WpfApplication1\WpfApplication1\Opgave001.txt");
        Shift shift = new Shift();
        SQLiteConnection.CreateFile("TimePlan.sqlite");
        SQLiteConnection dbcon;
        dbcon = new SQLiteConnection("Data Source=TimePlan.sqlite;Version=3;");
        dbcon.Open();
        //string DropTable = "DROP DATABASE TimePlane.sqlite";
        //SQLiteCommand dropCom = new SQLiteCommand(DropTable, dbcon);
        //dropCom.ExecuteNonQuery();
        string CreateTable = "CREATE TABLE Shifts (EmployeeID INT, Date DATETIME, StartTime DATETIME, EndTime DATETIME, Break INT)";
        SQLiteCommand createCom = new SQLiteCommand(CreateTable, dbcon);
        createCom.ExecuteNonQuery();
        foreach (string line in lines)
        {
            string[] fields = line.Split(';');
            shift.EmployeeID = Int32.Parse(fields[0]);
            DateTime dt = DateTime.ParseExact(fields[1], "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture);
            shift.Date = dt;
            DateTime st = DateTime.ParseExact(fields[2], "HHmm", System.Globalization.CultureInfo.InvariantCulture);
            shift.StartTime = st;
            DateTime et = DateTime.ParseExact(fields[3], "HHmm", System.Globalization.CultureInfo.InvariantCulture);
            shift.EndTime = et;
            shift.Break = Int32.Parse(fields[4]);
            string InsertSql = "INSERT INTO Shifts (EmployeeID, Date, StartTime, EndTime, Break) values ("+shift.EmployeeID+","+shift.EmployeeID+","+shift.StartTime+","+shift.EndTime+","+shift.Break+")";
            SQLiteCommand InsertCom = new SQLiteCommand(InsertSql, dbcon);
            InsertCom.ExecuteNonQuery();
        }
        dbcon.Close();
    }
}
}
Aucun commentaire:
Enregistrer un commentaire