C#C
C#3y ago
Immusama

✅ Help with SQLite INSERT INTO C#

Hey all, I'm running this code and I don't understand why there is no data being stored in my created table.

using System;
using System.IO;
using System.Text;
using System.Data;
using System.Data.SQLite;

public class CPHInline
{
    public bool Execute()
    {
        // Variables
        string path = @"Data Source=C:\Users\Immusama\OneDrive - Critical Fear UG (haftungsbeschränkt)\Database\Twitch.db";
        string userId = CPH.GetGlobalVar<string>("userId", true);
        string userName = CPH.GetGlobalVar<string>("userName", true);
        string displayName = CPH.GetGlobalVar<string>("user", true);
        int isSubscribed = CPH.GetGlobalVar<int>("isSubscribed", true);
        int isVip = CPH.GetGlobalVar<int>("isVip", true);
        int isModerator = CPH.GetGlobalVar<int>("isModerator", true);

        SQLiteConnection sql_db = new SQLiteConnection(path);

        
        sql_db.Open();
        string sql = "CREATE TABLE Viewers (userId varchar(20), userName varchar(30), displayName varchar(30), isSubscribed int, isVip int, isModerator int)";
        SQLiteCommand command = new SQLiteCommand(sql, sql_db);
        command.ExecuteNonQuery();
  

        SQLiteCommand sqlInsert = new SQLiteCommand ("INSERT INTO Viewers (userId, userName, displayName, isSubscribed, isVip, isModerator) VALUES  (@userId, @userName, @displayName, @isSubscribed, @isVip, @isModerator)", sql_db);
        sqlInsert.Parameters.AddWithValue(@"userId", userId);
        sqlInsert.Parameters.AddWithValue(@"userName", userName);
        sqlInsert.Parameters.AddWithValue(@"displayName", displayName);
        sqlInsert.Parameters.AddWithValue(@"isSubscribed", isSubscribed);
        sqlInsert.Parameters.AddWithValue(@"isVip", isVip);
        sqlInsert.Parameters.AddWithValue(@"isModerator", isModerator);

        sql_db.Close();
                   
        return true;
    }
}
Was this page helpful?