天天看點

datatable篩選、查詢-------linq

</pre><pre name="code" class="csharp">
           
for (int i = 0; i < dt.Rows.Count; i++)
                {
                    var qu = from tb in dt.AsEnumerable()
                             where //tb.Field<long>("pid").ToString() == dt.Rows[i]["pid"].ToString()&&
                             tb.ItemArray[5].ToString() == dt.Rows[i]["PayNo"].ToString()
                             select tb;
                    if (qu.Count() >1)
                    {
                        //有重複
                       //如果去除重複,i = i + qu.Count()-1;
                    } }