[Sv] - remove filter-row?

[The GridLock]

Hi,

My source data is datatable with a column checkbox, I have filtered the choices True.

If I want to delete all rows that display after the filter with above condition, how do I delete some specific row at index or all rows?

[Vijayarasan Sivanandham]

Hi Khanh Dang,

Thank you for contacting Syncfusion support.

In the SfDataGrid, you can delete the selected row by pressing the Delete key when theSfDataGrid.AllowDeleting is set to true. Please refer the below user documentation for more details,

UG Link: https://help.syncfusion.com/windowsforms/datagrid/datamanipulation#delete-row 

In another way the selected records can be deleted by using the DeleteSelectedRecords method in SfDataGrid. Please refer the below code snippet, 

btnSelectedRow.Click += BtnSelectedRow_Click;        

 

private void BtnSelectedRow_Click(object sender, EventArgs e) 

{ 

           this.sfDataGrid1.DeleteSelectedRecords(); 

} 

In another case remove the row by condition base in datatable collection in SfDataGrid. Please refer the below code snippet, 

private void BtnDelete_Click(object sender, EventArgs e) 

{ 

     var removeRows = employeeCollection.AsEnumerable().Where(r => (bool)r["IsShipped"] == true).ToList(); 

 

      foreach (var row in removeRows) 

      { 

                employeeCollection.Rows.Remove(row); 

      } 

} 

 

Sample Link: https://www.syncfusion.com/downloads/support/forum/153981/ze/DataTable772939217 

Regards,
Vijayarasan S 

[The GridLock]

Hi Vijayarasan,

I will try them again..

[Vijayarasan Sivanandham]

Hi Khanh Dang

Thanks for the update. 

 

We will wait to hear from you. 

 

Regards, 

Vijayarasan S 

[The GridLock]

Hi Vijayarasan,

Exciting. Thanks for the sample file! It makes sense to me.

[Vijayarasan Sivanandham]

Hi Khanh Dang,

We are glad to know that the reported issue has been resolved. Please get back to us if you have any other queries. As always, we will happy to assist you😊

Regards,
Vijayarasan S