dt.Select() with numerous variables added

[Nrenaud1 (Nick)]

assigning to an array of data row

arr_dtrow = dt_InvoiceSearch.Select(“Invoice Item=”+InvoiceItem+“AND Date=”+InvoiceDate)

keep getting error : assign: syntax error: missing operand after ‘item’ operator.
please help

[AshwinS2 (Ashwin S)]

Hi @Nrenaud1

Arr_dtrow=dt_InvoiceSeArch.Select(“Invoice Item='”+invoiceitem’“+ And dAte='”+invoiceDAte+'")

ThAnks

Ashwin S

[Nrenaud1 (Nick)]

That is not working still getting compiler errors

[cmolina (Carlos Molina)]

Hi @Nrenaud1,

Try like this

arr_dtrow = dt_InvoiceSearch.Select(“[Invoice Item]=‘”+InvoiceItem+“’ AND Date=‘”+InvoiceDate+"’")