© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
C#C
C#•16mo ago•
34 replies
Kurisu 🐧

Issue with SQlite command

List<(string IDClash, int IDDiscord)> joueursIDs = new List<(string, int)>();

using (SqliteConnection connection = new SqliteConnection(connectionString))
{
    connection.Open();

    // Requête pour récupérer uniquement les IDClash et IDDiscord
    string query = "SELECT IDClash, IDDiscord FROM Joueur";

    using (SqliteCommand command = new SqliteCommand(query, connection))
    using (SqliteDataReader reader = command.ExecuteReader())
    {
        while (reader.Read())
        {
            // Récupérer IDClash et IDDiscord et les ajouter à la liste
            string idClash = reader.GetString(0);
            int idDiscord = reader.GetInt32(1);
            joueursIDs.Add((idClash, idDiscord));
        }
    }
}
List<(string IDClash, int IDDiscord)> joueursIDs = new List<(string, int)>();

using (SqliteConnection connection = new SqliteConnection(connectionString))
{
    connection.Open();

    // Requête pour récupérer uniquement les IDClash et IDDiscord
    string query = "SELECT IDClash, IDDiscord FROM Joueur";

    using (SqliteCommand command = new SqliteCommand(query, connection))
    using (SqliteDataReader reader = command.ExecuteReader())
    {
        while (reader.Read())
        {
            // Récupérer IDClash et IDDiscord et les ajouter à la liste
            string idClash = reader.GetString(0);
            int idDiscord = reader.GetInt32(1);
            joueursIDs.Add((idClash, idDiscord));
        }
    }
}
image.png
C# banner
C#Join
We are a programming server aimed at coders discussing everything related to C# (CSharp) and .NET.
61,871Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

❔ Default command in System.CommandLine
C#CC# / help
3y ago
Wierd sqlite-net pcl issue
C#CC# / help
7mo ago
WinForms problem with SQLite
C#CC# / help
2y ago
✅ Using SQLite with C#
C#CC# / help
3y ago