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

30 votes334 views3 answers
C# wait seconds
C#
0 vote324 views1 answer
Display none asp.net
C#
1 vote333 views1 answer
Asp.net model
C#
0 vote323 views1 answer
How to get row index of selected row in gridview asp.net webforms
C#
3 votes345 views3 answers
C# random number between 0 and 1
C#
0 vote341 views1 answer
C# i++ meaning
C#
0 vote325 views1 answer
Vb.net how insert event inside an event
C#
1 vote359 views1 answer
Assign datasource to dropdownlist in c#
C#
0 vote351 views1 answer
Persian lorem ipsum
C#
0 vote367 views1 answer
Blocked script execution in '<url>' because the document's frame is sandboxed and the 'allow-scripts' permission is not set.
C#