How to remove the DataTable's Row without using loops?

Question

I have one datatable which has

DataTable:

         SeqNo        ItemID        ItemName
        -------       ------        --------
           1            10           AAA
           2            20           BBB
           3            30           CCC

Now I want to remove the Row which has the SeqNo "3".

Now I am doing like this in GridView RowCommand Event:

    if (e.CommandName == "Delete")
        {
            string SeqNo = e.CommandArgument.ToString();
            for (int i = 0; i < DTItem.Rows.Count; i++)
            {
                if (SeqNo == DTItem.Rows[i]["SeqNo"].ToString())
                {
                    DTItem.Rows.Remove(DTItem.Rows[i]);
                }
            }
        }

But without loops, How to remove the row based on this condition?

Why no loops? Obviously loops will be used at some point - even if it's within the library code you call. You can't implement an operation on a collection without a loop of some kind at some point. — James Gaunt
– James Gaunt, Commented Aug 18, 2011 at 10:23

Paolo Falabella · Accepted Answer · 2011-08-18 10:20:06Z

2

try

DataRow[] rows = DTItem.Select(" SeqNo = " + SeqNo );
rows[0].Delete();

answered Aug 18, 2011 at 10:20

Paolo Falabella

26k3 gold badges79 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tu Tran · Accepted Answer · 2011-08-18 10:22:34Z

1

Try this:

DataRow[] rows = DTItem.Select("SeqNo = " + SeqNo);
foreach (DataRow row in rows) {
    DTItem.Rows.Remove(row);
}

answered Aug 18, 2011 at 10:22

Tu Tran

1,9971 gold badge29 silver badges51 bronze badges

Comments

V4Vendetta · Accepted Answer · 2011-08-18 10:22:06Z

0

If you are sure that there is only one and definitely one occurrence of the row you can achieve that as following

dt1.Rows.Remove(dt1.Select("SeqNo= 3")[0]);

answered Aug 18, 2011 at 10:22

V4Vendetta

38.5k9 gold badges83 silver badges84 bronze badges

Comments

KV Prajapati · Accepted Answer · 2011-08-18 10:23:22Z

0

Another option is to use DataView instance.

//Set sort key and order
 DTItem.DefaultView.Sort = "SeqNo";
 DTItem.DefaultView.Delete(DTItem.DefaultView.Find(2));

answered Aug 18, 2011 at 10:23

KV Prajapati

94.8k20 gold badges151 silver badges188 bronze badges

Collectives™ on Stack Overflow

How to remove the DataTable's Row without using loops?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related