delete multiple row in datatable

Question

hi

how to delete multiple row in datatable?
I want to delete a number of rows from the datatable, for example, from row 10- to row 35.
And save the changes to the datatable.

Answer 1

Use Take and Skip to get the data rows to remove then use a for/next to remove the rows. Here I delete the first three rows.

Dim table As New DataTable()  
table.Columns.Add("SomeColumn", GetType(Integer))  
For index As Integer = 0 To 9  
    table.Rows.Add(index)  
Next  
  
  
Console.WriteLine(table.Rows.Count)  
  
Dim rows = table.AsEnumerable().Take(3)  
  
For index As Integer = 0 To rows.Count() - 1  
    rows(index).Delete()  
Next  
  
Console.WriteLine(table.Rows.Count)  

Answer 2

Hi @AMER SAID ,

I want to delete a number of rows from the datatable, for example, from row 10- to row 35.

You can use the following code to do it(code from here).

        Dim rowsToDelete As List(Of DataRow) = New List(Of DataRow)()  
        Dim num As Integer  
        For Each row As DataRow In dt.Rows  
            If num >= 10 And num <= 35 Then  
                rowsToDelete.Add(row)  
            End If  
            num += 1  
        Next  
        For Each row As DataRow In rowsToDelete  
            dt.Rows.Remove(row)  
        Next  

Best Regards,
Xingyu Zhao
*
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.