Datatable query

[Demo_User]

dtoutput = (From d In dtinput.AsEnumerable()
Where not(string.isnullorempty(“name).tostring)
Group d By k=d(“Name”).toString.Trim Into grp = Group Let sum = grp.sum(function(x) cdbl(x(“Value”))) Let ra = New Object(){k,sum} Select r = Dtoutput.Rows.Add(ra)).CopyToDataTable()

This query will select the data which with same name and add the value for the particular name
And also ignore if name column has empty

If no values found ,
I need to add condition that its not throw error source contains no datat rows

[Anil_G (Anil Gorthi)]

@Demo_User

Add a if condition and instead of .CopyToDatatable use .count and check >0 and on then side use this assign

on the else side use dtOutput = dtinput.Clone

cheers

[supermanPunch (Arpan)]

@Demo_User

If no values found ,
I need to add condition that its not throw error source contains no datat rows

Hi @Demo_User ,

You could maybe check on the below post for handling the error :

[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…

[SaiSree_SUVERA]

can any one clear this error

[Anil_G (Anil Gorthi)]

@SaiSree_SUVERA

Thats not an error its a warning because you are using hardcoded filepaths…

And please create separate topic if you have any issue

cheers