Problem with empty datarow

[supermanPunch (Arpan)]

@Kumar802

DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(“”))).CopyToDataTable()

@Kumar802 ,

The Query gives out an Error if there are no Non-Empty rows present, This is because it is trying to convert empty rows into a Datatable Directly. Instead we could first convert the Filtered rows into an Array/List and then Convert to Datatable if rows exist in the Array. A detailed explanation is provided in the below Tutorial Post :

[FirstAid] Handling of The source contains no DataRows exception

This FirstAid Tutorial will describe how a the source contains no DataRows EXCEPTION can be handled. Introduction Let’s have a look at the following filter data table scenario: Name CCode Tom US Charlotte FR Seema IN Jean FR Assignment: Filter all rows on a particular Country Code like FR, UK, ES, UK… Ensure that all CCode data column values are trimmed Ensure that the Filter check is case insensitive we can implement it e.g. with the help of a LINQ statement: dtData.As…