Catch Error Linq query to check datatable

[NHoe (Norman)]

Hello all,

my Linq command, which I am using thanks to your support, is causing the following error, how can I fix this?

(From d In DT_aus_PDF.AsEnumerable
Where System.Text.RegularExpressions.Regex.IsMatch(d(“Column2”).ToString,“([0-9]{8})”)
Where Not d(“Column3”).ToString=“”
Select d).CopyToDataTable().DefaultView.ToTable(False, “Column1”,“Column2”,“Column3”,“Column4”,“Column5”,“Column6”,“Column7”)

Error Message “PDF in Excel umwandeln: The source contains no DataRows.”

[kumar.varun2 (Varun Kumar)]

Hi @NHoe

This will be helpful for you

[FirstAid] Handling of The source contains no DataRows exception

This FirstAid Tutorial will describe how a the source contains no DataRows EXCEPTION can be handled. Introduction Let’s have a look at the following filter data table scenario: Name CCode Tom US Charlotte FR Seema IN Jean FR Assignment: Filter all rows on a particular Country Code like FR, UK, ES, UK… Ensure that all CCode data column values are trimmed Ensure that the Filter check is case insensitive we can implement it e.g. with the help of a LINQ statement: dtData.As…

Also, you can try this

If(		
		(
			From d In DT_aus_PDF.AsEnumerable()
			Let c1 =  System.Text.RegularExpressions.Regex.IsMatch(d("Column2").ToString,"([0-9]{8})")
			Let c2 =  Not String.IsNullOrEmpty(d("Column3").ToString)
			Where c1 And c2
			Select d
		).Count.Equals(0),	
		_
		Nothing,
		_
		(
			From d In DT_aus_PDF.AsEnumerable()
			Let c1 =  System.Text.RegularExpressions.Regex.IsMatch(d("Column2").ToString,"([0-9]{8})")
			Let c2 = Not String.IsNullOrEmpty(d("Column3").ToString)
			Where c1 And c2
			Select d
		).CopyToDataTable().DefaultView.ToTable(False, {"Column1","Column2","Column3","Column4","Column5","Column6","Column7"})
)

[NHoe (Norman)]

@kumar.varun2

If(		
		(
			From d In DT_aus_PDF.AsEnumerable()
			Let c1 =  System.Text.RegularExpressions.Regex.IsMatch(d("Column2").ToString,"([0-9]{8})")
			Let c2 =  Not String.IsNullOrEmpty(d("Column3").ToString)
			Where c1 And c2
			Select d
		).Count.Equals(0),	
		_
		Nothing,
		_
		(
			From d In DT_aus_PDF.AsEnumerable()
			Let c1 =  System.Text.RegularExpressions.Regex.IsMatch(d("Column2").ToString,"([0-9]{8})")
			Let c2 = Not String.IsNullOrEmpty(d("Column3").ToString)
			Where c1 And c2
			Select d
		).CopyToDataTable().DefaultView.ToTable(False, {"Column1","Column2","Column3","Column4","Column5","Column6","Column7"})

it works, thank you!