You forgot to call the most important method:
SqliteCommand.ExecuteNonQuery Method (Microsoft.Data.Sqlite) | Microsoft Docs[
^]
sqlconnection.Open();
string query = "SELECT name FROM sqlite_master WHERE type='table' AND name='Users';";
SQLiteCommand cmd = new SQLiteCommand(query);
cmd.CommandType = CommandType.Text;
cmd.Connection = sqlconnection;
cmd.ExecuteNonQuery();
var result = cmd.ExecuteReader();
if (result.HasRows)
{
try
{
cmd.CommandText = "INSERT INTO [Users] (ID ,Name ,Password) VALUES ( @ID , @Name , @Password )";
cmd.Parameters.AddWithValue("@ID", 1);
cmd.Parameters.AddWithValue("@Name", 1);
cmd.Parameters.AddWithValue("@Password", 1);
cmd.ExecuteNonQuery();