✅ 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;
}
}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;
}
}