从datatable到array，没有循环 [英] from datatable to array، no loop

问题描述

以下代码传输到列表框是：

Following Code for transmission to the list box is :

            DataTable dt = new DataTable();

        DataColumn dc = new DataColumn("BestSite", typeof(string));

        dt.Columns.Add(dc);

        for (int i = 1; i <= 10; i++)
        {
            DataRow dr = dt.NewRow();
            dr[0] = i.ToString() + " = stackoverflow";
            dt.Rows.Add(dr);
        }//EndFor

        var Query = from mycolumn in dt.AsEnumerable()
                    where mycolumn.Field<string>("BestSite") != string.Empty
                    select mycolumn;


        listBox1.DataSource = Query.AsDataView();

        listBox1.DisplayMember = "BestSite";

转移到数组应该是什么？ no loop

Transfer to array what should be? no loop

  string[] myvalue = new string[Query.AsDataView().Count];

推荐答案

如果我正确理解你的问题， p>

If I understood your question correctly...

string[] myvalue = Query.Select(i => i.Field<string>("BestSite")).ToArray();

这篇关于从datatable到array，没有循环的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！