如何将DataTable转换为ArrayList [英] How to Convert DataTable To ArrayList

问题描述

任何人都可以教我如何将数据表转换为arraylist或循环数据表内容，我的数据表只有1列。

我没有谷歌抱歉:)

谢谢

Hi , can anyone teach me how to convert data table to arraylist or to loop data table contents, my datatable has only 1 column.
I dont have google sorry :)
Thanks

推荐答案

ArrayList rows = new ArrayList();

foreach (DataRow dataRow in myDataTable.Rows)
    rows.Add(string.Join(";", dataRow.ItemArray.Select(item => item.ToString())));

使用过时的ArrayList .Use List< string>是不明智的。相反，因为行是字符串：

这可能有用。

It is unwise to use the obsolete ArrayList .Use List<string> instead, since the rows are strings:
This may work.

//create DataTable
           DataTable dt = new DataTable();
           dt.Columns.Add("Name", typeof(string));
           for (int i = 1; i < 10; i++)
           {
               DataRow dr = dt.NewRow();
               dr["Name"] = "Test" + i.ToString();
               dt.Rows.Add(dr);
           }

           ArrayList arrayList = new ArrayList();
           //create arraylsit from DataTable
           foreach (DataRow dr in dt.Rows)
           {
               arrayList.Add(dr["Name"]);
           }

           //read ArrayList items
           foreach (var item in arrayList)
           {
               Response.Write(item + "<br />");
           }

这是一个将 DataTable 转换为<$的示例c $ c> ArrayList 。

Here is an example to convert DataTable into ArrayList.

public ArrayList ConvertDataTableToArrayList()
{
   DataTable dtTable = GetDataTable();
   ArrayList myArrayList = new ArrayList();
   for (int i = 0; i <= dtTable.Rows.Count - 1; i++)
   {
     for (int j = 0; j <= dtTable.Columns.Count - 1; j++)
     {
          myArrayList.Add(dtTable.Rows[i][j].ToString());
     }
   }
   return myArrayList;
}

希望它可以帮到你。

Hope it helps you.

这篇关于如何将DataTable转换为ArrayList的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！