mysql - asp.net 如何将列值存储在数组中

Question

我在 asp.net 中编写代码。我在数据库中有一个名为 c_name 的列。我想将所有列值存储在一个数组中。这是我不完整的代码。我很困惑在这里做什么。

String str = "select c_name from contacts where user_id = " + user_id + "";

MySqlCommand cmd = new MySqlCommand(str, dbConnection);
cmd.ExecuteNonQuery();

MySqlDataReader mdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);

while (mdr.Read())
{

}

请帮忙。

Answer 1

检查下面的代码:

   String str = "select c_name from contacts where user_id = " + user_id + "";
   MySqlCommand cmd = new MySqlCommand(str, dbConnection);
   MySqlDataReader mdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);

   List<string> list = new List<string>();
   while (mdr.Read())
   {
        list.Add(mdr.GetString(0));
   }

   string[] strMyArray = list.ToArray<string>();