本文介绍了将数据库中的字段存储在数组C#中的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试将Microsoft Access数据库中某个列中的所有字段存储在一个数组中.我正在使用OleDb,但我真的不知道该怎么做.
I am trying to store all fields from a column in my microsoft access database in an array. I am using OleDb but I don't really know how to go about doing this.
我知道我必须要循环遍历表,因为表中有行,但是我不知道如何将当前字段存储在数组的当前索引中. 任何帮助将不胜感激!
I know that I have to have a loop to go over the table the amount of times as there are rows in the table, but I don't know how to store the current field in the current index of the array. Any help would be greatly appreciated!
以下是其中一些代码段:
Here is a snippet of some of the code:
string[] tasks; string sql = "SELECT [Task Name] FROM Tasks"; OleDbCommand cmd = new OleDbCommand(sql, conn); OleDbDataReader dataReader = cmd.ExecuteReader(); if (dataReader.HasRows) { for (int i = 1; i <= 10; i++) { //tasks[i] = current field in table } }推荐答案
听起来像您想要这样的东西吗?
Sounds like you want something like this?
string[] tasks; string sql = "SELECT [Task Name] FROM Tasks"; using (OleDbCommand cmd = new OleDbCommand(sql, conn)) { using (OleDbDataReader dataReader = cmd.ExecuteReader()) { List<object[]> list = new List<object[]>(); if (dataReader.HasRows) { while (dataReader.Read()) { object[] oarray = new object[dataReader.FieldCount]; list.Add(oarray); for (int i = 1; i <= dataReader.FieldCount; i++) { oarray[i] = dataReader[i]; } } } } }更多推荐
将数据库中的字段存储在数组C#中
发布评论