Select specific Value from DataTable using LINQ

Help
1

I am having a datatable having Id, System and Date.

I want to extract specific date (a single String/List) based on ID and system.

Please help how to get this using LINQ.

MYDT.AsEnumerable().Where(Function(x) x(“Id”).ToString = row(“ID”).ToString And x(“Name”).ToString = row(“Name”).ToString ).Select(Function(y) y MappedDate).List

2

Hi,
You can use a select query like this
datatable.select(“columnName= 'value '”) this will give you array of datarow.

Let us know if this helps,
Regards,
Pavan H

1 Like
3

Try below query.

(from rw in MYDT where rw(“ID”) = x(“ID”) and rw(“Name”) = x(“Name”) select rw(“Date”)).ToList

1 Like
4

thanks @deepesh.solanki and @pavanh003 . It was helpful. Also I am doing this
and saving this to a datatable however if there is no record, it thorws exception.

Can u suggest here how to handle null value.

Dt_CheckFIle2.Select(“Convert([Cost Centre],‘System.String’)='”+CostCode.ToString()+“'”).CopyToDataTable()

5

@p4uk80 You can run this query in try block and in catch block check the exception message if exception.message = “The source contains no DataRows” than assign some value like True/False in variable and if message is deferent then rethrow the exception.

you can try in this way.

6

Hey,
Once you can check for the count and if condition to check if count greater than zero.

Let us know if this helps,
Regards,
Pavan H