foreach loop quits after just adding three values c#
<p>I've this foreach loop which quits after three iterations. My data table is getting all the values but in the end nothing goes as planned.</p>

<p>Here is the code</p>

<pre><code>foreach (DataRow item in dtEq.Rows)
{
    DataRow[] dr = dtData.Select("ManpowerId=" + item.ItemArray[(int)0] + "");

    if (dr.Length &gt; 0)
    {
        foreach (DataRow drFound in dr)
        {
             item.BeginEdit();

             item[dtEq.Columns.IndexOf(drFound[2].ToString()) + 1] = drFound[3];
             item[dtEq.Columns.IndexOf(drFound[2].ToString()) + 2] = drFound[4];
             item.EndEdit();
        }
    }

}
</code></pre>

<p><a href="http://prntscr.com/alxvsa" rel="nofollow">Here is the image</a> that is returned</p>

<p>I ran the query using profiler, it runs perfect.</p>

<p><strong>Update</strong><a href="http://prntscr.com/aly5jm" rel="nofollow">DAL VALUE IS PERFECT</a></p>