dt.Rows.Add(dr) '-- use DefaultView to filter the records dw.RowFilter = "Col1 like '%" + txtSearch.Text.Trim() + "%'"Repeater1.DataSource = dw
Repeater1.Data
FROM HSDATA4.DWRECAP (SELECT DW.DWINVNFROM HSDATA4.DWRECAP DW
INNER JOIN HSDATA4.FXVNDCP FX ON DW.DWVNDN = FX.FXVNDNWHERE DW.DWRTPE = 1 AND DW.DWDTEI BETWEEN 20180904 AN