I have a data table and want to delete all blank rows
I declare a variable = Filterdata has datatype = System.data.DataTable
And assign a value for it as expressions:
DT1.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(“”))).CopyToDataTable()
But the system always displays error like image I attached.
Please, help me if you know about that.
Thank you so much
You can do this using Filter DataTable activity with remove option if the criteria is matching.
And the error your getting due to a datatype conversion, where IEnumerable of DataRows can not be converted into datatable using CopyToDataTable.
If still you want to use linq then try with AsEuumerable
ashokkarale