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”
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)
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)
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