Checking all rows if specific column contains value of "A" if contains value of "A" it will filter the data table get all the rows that have value of "A"

Hi,

Is your issue “The source contains no DataRows” error in the latter expression?
If so, first use ToArray instaead of CopyToDataTable, then check datarow array length.

arrDR = (From BSP094_ADJUSTED_DT.Select() Where r(46).Equials("O") Select r).ToArray()

if (arrDR.Count >0)  then arrDr.CopyToDataTable()

Regards,