So how do you get data from SQLite?

Question

SQLite

Help out, explain on your fingers how to get the data from the table.
The docks don't help, or I'm stoned on them, and I don't see the obvious.
Adding and updating records works.

public conn(string namebase)
        {
            string baseName = namebase + ".db";
            string pathString = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "db", baseName);
            string connectionString = string.Format("Data Source={0};", pathString);
            //string CommandText = "SELECT 'name', 'datebirth' FROM 'settungs' WHERE id='2'";
            string CommandText = "SELECT 'name', 'datebirth' FROM 'settungs'";

            SQLiteConnection connection = new SQLiteConnection(connectionString);
            connection.Open();

            SQLiteCommand command = new SQLiteCommand(CommandText, connection);
            SQLiteDataReader reader = command.ExecuteReader();

            while (reader.Read())
            {
                //object name = reader["name"];//System.IndexOutOfRangeException: "Индекс находился вне границ массива."

                //var name = reader[0].ToString();
                //var name = reader[1].ToString();
                //MessageBox.Show(name);// Даёт [0] = name или [1] = datebirth

                //var name = reader.GetName(0).ToString();
                //MessageBox.Show(name);//Даёт 'name'

                //var name = reader.GetValue(0).ToString();
                //var name = reader.GetValue(1).ToString();
                //MessageBox.Show(name);//Также даёт название столбцов
            }

            connection.Close();
        }

Again, without result, it gives only the names of the columns.

for (int i = 0; i < reader.FieldCount; i++)
            {
                
                while (reader.Read())
                {
                    MessageBox.Show(string.Format("{0}\t{1};", reader.GetValue(0).ToString(), reader.GetValue(1).ToString()));
                }
            }

Answer 1

Thanks to curator freeExec. The matter turned out to be in quotation marks, in the request.