Source Contains No Data Rows || Link Query

[prerna.gupta]

Hi All,
Im using the below Query where
dt_file_name_match = (from r in dt_file_info.Select() where r(“File Name”).ToString.Trim.ToUpper.Equals(str_input_file.ToUpper.Trim.ToString) select r).CopyToDataTable.

In this Query dt_file_info = Data Table which consists ofFilename and File Path
str_input_file = filename

In this Link Query im getting Error as “Source contains no data rows”

Any suggestions ??

[poorna_nayak07 (Poornachandra M)]

Hi,
Try below expression

@prerna.gupta

dt_file_name_match = (from r in dt_file_info.Select() where r(“File Name”).ToString.Trim.ToUpper.Equals(str_input_file.ToUpper.Trim.ToString) select r).CopyToDataTable

dt_file_name_match = If((from r in dt_file_info.Select() where r(“File Name”).ToString.Trim.ToUpper.Equals(str_input_file.ToUpper.Trim.ToString) select r).count>0,(from r in dt_file_info.Select() where r(“File Name”).ToString.Trim.ToUpper.Equals(str_input_file.ToUpper.Trim.ToString) select r).CopyToDataTable,New Datatable)

[prerna.gupta]

@poorna_nayak07

dt_file_name_match = If((from r in dt_file_info.Select() where r(“File Name”).ToString.Trim.ToUpper.Equals(str_input_file.ToUpper.Trim.ToString) select r).count>0,(from r in dt_file_info.Select() where r(“File Name”).ToString.Trim.ToUpper.Equals(str_input_file.ToUpper.Trim.ToString) select r).CopyToDataTable,New Datatable)

Thanks for Quick Response. Tried the same. No success yet. Also the count is greater than 0. In beguf mode the data table ahs 5 rows data in it

[poorna_nayak07 (Poornachandra M)]

dt_file_name_match = If((from r in dt_file_info.AsEnumerable where r(“File Name”).ToString.Trim.ToUpper.Equals(str_input_file.ToUpper.Trim.ToString) select r).count>0,(from r in dt_file_info.AsEnumerable where r(“File Name”).ToString.Trim.ToUpper.Equals(str_input_file.ToUpper.Trim.ToString) select r).CopyToDataTable,New Datatable)

Try this and let me know the result

[prerna.gupta]

I

[kumar.varun2 (Varun Kumar)]

@prerna.gupta

instead of New Datatable use dt_file_info.Clone

[poorna_nayak07 (Poornachandra M)]

Instead of New Datatable, try New System.Data.DataTable or as @kumar.varun2 mentioned use dt_file_info.Clone

[prerna.gupta]

Yup it worked !! Thank You very much !!

[prerna.gupta]

It worked for 1 activity.
But after clone-ing the original data table, in new data table i do not have any rows.
dt_file_name_match has only headers and No Data
Eg - Below Activity is failing as
str_filepath = dt_file_name_match .Rows(0)(1).ToString

[kumar.varun2 (Varun Kumar)]

@prerna.gupta

It will fail because there are no rows in the data table.

[prerna.gupta]

Correct !! So the purpose of using Link Query was to copy the row in New Data Table which we could not achieve

[kumar.varun2 (Varun Kumar)]

@prerna.gupta

What is the workflow?