Convert SQLite select query to string array

Question

I have this code

public static void GetOnline1()
        {
            string query = "SELECT online FROM online";
            SQLiteCommand myCommand = new SQLiteCommand(query, myConnection);
            myConnection.Open();
            SQLiteDataReader result = myCommand.ExecuteReader();
            if (result.HasRows)
            {
                while (result.Read())
                {
                    Console.WriteLine(result["online"]);
                    //result["online"] to string array?
                }
            }
            myConnection.Close();

How i can convert result["online"] to a string array?

Possible duplicate of Fill an array (or arraylist) from SqlDataReader — monstertjie_za
– monstertjie_za, Commented Aug 22, 2019 at 8:44

Chetan · Accepted Answer · 2019-08-22 08:45:55Z

1

You need to create a new list of string before if(result.HasRows).

var list = new List<string>();

And then add result["online"] to list in while loop as following.

while(result.Read())
{
     list.Add(result["online"].ToString());
}

answered Aug 22, 2019 at 8:45

Chetan

6,9314 gold badges24 silver badges33 bronze badges

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

Comments

Shahzad · Accepted Answer · 2019-08-22 08:47:03Z

0

Put the results in a List<string>:

var onlineList = new List<string>();
if (result.HasRows)
{
    while (result.Read())
    {
        Console.WriteLine(result["online"]);
        onlineList.Add(result["online"].ToString());
    }
}

If you need it as an array, you can use this: onlineList.ToArray()

answered Aug 22, 2019 at 8:47

Shahzad

2,0731 gold badge17 silver badges26 bronze badges

Collectives™ on Stack Overflow

Convert SQLite select query to string array

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related