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

11 votes137 views1 answer
How to copy last element in list c#
C#
0 vote133 views1 answer
Query Parent-GrandChild single
C#
1 vote168 views1 answer
Double tryparse dot comma
C#
28 votes144 views2 answers
C# file exist
C#
1 vote248 views1 answer
How set element in middle in bootstrap
C#
1 vote151 views1 answer
How to display an image url in c# picturebox
C#
0 vote148 views1 answer
C# linq to select even numbers
C#
1 vote139 views1 answer
C# wpf datagrid extra column
C#
0 vote139 views1 answer
Parse error message: could not create type webservice.webservice asp .net
C#
0 vote143 views1 answer
C# md5 hash bouncycastle encypt decrypt with key
C#