C# sqlite query

public List<string> GetUsers()
{
	// Init return list
    List<string> users = new List<string>();

	// Set the path to sqlite file
    string solutionPath = Environment.CurrentDirectory;
	string dbPath = Path.Combine(solutionPath, "db.sqlite3");    

    SQLiteConnection connection = new SQLiteConnection(solutionPath);
    connect.Open();

	// Construct sql query
    SQLiteCommand command = connection.CreateCommand();
    command.CommandText = @"SELECT username FROM tableUsers";
    command.CommandType = CommandType.Text;

    SQLiteDataReader reader = command.ExecuteReader();

	// reader is treated like a array so call 
    while (reader.Read())
    	users.Add(Convert.ToString(reader["username"]));

	// Clean up no longer needed connection
	connection.Close();

    return users;
}

Similar codes

10 votes260 views3 answers
How to lock and hide a cursor unity
C#Unity
1 vote144 views1 answer
Get all devices connected using player input manager unity
C#
0 vote185 views1 answer
Nginx listen on 80 and 443
C#
0 vote194 views1 answer
C sharp tenery operator on an action
C#
20 votes202 views6 answers
Random number generator
C#
0 vote150 views1 answer
C# sharepoint get users from column
C#
0 vote194 views3 answers
Windows forms link listbox to array
C#
0 vote203 views1 answer
Unity generate random offset position around a gameobject
C#
0 vote177 views1 answer
Wpf dispatcher timer is inaccurate
C#
0 vote194 views1 answer
Aws asp.net tutorial
C#