Hi All
I have a datatable with values
FAX Column name
“”
100
250
300
260
340
450
400
When we given the datatable .select based on removing data row
Dt3=DT2.Select(“FAX<>‘’”).CopyToDatatable()
It Is getting sorted in ascending order
100
250
260
300
340
400
450
When we givn in linq query((From p In Dt2.Select
Where Not String.IsNullOrEmpty(String.Join(“string.Empty”,p.ItemArray))
Select p).ToArray.CopyToDataTable
FAX
100
250
300
260
340
450
400
May I know the difference between Linq query and datatable.select
I want to know why in select query It has to sort the data?
Thanks
Ashwin S