<div>
Simple - inside a foreach you have the collection as readonly. &nbsp;(Otherwise it can lose track of where it is).<br />
<br />
Solution - don't use a foreach loop, use something else such as a simple for loop.
</div>


Simple - inside a foreach you have the collection as readonly.  (Otherwise it can lose track of where it is).

Solution - don't use a foreach loop, use something else such as a simple for loop.

<div>
Andy, I changed it to:<br />
<br />

<pre><code id="code-20-38421799-1"> foreach (DataRow row in dt2.Rows)
{
       	DataRow[] rows = dt.Select(&quot;Field1 ='&quot; + row[&quot;Field2&quot;].ToString() + &quot;'&quot;); 
	for(int i=0; i&lt;=rows.Length-1;i++)
                                rows[i].Delete();}</code></pre>
<br />
but nothing has changed
</div>


Andy, I changed it to:



 foreach (DataRow row in dt2.Rows)
{
       	DataRow[] rows = dt.Select("Field1 ='" + row["Field2"].ToString() + "'"); 
	for(int i=0; i<=rows.Length-1;i++)
                                rows[i].Delete();}


but nothing has changed

<div>
Sneaky - removing from the original collection instead of the intermediate collection you foreach through.
</div>


Sneaky - removing from the original collection instead of the intermediate collection you foreach through.

<div>
<div class="content wysiwyg-content">
Somehow I can't figure out why my code does not allow me to delete a row from a datatable.<br />
<br />
I have two datatables dt and dt2. I want to loop throught dt2 and delete all the rows from dt where field Field1 equals the field Field2 in dt2.<br />
<br />
below is my code that seems to find the records but does not delete them<br />
<br />

<pre><code id="code-10-27873391-1"> foreach (DataRow row in dt2.Rows)
{
       	DataRow[] rows = dt.Select(&quot;Field1 ='&quot; + row[&quot;Field2&quot;].ToString() + &quot;'&quot;); 
	foreach (DataRow drow in rows) 
        	row.Delete(); 
}</code></pre>
</div>
</div>


Somehow I can't figure out why my code does not allow me to delete a row from a datatable.

I have two datatables dt and dt2. I want to loop throught dt2 and delete all the rows from dt where field Field1 equals the field Field2 in dt2.

below is my code that seems to find the records but does not delete them

(CODE)

Cannot delete a row from datatable

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).