using System;

using System.Data;

using System.Xml;

​

public class Program

{

    public static void Main()

    {

        DataTable dt = getData();

        Console.WriteLine("Printing all Rows of Table");

        foreach (DataRow orow in dt.Rows)

        {

            Console.WriteLine("PrimaryID:{0}, ID:{1}, Name:{2}", orow[0].ToString(), orow[1].ToString(), orow[2].ToString());

        }

​

        //Error code try to delete with Foreach rows...

        try

        {

            DataTable dt1 = getData();

            foreach (DataRow orow in dt1.Rows)

            {

                if (orow["ID"].ToString().Equals("2"))

                {

                    dt1.Rows.Remove(orow);

                }

            }

        }

        catch (Exception er)

        {

            Console.WriteLine();

            Console.WriteLine("Error while using for each loop with rows {0} ", er.ToString());

        }

​

        //Correct way of Doing

        DataTable dt2 = getData();

        foreach (DataRow orow in dt2.Select())

        {

            if (orow["ID"].ToString().Equals("2"))

            {

                dt2.Rows.Remove(orow);

            }

        }

​

        dt2.AcceptChanges();

        Console.WriteLine();

        Console.WriteLine("After removing all Rows with ID 2");

        foreach (DataRow orow1 in dt2.Rows)

        {

            Console.WriteLine("PrimaryID:{0}, ID:{1}, Name:{2}", orow1[0].ToString(), orow1[1].ToString(), orow1[2].ToString());

        }

    }

​

    public static DataTable getData()

    {

        DataTable dt = new DataTable();

        dt.Columns.Add("PrimaryID");

        dt.Columns.Add("ID");

        dt.Columns.Add("Name");

        DataRow orow = dt.NewRow();

        orow["PrimaryID"] = "1";

        orow["ID"] = "1";

        orow["Name"] = "Bobby";

        dt.Rows.Add(orow);

        orow = dt.NewRow();

        orow["PrimaryID"] = "2";

        orow["ID"] = "1";

        orow["Name"] = "Bob1";

        dt.Rows.Add(orow);

        orow = dt.NewRow();

        orow["PrimaryID"] = "3";

        orow["ID"] = "2";

        orow["Name"] = "Jones";

        dt.Rows.Add(orow);

        orow = dt.NewRow();

        orow["PrimaryID"] = "4";

        orow["ID"] = "2";

        orow["Name"] = "Gibson";

        dt.Rows.Add(orow);

        orow = dt.NewRow();

        orow["PrimaryID"] = "5";

        orow["ID"] = "3";

        orow["Name"] = "Sandy";

        dt.Rows.Add(orow);

        orow = dt.NewRow();

        orow["PrimaryID"] = "5";

        orow["ID"] = "3";

        orow["Name"] = "Kaytee";

        dt.Rows.Add(orow);

        return dt;

    }

}