How to delete a row from a datatable?

Question

How to delete a row from a datatable_ Consider I have 12 rows in my data table, I need to delete one of them using particular row value ..

datatable :

Field Name | Field Type 
------------------------
FirstName  |  Text box
           |
LastName   |  Text box

I need to delete the selected row form the table itself using below code snippet I can retrieve FirstName

string value = (string)selectedRows[i].Cells[0].Value;
Console.WriteLine(outdex);

But how delete it from the data table

Can any one help me out please?

Update your old question instead of asking a new one - http://stackoverflow.com/questions/15247850/how-to-delete-a-particular-value-from-a-datatable-in-c-sharp/15248019?noredirect=1#comment21503697_15248019 — LukeHennerley, Mar 06 '13 at 13:50

score 2 · Accepted Answer · answered Mar 06 '13 at 13:54

From the OP other question, he wants to get a selected row from a DataGridView and remove this row from a temporary DataTable.

//Get the row that is selected
DataGridViewRow dr = selectedRows.Cast<DataGridViewRow>().FirstOrDefault();
//Your temp DataTable
DataTable dtTemp = new DataTable();
//If there is a row selected
if (dr != null)
{
  var rowToRemove = dtTemp.Rows.Cast<DataRow>().FirstOrDefault(row => row[0] == dr.Cells[0].Value);
  if (rowToRemove != null)
    dtTemp.Rows.Remove(rowToRemove);
}

Vishal Suthar · Answer 2 · 2013-03-06T13:56:48.430

1

Here you go:

dt.Rows.Cast<DataRow>()
       .Where(r => r.ItemArray[0] == "Any_Value")
       .ToList()
       .ForEach(r => r.Delete());

OR

DataView view = new DataView(dt);
view.RowFilter = "Column_name = 10";

foreach (DataRowView row in view)
{
  row.Delete();
}

edited Mar 06 '13 at 13:56

answered Mar 06 '13 at 13:51

Vishal Suthar

17,013
3
59
105

score 1 · Answer 3 · answered Mar 06 '13 at 13:51

1

Try using the following code,

  var rows = dataTable.Select("condition to select");
    rows.ForEach((r) => r.Delete(););
    dataTable.AcceptChanges();

answered Mar 06 '13 at 13:51

Rajesh Subramanian

6,400
5
29
42

score 0 · Answer 4 · edited May 23 '17 at 12:05

0

if (value == "some deleteValue")
    selectedRows[i].Delete();

If doing this in a loop though, you'd want something more like this answer though: Deleting specific rows from DataTable

edited May 23 '17 at 12:05

Community

1
1

answered Mar 06 '13 at 13:51

jordanhill123

4,142
2
31
40

How to delete a row from a datatable?

4 Answers4