mysql查询数据导入到数组中,如何将数据库查询结果添加到数组

最新推荐文章于 2024-07-30 03:57:26 发布

weixin_39705065

最新推荐文章于 2024-07-30 03:57:26 发布

阅读量1.1k

点赞数

文章标签： mysql查询数据导入到数组中

本文展示了如何从数据库查询中获取数据并将其存储到数组或列表中。建议使用List(Of String)而非字符串数组，以利用其灵活性。提供了一个公共函数作为示例，演示了如何将查询结果转换为List并返回，以及如何消费这个函数来打印列表或数组内容。

摘要由CSDN通过智能技术生成

I am trying to select string values from an Access database and then place them into an array of strings so that I can perform a loop statement on the array.

However I don't know how to place the result of the query into an array. I know how to query the database but all I need is how to put the result in an array.

My select statement is Select motonum from moto. I want to put motonum in an array.

The whole code to read the data is:

connect2()

If Not cnn2.State = ConnectionState.Open Then

'open connection

cnn2.Open()

'MessageBox.Show("chk2")

End If

cmd5.Connection = cnn2

cmd5.CommandText = "Select motonum from moto"

myData5 = cmd5.ExecuteReader

While myData5.Read