LINQ: Datatable and List join return source contains no data row

Question

LINQ: Datatable and List join return source contains no data row

T.Zacks 3,996

I am joining a datatable and List<string> but getting error that source contaisn no datarow. here is my code. please tell me what mistake i have made for which i am getting error. both list<string> and datatable has data.

                    var result = (from bkr in ds.Tables[2].AsEnumerable()
                                  join prd in Listofperiods
                                      on bkr.Field<string>("StandardDate") equals prd.ToString()
                                  where string.IsNullOrEmpty(bkr.Field<string>("StandardValue"))
                                  select bkr).CopyToDataTable();

Viorel 122.6K Reputation points

2021-04-03T14:02:06.243+00:00

Maybe there are no such rows. Or maybe the comparison of dates is incorrect.

Stefan Krieger 1

How do the values for StandardDate and prd look like?

Maybe your dates have different notations. Try this.

var result = (from bkr in ds.Tables[0].AsEnumerable()
                          join prd in Listofperiods
                              on DateTime.Parse(bkr.Field<string>("StandardDate")).ToString("yyyyMMdd") equals DateTime.Parse(prd).ToString("yyyyMMdd")
                          where string.IsNullOrEmpty(bkr.Field<string>("StandardValue"))
                          select bkr).CopyToDataTable();

Your answer

Viorel 122.6K Reputation points

2021-04-03T14:02:06.243+00:00

Maybe there are no such rows. Or maybe the comparison of dates is incorrect.
Stefan Krieger 1 Reputation point

2021-04-06T13:11:40.497+00:00

How do the values for StandardDate and prd look like?

Maybe your dates have different notations. Try this.

var result = (from bkr in ds.Tables[0].AsEnumerable() join prd in Listofperiods on DateTime.Parse(bkr.Field<string>("StandardDate")).ToString("yyyyMMdd") equals DateTime.Parse(prd).ToString("yyyyMMdd") where string.IsNullOrEmpty(bkr.Field<string>("StandardValue")) select bkr).CopyToDataTable();

Share via

LINQ: Datatable and List join return source contains no data row

Your answer