将 SQLite 选择查询转换为字符串数组

Question

我有这个代码

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();

我如何将 result["online"] 转换为字符串数组？

Answer 1

您需要在之前创建一个新的字符串列表if(result.HasRows)。var list = new List<string>();然后添加result["online"]到 while 循环中的列表，如下所示。while(result.Read()){&nbsp; &nbsp; &nbsp;list.Add(result["online"].ToString());}

Answer 2

将结果放入List<string>：var onlineList = new List<string>();if (result.HasRows){&nbsp; &nbsp; while (result.Read())&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; Console.WriteLine(result["online"]);&nbsp; &nbsp; &nbsp; &nbsp; onlineList.Add(result["online"].ToString());&nbsp; &nbsp; }}如果您需要将其作为数组，可以使用：onlineList.ToArray()