Pulling all data from SQLite table column using C# iteration

Question

I've written an SQL query using stringbuilder and send it off to the database using SqlteDataReader as seen below:

string criteria = String.Format("SELECT tile_id FROM {0} WHERE zoom_level = 14", dbTable);
                    SQLiteCommand command = new SQLiteCommand(criteria, dbConn);
                    SQLiteDataReader reader = command.ExecuteReader();

                while (reader.Read())
                {

                        Console.WriteLine("Starting reader: \n");
                        foreach (var i in reader)
                        {
                            Console.WriteLine(i);
                        }
                    }
              isMet = true;
                }
            catch (Exception E )
            {
                Console.Write(E.StackTrace);
            }

dbTable == map. I've ran the above SQL query through an SQLite browser and it's pulled back the correct information.

The returned value is always System.Data.Common.DataRecordInternal and after some Googling around I'm still a little lost. A lot of solutions that I've found implement a DataReader which solves the issue but I'm already using one.

tile_id is stored as TEXT in SQLite, and so far I've tried to retrieve it formatted as string, var and int, all of which have returned the above value.

Can anyone offer some advice?

Rahul · Accepted Answer · 2016-06-29 10:08:48Z

2

You don't need that foreach loop. You should change the reader reading code to be

            Console.WriteLine("Starting reader: \n");
            while (reader.Read())
            {
              Console.WriteLine(reader["tile_id"].ToString());
            }

See Retrieving Data Using a DataReader. for more information.

answered Jun 29, 2016 at 10:08

Rahul

78.1k14 gold badges80 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

James Gould Over a year ago

Great, thank you so much. Always nice to find shorter solutions! Marking as correct.

Zein Makki · Accepted Answer · 2016-06-29 10:12:49Z

1

reader.Read() already moves to the next record if any. So Use:

while (reader.Read())
{
    Console.WriteLine("Starting reader: \n");
    Console.WriteLine(reader.GetString(0));
}

edited Jun 29, 2016 at 10:12

answered Jun 29, 2016 at 10:09

Zein Makki

30.2k6 gold badges58 silver badges66 bronze badges

Collectives™ on Stack Overflow

Pulling all data from SQLite table column using C# iteration

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related